MS SQL Server Linked Server Not Working - VBDemo Works Fine |
Author |
Message |
Dan1 |
|
Group | : Members |
Posts | : 5 |
Joined | : 2008-01-18 |
|
Profile |
|
Posted : 2008-02-06 03:43:36 |
So I can connect to quickbooks using VBDemo. I can run queries that I want.
I started the DCOM server following the instructions on the page. Also I can see a Quickbooks ODBC connection when I click on Configure ODBC connection. The test connection works fine.
When I try creating a linked server from the tutorial it fails. None of the tables show up and I get an error -- "Quickbooks could not be started"
I have tried everything but nothing seems to work. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-02-06 07:48:01 |
|
|
|
Dan1 |
|
Group | : Members |
Posts | : 5 |
Joined | : 2008-01-18 |
|
Profile |
|
Posted : 2008-02-06 07:49:57 |
To clarify I am using SQL 2000 . NOT 20005.
And SQL Server and Quickbooks and QODBC are installed on the same physical machine. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-02-06 12:34:00 |
|
|
|
Dan1 |
|
Group | : Members |
Posts | : 5 |
Joined | : 2008-01-18 |
|
Profile |
|
Posted : 2008-02-07 02:09:11 |
Ok I got it to work. I can see all the tables as a linked table.
Now when I run a query in query analyzer this what I get. I ran everything on the master DATABASE in sql.
All the example queries give me this error.
Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'MSDASQL' reported an error. [OLE/DB provider returned message: [QODBC] Error] OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowset::GetNextRows returned 0x80004005: ].
Thanks for all the help. How do I run queries of a linked server? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-02-07 08:42:17 |
Assuming QODBC is the name of the linked server, try:
SELECT ListID, Name FROM QODBC...Customer
which is the same as running:
SELECT ListID, Name FROM Customer
using VB Demo. |
|
|
|
Dan1 |
|
Group | : Members |
Posts | : 5 |
Joined | : 2008-01-18 |
|
Profile |
|
Posted : 2008-02-08 01:11:32 |
Great! Now I can get this to work.
SELECT * FROM QODBC...Customer
I see all the column names now ..BUT NO DATA!! It returns 0 rows.
In my VB DEMO query same query returns 1300 rows.
Whats going on? Thanks Tom for all the help. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-02-08 07:48:59 |
|
|
|