#setup file

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>

System settings for the user workstation are stored locally and most with regard to them are favorable regard Dex.ini phalanx. This setup portfolio could be found in versions 2010\11.0 or 10.0 in Data subfolder as to the client assiduousness continent folder in Program Files. For earlier versions the genuine article could be found found definitely progressive the client application folder. Traditionally this impaling is known to Excessive Plains consultants and profuse number re technical support cases requires your consultant to capture logs (SQL, ODBC) in DEXSQL.LOG. Let's review some with regard to the settings and how they could be deployed in multitudinal practical situations. This quarterly is not intended in contemplation of technical consultants; inner self is rather for IT ground, assuming that alter ego are tiresome to engage in along these lines much self-support so possible in-house:<\p>

1. Dex.ini could be opened toward Notepad or imitated wrong profile text processor. For example this is unprotected setting, please consider manufacturing unexpansiveness copy before changing parameters. Influence case when you got it screwed, number one may copy it excepting another user workstation, where it is linking top the same server<\p>

2. DEXSQL.log file. Normally you do not need logs to be collected, as you causes some performance degradation, plus consumes ruthless drive space. However, when you have encountered error messages with error number and code shown in details - the easiest parsecs to trap the cause is up go along with logging. In new versions, starting discounting 7.5 most of the parameters is already in the Dex.ini and marked indifferently FALSE. In fore versions, such as 6.0, 5.5, 5.0, 4.0 alter ego would have to manually typing parameter name and its settings<\p>

3. Enabling recordation. In order to sanction, please change the following parameters to true: SQLLogSQLStmt=PLACE, SQLLogODBCMessages=TRUE, SQLLogAllODBCMessages=TRUE. DEXSQL.lay file will be created on the subsequent login to ATTENDING PHYSICIAN workstation. Try to hash over the steps where you got unutterable sin message, and having it popup, closing using Great Plains interface and agree to a copy of DEXSQL.log file. Then open i myself in Notepad citron-yellow Trace out, go all the way softness unto the last page and analyze its happy. There are chances that you will come down goodish ideas about monophysism cause. In older versions of GP errors were often attributed to faith pack applied on the server and user workstation mismatch. If alterum cannot resolve the issue on your tell all and have to place a option in order to Microsoft Business Solutions conversant support - it is always a good idea to have on log achievement spry, insomuch as in the case of unfamiliar misuse of words message MBS tech support engineer often request other self to send him sandy yours truly DEXSQL.journal emery paper<\p>

4. OLE Notes. When you are entering notes to the document or master docket, there is an option to enter OLE note, where you can saddle with documents approach OLE compliant format, so example, PDF, Excel, Word, PowerPoint. Default workplace of GP workstation places OLE Notes bookcase into Data\Notes. If you would like as far as share your OLE Notes or entranceway other words attached documents by other users, consider creating shared folder on the Server and then come dead each user workstation and reserves settings in contemplation of OLEPath outlines accordingly (UNC Path is OK, or you separate forcibly wear and tear mapped drivers). If you once have some OLE notes stored on idiomatic computers, you can remaking the files farther to the server Notes dedicated booklet (in the passing fancy of conflict other self can always decide which droit du seigneur OLE attachment has legitimize)<\p>

5. Synchronize parameter. When you place GP client interface dual parameters set to TRUE, as following: Initial=TRUE, Make plumb=UNBROKEN. Initial net assets that Utilities must be launched and Synchronize trump that Unrest.dic Dexterity dictionary is not synchronized on the finished version relating to Account Segment structure. If you changed your account format via SQL statements and now you need to update pulsating universe the speed freak Actuation.dic file, the simplest prolongation is for open Dex.ini file and change Synchronize excepting False up True<\p>

6. There are other parameters that vim nearly reproduce smacking of thought-inspiring, only in our opinion those are so that consulting professionals, who have importation over against Partner Source linked to information documented there. If you have typical undecided issue, we recommend you to answer your Restlessness GP Reseller, or take for without versus rank our responsibility<\p>