[QODBC-Desktop] Troubleshooting - How do I build a connection string with all the available QRemote parameters / Connection String with QRemote Parameters.
Posted by Jack - QODBC Support on 08 September 2015 07:30 AM
General Connection String
The most difficult part of using QRemote in programming is the connection string. The simplest form includes a reference to a DSN. A system DSN called "QuickBooks Data QRemote" for 32-bit application & "QuickBooks Data 64-bit QRemote" for 64-bit application is automatically created when QODBC is installed. "QuickBooks Data QRemote" will be used in all examples but can be substituted for any different DSN name you create.
Parameters available on the connection string
IP Address = IP address of QRemote Server.
Port = IP address of QRemote Server.
EncryptionKey = Encryption Key settled in QRemote Server. (If you have set Encryption Key in QRemote Server.) By default it is blank.
RemoteDSN = Remote DSN which you want to use. By default, it is "QuickBooks Data".
OLE DB Services=-2
Example of simple DSN