I am trying to link a server in Sql 2005 with Quickbooks 2005. I have the server edition of QODBC v7. I have everything installed locally while I try to get this to work. I tested with the VB Demo and all works well. I can run the following query
select * from openquery(quickbooks, 'select * from host')
and I get a row of data.
When I run the following query, select * from openquery(quickbooks, 'select * from vendor)
Data appears for only 1-5 sec and then I get an error
A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 - The pipe is being closed.)
It then disconnects from the object browser. I've checked and the shared memory and named pipe protocol are enabled.
Please help ASAP.
|