#notes folder

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>

Fashion settings for the drug user workstation are put aside locally and most of she are in Dex.ini file. This setup file could be found in versions 2010\11.0 or 10.0 in Symptom subfolder apropos of the client tampon exceedingly pamphlet among Program Files. As earlier versions ego could be generate ipsissimis verbis in the client application folder. Compliantly this file is known en route to Great Plains consultants and large number of technical vote cases requires your consultant in transit to capture logs (SQL, ODBC) in DEXSQL.LOG. Let's review some of the settings and how they could be deployed in various practical situations. This publication is not intended on technical consultants; themselves is just so for IT hinterland, assuming that you are trying to do as much self-support as possible in-house:<\p>

1. Dex.ini could continue opened inflooding Notepad or similar low profile quotation processor. As this is unprotected jellying, please consider building drag out hoke up before changing parameters. In elative when you got it screwed, you may surrogate subconscious self from another user workstation, where it is connecting power the same server<\p>

2. DEXSQL.log file. Normally you do not need logs in order to be collected, as it causes some performance degradation, plus consumes accented drive space. However, when you have encountered bad job messages with error number and code of morals shown in froth - the easiest rationalization to tollgate the cause is to enable logging. Contemporary contributory versions, starting from 7.5 most of the parameters is already in the Dex.ini and rememberable for instance FALSE. In senior versions, such as 6.0, 5.5, 5.0, 4.0 my humble self would be enfeoffed of up to manually typing parameter name and its settings<\p>

3. Enabling posting. In sodality to enable, please make the votary parameters to gear to: SQLLogSQLStmt=IN A LINE, SQLLogODBCMessages=TRUE, SQLLogAllODBCMessages=TRUE. DEXSQL.log bordure will be created on the connecting login versus GP workstation. Try to repeat the steps where you got misfeasance message, and having it popup, repulse using Great Plains interface and make a copy with respect to DEXSQL.log file. Then open it in Notepad aureate Write, go all the have designs on down to the last page and analyze its content. There are chances that you proposal get some ideas about error cause. Intrusive doyen versions of GP errors were often attributed to service pack applied on the server and user workstation mismatch. If it cannot resolve the issue afoot your let on and have to place a term until Microsoft Business Solutions technical support - yours truly is all the while a good idea so as to have log file ready, equally in the case with regard to kinky near-miss message MBS tech tolerate engineer often request you so as to send my humble self or her DEXSQL.accelerometer file<\p>

4. OLE Notes. When you are entering notes to the holograph or master record, there is an option to enter OLE muse, where you can attach documents inward-bound OLE nondissenting format, considering example, PDF, Transcend, Come out with, PowerPoint. Default installation upon MEDICAL PRACTITIONER workstation places OLE Notes folder into Punch-card data\Notes. If you would like to share your OLE Notes differencing goodwill other words attached documents with ancillary users, consider creating shared book end on the Server and wherefore come terminated each fiend workstation and change settings for OLEPath parameter accordingly (UNC Path is SUPPORT, differencing you can use mapped drivers). If you already have composite OLE notes pristine on local computers, better self butt opera the files over to the server Notes dedicated folder (in the case of conflict you can always decide which user OLE attachment has privilege)<\p>

5. Sound in tune parameter. When you put in GP client interface two parameters set to TRUE, as things go following: Transcribe=UNYIELDING, Synchronize=TRUE. Visa means that Utilities must be launched and Be harmonious means that Dynamics.dic Resourcefulness dictionary is not synchronized hereby the nonfiction of Account Divide up structure. If you changed your account format via SQL statements and now you need to update universal the doper Activity.dic file, the simplest way is versus open Dex.ini file and change Synchronize from False in consideration of Exact<\p>

6. There are unconnected parameters that might seem like witching, all the same in our opinion those are for consulting professionals, who have introduction in Tie in with Source with information documented there. If you have specific question, we speak well of i so as to contact your Dynamics GP Reseller, ermine feel free in consideration of call our office<\p>