Hello,

We are getting the following error when trying to access the QODBC driver:

Keyword not supported: 'driver'.

using the example connection string:

Driver={QODBC Driver for QuickBooks};OptimizerDBFolder=C:\Program Files\QODBC Driver for QuickBooks\Optimizer;IBizRemotePWD=######;IBizRemoteConnect=Yes;IBizRemoteURL=http://aaabbb.com:2080; IBizRemoteConnTimeOut=120;IBizRemotePromptForPWD=No;IBizRemoteForce2002_2003=Yes; OpenMode=M;DFQ=C:\QBOOKS\DW.QBW;OLE DB Service=-2

(url and password modified to protect security)

We are trying to open the remote driver on our server, any suggestions on where to start? We are running Windows 2000 and IID on .net 1.1 (VB)

Thanks in advance,

Rob

Your missing the start of the statement. Here's a full example for context:

Visual Basic 6 Example
Requires project reference to Microsoft ActiveX Data Objects 2.x Library

'*****************************************
Dim oConnection     As ADODB.Connection
Dim oRecordset      As ADODB.Recordset
Dim sMsg            As String
Dim sConnectString  As String
Dim sSQL            As String
 
sConnectString = "Driver={QODBC Driver for QuickBooks};DFQ=C:\Program Files\QODBC Driver for QuickBooks\sample04.qbw;OpenMode=M;OLE DB Services=-2;"
sSQL = "SELECT Name FROM Employee"
Set oConnection = New ADODB.Connection
Set oRecordset = New ADODB.Recordset
 
oConnection.Open sConnectString
oRecordset.Open sSQL, oConnection, adOpenStatic, adLockOptimistic
sMsg = "**********************" & Chr(10)
Do While (Not oRecordset.EOF)
    sMsg = sMsg & oRecordset.Fields("Name") & Chr(10)
    oRecordset.MoveNext
Loop
sMsg = sMsg & "**********************" & Chr(10)
MsgBox sMsg
 
oRecordset.Close
Set oRecordset = Nothing
oConnection.Close
Set oConnection = Nothing
'*****************************************

See: How do I build a connection string with all the available QODBC parameters? for more.

QODBC needs to talk to QuickBooks, it doesn't talk to the company file directly. The DFQ reference is used to tell QuickBooks which company file we wish to talk to. By the sound of things, QuickBooks isn't on your Web Server, so you need to use the QODBC Remote Connector connection string to send the request to your Department Server. The DFQ line is set to the local location of the file on your Department Server.

A .NET application running as a Windows Service (ASP.NET) connection requires either a QODBC Server Edition and the DCOM Servers or a QODBC Remore Connector.