I have followed the instructions for running QODBC with MS SQL Server 2005 Linked Tables many times. I am unable to make this work. While running one of the example queries (SELECT * FROM OPENQUERY(QODBC, 'SELECT * FROM Host')) through Management Studio I get as far as "Executing query..." and I hear the windows default beep sound seconds later. 

We're running QODBC Server Edition 2007 Version 6.00.00.176

DCOM Servers setting is enabled.

Flexquaters QODBC is setup through QB to Allow this application to access the company file, allow this application to login automatically, login as admin, and allow this application access to personal data. 

I am able to use the VB Demo app successfully. 

I am able to run queries through ASP using the QODBC system DNS successfully. 

The ASP DCOM Access Test Page lists all success statues. 

I have changed the MSDASQL properties as indicated in the instructions. 

I have run the Test DCOM Script and all objects return "Successfully Created".

I have tried some of the troubleshooting tips from http://www.qodbc.com.au/QODBCwebserver.asp 

I am able to execute queries through ASP using the linked server using the SQL Server ODBC driver with the sample queries (SELECT * FROM OPENQUERY(QODBC, 'SELECT ListID, Name FROM Employee'). However this does not work through SQL Server 2005 Management Studio. I do not understand the difference. 

I am willing to email my detail trace log. QODBC Messages and SDK Messages do not seem to have any interesting log entries.

Try running the Query with QuickBooks and the company file open (or if that's what you were doing ... try the other way around). But OPENQUERY queries like this should run if the MSDASQL (Microsoft OLE DB Provider for ODBC Drivers) provider is setup correctly, but you can also try:

SELECT ListID, Name FROM QODBC...Customer

Yes, I have tried with the QuickBooks company file open with the administrator logged in and with QODBC configured to automatically launch QuickBooks as a hidden process and login as admin. In my case I would prefer the auto login but yes I have tried both.

I also tired both formats of the sample queries (OPENQUERY and QODBC…) with the same results.

SELECT * FROM OPENQUERY(QODBC, 'SELECT * FROM Host')
SELECT * FROM QODBC...HOST

I am using SQL Server 2005 Express on Win XP SP2. It should be worth noting that SQL 2005 Express does not have the property menu item on the Link Server providers so I was unable to configure this through the UI as indicated in the directions. However I did script this action from another SQL Server and I believe I have achieved the same results, but I do not know anyway to verify this.

I've been playing with this most of the day and I’ve found a query that works through SQL Server 2005 Express on the host machine.

SELECT ListID, Name, CompanyName FROM QODBC...Vendor

Interestingly enough when I execute this query from a different machine connecting remotely to SQL Server I get the same indefinite “Executing query…” and default beep sound from the host machine that I get when trying other queries.

At least to me there does not seem to be any reason as to why some work and most do not. I think the default beep is indicating a QODBC error since it occurs on the host machine, but I can’t find anything meaningful in the logs. Have any more ideas?

Normally all the QODBC queries are run on the host system using the local database. By the sounds of things, the Studio is trying to run QODBC locally on the machine connecting remotely to SQL Server?

I have other computers with the client tools installed (Management Studio). QODBC and SQL Server 2005 Express are on the same system.

I can only get one query to work when trying everything locally. Everything else I try fails. Why?