Jess31
asked on
QuickBooks/QODBC & Linked Server ?
Using QB Pro 2010 on XP. SQL Server 2005 Express and SSMS 2008.
Installed QOBC, and it seems to work using the VB Demo. But when I tried creating a Linked Server, I followed the instructions to create a linked server, but it fails. I get this error:
The linked server has been updated but failed a connection test. Do you want to edit the linked server properties?
-------------------------- ----
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Conne ctionInfo)
-------------------------- ----
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "QODBC".
OLE DB provider "MSDASQL" for linked server "QODBC" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed".
OLE DB provider "MSDASQL" for linked server "QODBC" returned message "[QODBC] QB Open Connection Failed. Create DCOM Instance Error = 80070005, Unknown error.. Created qbXMLRP2 OK.
". (Microsoft SQL Server, Error: 7303)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.4053&EvtSrc=MSSQLServer&EvtID=7303&LinkId=20476
-------------------------- ----
Installed QOBC, and it seems to work using the VB Demo. But when I tried creating a Linked Server, I followed the instructions to create a linked server, but it fails. I get this error:
The linked server has been updated but failed a connection test. Do you want to edit the linked server properties?
--------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Conne
--------------------------
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "QODBC".
OLE DB provider "MSDASQL" for linked server "QODBC" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed".
OLE DB provider "MSDASQL" for linked server "QODBC" returned message "[QODBC] QB Open Connection Failed. Create DCOM Instance Error = 80070005, Unknown error.. Created qbXMLRP2 OK.
". (Microsoft SQL Server, Error: 7303)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.4053&EvtSrc=MSSQLServer&EvtID=7303&LinkId=20476
--------------------------
What version of the qODBC driver are you using? (Trial/read only/server edition?)
Is QB installed on the XP machine? The qODBC installed there too?
Where is the data file?
What program are you trying to connect with?
Is QB installed on the XP machine? The qODBC installed there too?
Where is the data file?
What program are you trying to connect with?
ASKER
QODBC Driver is latest, and it is a trial. D/L it a few days ago.
QB is installed on XP as well as the QODBC, as well as the data file.
the VB Demo connects, and Test Connection from the ODBC configuration dialog works.
The problem is from the SQL Server (SQL Server 2008 Express) it won't connect.
I am not using any type of Internet / ASP / IIS - just trying to get my SQL Server to talk to QB.
QB is installed on XP as well as the QODBC, as well as the data file.
the VB Demo connects, and Test Connection from the ODBC configuration dialog works.
The problem is from the SQL Server (SQL Server 2008 Express) it won't connect.
I am not using any type of Internet / ASP / IIS - just trying to get my SQL Server to talk to QB.
Looks like there could be any number of things, the easiest bing a post I read that said QB needed to be installed on the server as well.
might want to look at these....
http://www.qdeveloper.com.au/forum.php?homeinclude=topicdetails&forum_id=1&category_id=19&post_id=897
http://www.qdeveloper.com.au/forum.php?homeinclude=topicdetails&forum_id=1&category_id=19&post_id=973
http://www.qdeveloper.com.au/forum.php?homeinclude=topicdetails&forum_id=1&category_id=41&post_id=1373
Hope these help.
might want to look at these....
http://www.qdeveloper.com.au/forum.php?homeinclude=topicdetails&forum_id=1&category_id=19&post_id=897
http://www.qdeveloper.com.au/forum.php?homeinclude=topicdetails&forum_id=1&category_id=19&post_id=973
http://www.qdeveloper.com.au/forum.php?homeinclude=topicdetails&forum_id=1&category_id=41&post_id=1373
Hope these help.
ASKER
stlinae:
QODBC says that it can work on stand alone pc. Where did you that it needs to be installed on sever?
QODBC says that it can work on stand alone pc. Where did you that it needs to be installed on sever?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
but everything here is installed on same pc
Take a look on this page how to configure them: http://archive.qodbc.com/forum9862.html?homeinclude=topicdetails&forum_id=1&category_id=2&post_id=291