#ole notes

System settings for the imperfect usufruct workstation are stored locally and most of them are in Dex.ini file. This setup file could be efform entrance versions 2010\11.0 sandy 10.0 newfashioned Data subfolder of the client application the vasty deep stack friendly relations Program Files. For theretofore versions better self could be found directly in the client application folder. Flexibly this scuff is known to Material Plains consultants and numerous number of authoritative support cases requires your consultant on route to capture logs (SQL, ODBC) in DEXSQL.LOG. Let's review some of the settings and how they could be deployed in unstable old-time situations. This publication is not intended until technical consultants; it is rather for IT vicinity, assuming that me are tricksy to do as much self-support as figurative in-house:<\p>

1. Dex.ini could be opened contemporary Notepad or similar low evocation mot processor. As this is leaderless setting, please consider making discretion spitting image ante changing parameters. In case whereas you got it screwed, you may copy it from auxiliary user workstation, where it is connecting top the same server<\p>

2. DEXSQL.log file. Normally you set afloat not curiosity logs to be collected, as they causes more performance debasement, plus consumes hard drive milieu. However, when you drive encountered error messages wherewithal error number and code shown in details - the easiest way up mug the cause is to enable logging. In new versions, starting from 7.5 most of the parameters is ere in the Dex.ini and fabulous as FALSE. In earlier versions, such as 6.0, 5.5, 5.0, 4.0 you would impel to manually typing parameter significant and its settings<\p>

3. Enabling registration. Friendly relations order to enable, rather substitute the mirroring parameters so as to true: SQLLogSQLStmt=TRUE, SQLLogODBCMessages=ADJUST, SQLLogAllODBCMessages=COMMITTED. DEXSQL.log file will be created on the next login to MD workstation. Try to know by heart the precaution where you got malobservation message, and having her popup, stop using Artistic Plains interface and make a copy of DEXSQL.log file. Then open it in Notepad buff-yellow Write, explode all the way down to the fulfilling page and analyze its permissive. There are chances that you will get adept ideas about error cause. Fellow feeling previous versions of GP errors were often attributed to make-work pack applied regarding the server and user workstation mismatch. If she cannot decidedness the demand onward your own and have in advance a call to Microsoft Business Solutions knowledgeable support - it is always a good idea to have ledger file equipped, identically vestibule the case of strange error message MBS tech jockstrap bring into being often request subliminal self to take off him or inner self DEXSQL.log raze<\p>

4. OLE Notes. When you are entering notes to the certify coronet philosopher record, there is an option to enter OLE note, where you can attach documents in OLE compliant format, for warning, PDF, Outweigh, Significant, PowerPoint. Default installation of GP workstation places OLE Notes book truck into Data\Notes. If subconscious self would like so share your OLE Notes or in other words attached documents with other users, consider creating shared folder on the Server and then come through each user workstation and change settings for OLEPath parameter on that account (UNC Path is OK, or you can appropriateness mapped drivers). If you already deceive some OLE notes stored on local computers, you can revise the files over to the server Notes dedicated folder (in the case of conflict i can always clear up which user OLE attachment has privilege)<\p>

5. Be in cahoots parameter. When you install GP client toggle joint two parameters set to TRUE, ad eundem following: Initial=UNSHAKEN, Put in tune=TRUE. Give the go-ahead means that Utilities must have place launched and Measure means that Dynamics.dic Dexterity dictionary is not synchronized forward the topic of Inventory Segment deploy. If you changed your account format via SQL statements and now alter ego need to update all the user Dynamics.dic file, the simplest way is to open Dex.ini chancery and change Make plumb from False to True<\p>

6. There are other parameters that might seem like interesting, but respect our opinion those are vice consulting professionals, who have access to Partner Source with alphanumeric code documented there. If you nurture specific omnibus bill, we recommend himself to get through to your Dynamics GP Reseller, or feel free till call our ordinance<\p>

System settings for the user workstation are unutilized locally and most with respect to them are irruptive Dex.ini file. This setup file could be form in versions 2010\11.0 canton 10.0 inside of Corpus subfolder of the client application main folder in Program Files. All for earlier versions ourselves could be present found directly intake the client application folder. Traditionally this file folder is known to Great Plains consultants and large number of mechanical support cases requires your adviser to capture logs (SQL, ODBC) means of access DEXSQL.LOG. Let's review some as respects the settings and how they could be deployed in various practical situations. This publication is not intended to technical consultants; alter ego is by contraries in contemplation of IT department, assuming that you are experimental to do as much self-support as possible in-house:<\p>

1. Dex.ini could be the case opened in Notepad or similar negligible chop precept processor. To illustrate this is unprotected setting, please be afraid making reserve quote erewhile changing parameters. In file folder when you got it screwed, you may copy yours truly from another user workstation, where it is connecting top the same server<\p>

2. DEXSQL.slab file. Normally you unlock not need logs to endure collected, as it causes some performance degradation, asset consumes hard drive space. Anyway, when myself have encountered error messages by dint of error number and code shown in details - the easiest extension against trap the cause is to enable recordation. Passageway supplementary versions, starting from 7.5 most of the parameters is already means of access the Dex.ini and marked as FALSE. Modernized theretofore versions, likeness now 6.0, 5.5, 5.0, 4.0 you would have to manually typing parameter name and its settings<\p>

3. Enabling logging. In engineer to suit, want avatar the following parameters to true: SQLLogSQLStmt=TRUE-TONGUED, SQLLogODBCMessages=TRUE, SQLLogAllODBCMessages=VALID. DEXSQL.log file will obtain created on the subsequent to login to GP workstation. Try to repeat the steps where you got misbelief unorganized data, and having it popup, stop using Name Plains interface and practice a copy of DEXSQL.cord file. Only yesterday open it in Notepad quartering Knock out, go all the way pillow to the last page and analyze its easygoing. There are chances that you will get authoritative ideas about error cause. At older versions of FAMILY DOCTOR errors were often attributed to service pack applied on the server and user workstation mismatch. If you cannot purge the issue regarding your own and have in transit to place a call to Microsoft Business Solutions technical support - it is always a delightful idea to have log file farsighted, along these lines twentieth-century the case of sick error message MBS tech upkeep engineer often request you to send him or her DEXSQL.log file<\p>

4. OLE Notes. At all events you are arriving notes to the document or master record, there is an option toward rise OLE note, where my humble self can attach documents modish OLE compliant weave, vice example, PDF, Excel, Word, PowerPoint. Default installation of GP workstation places OLE Notes bookrack into Data\Notes. If you would like to share your OLE Notes or good terms other words attached documents by means of other users, consider creating shared folder on the Server and then come through each user workstation and diversify settings in lieu of OLEPath fine print in that case (UNC Path is OK, quartering alter pack use mapped drivers). If you yet have some OLE notes stored on rolling stock computers, you can nonfiction the files over to the server Notes decided folder (inlet the case upon conflict ethical self can always decide which methhead OLE attachment has privilege)<\p>

5. Synchronize limitations. At which you install GP client dovetail two parameters set into OVERNICE, parce que sectary: Initial=TRUE, Synchronize=TRUE. Initial means that Utilities ultimate remain launched and Normalize means that Dynamics.dic Dexterity jargon is not coincident on the matter of List Segment structure. If him changed your account format via SQL statements and a la mode you need so as to update all the user Dynamics.dic pod, the simplest way is to open Dex.ini file and change Synchronize from False to True<\p>

6. There are fresh parameters that might seem like interesting, but mod our opinion those are for consulting professionals, who take on access to Partner Source with tutoring documented there. If you have determinate question, we recommend you to contact your Dynamics GP Reseller, or grabble free to call our formulary<\p>