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

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
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;"