Knowledgebase
[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

Instructions

      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 applications & "QuickBooks Data 64-bit QRemote" for 64-bit applications 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 make.

      Normally ADO pools connections. QRemote does not support connection pooling. It is recommended to tell ADO not to do connection pooling on any QRemote connection. This is done with OLE DB Services=-2.

Parameters available on the connection string

bullet IP Address = IP address of QRemote Server.

bullet Port = IP address of QRemote Server.

bullet EncryptionKey = Encryption Key settled in QRemote Server. (If you have set Encryption Key in QRemote Server.) By default, it is blank.

bullet RemoteDSN = Remote DSN which you want to use. By default, it is "QuickBooks Data."

bullet OLE DB Services=-2

Example of simple DSN
32-bit:
sConnectString = "DSN=QuickBooks Data QRemote;OLE DB Services=-2;"

64-bit:
sConnectString = "DSN=QuickBooks Data 64-bit QRemote;OLE DB Services=-2;"

Example of a DSNless connection string
Without Encryption Key:
sConnectString = "Driver={QRemote for QuickBooks};OLE DB Services=-2;IPAddress=127.0.0.1;Port=4500;RemoteDSN=QuickBooks Data;"

With Encryption Key:(Replace 123456 with your Encryption Key value)
sConnectString = "Driver={QRemote for QuickBooks};OLE DB Services=-2;IPAddress=127.0.0.1;Port=4500;EncryptionKey=123456;RemoteDSN=QuickBooks Data;"

Standard syntax
"Driver={QRemote for QuickBooks};OLE DB Services=-2;IPAddress=127.0.0.1;Port=4500;"

 

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).