I installed the QODBC per instructions and am able to query customer names through your included VB test tool.  However, when I try to access the same quickbooks file via my asp script, the browser window just sits there.

Here is my code:

Dim rs, strSQL

'Create an ADO connection object
Set adoCon = Server.CreateObject("ADODB.Connection")

'Set an active connection to the Connection object using DSN connection
adoCon.Open "Driver={QODBC Driver for QuickBooks};DFQ=\\servername\MainStorage\Functional_Dept\Accounting\QBooks\QBData\Quickbook.qbw;OpenMode=M;OLE DB Services=-2;"

strSQL = "SELECT * FROM Customer"

rs.Open strSQL, adoCon

do while Not rs.eof

Response.Write (rs("Name")) & "<br>"

rs.MoveNext
loop

'Reset server objects
rs.Close
adoCon.Close
Set rs = Nothing
Set adoCon = Nothing
 

The IIS service and quickbooks datafile are on the same server.  The server is running Server2003.  Trying to run the asp script from a different workstation.  I get no syntax errors...the screen just "hangs".

Suggestions?

See: How can I see QuickBooks data in a Internet Explorer Browser using Windows XP? and How do I manually setup the QODBC DCOM Servers on Windows XP Pro and Windows 2003 Server? 

And the DFQ needs to be the drive and folder as it appears on the server itself, not a remote UNC path.