Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
Click Here
|
Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
|
linked server-sql 2005 |
Author |
Message |
|
Posted : 2008-10-12 13:34:29 |
i am trying to add the QODBC as a linked server and keep getting Cannot start quickbooks The vb demo works, the .asp page works and i get succesfull for all the sql tests. I have tried it with quickbooks open and closed. At my wits end. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-10-13 22:36:43 |
|
|
|
|
Posted : 2008-10-14 05:25:47 |
i got the linked server to work. However i do not get any results for SELECT * FROM OPENQUERY(QODBC, 'SELECT * FROM item ')
If i use the vbdemo, i get one record.
I am using windows authentication on sql server
I have reloaded all the data on the optimizer a few times and i see when it updates the item it shows 1 |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-10-14 07:43:21 |
The ITEM table is a combined (read only view) list of all Item tables in QuickBooks: ItemInventory, ItemNonInventory, ItemOtherCharge, ItemInventoryAssembly, ItemService, ItemFixedAsset, and ItemGroup; with minimum common fields.
Check these tables with what you have in QuickBooks. |
|
|
|
|
Posted : 2008-10-14 08:30:45 |
I am getting this intermittent error. Sometimes the select below will work, other times i will get a
SELECT * FROM OPENQUERY(QODBC,' SELECT * FROM customer ')
OLE DB provider "MSDASQL" for linked server "QODBC" returned message "[QODBC] Error". Msg 7330, Level 16, State 2, Line 1 Cannot fetch a row from OLE DB provider "MSDASQL" for linked server "QODBC". |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-10-14 11:31:01 |
Correct, QODBC is a STA (Single Threaded Apartment) driver. You can't multi-thread queries, they must be run one after each other and must be allowed to complete. |
|
|
|
|
Posted : 2008-10-14 11:33:26 |
how is that multi-threaded? I tried a simple SELECT * FROM qodbc...customer and that failed also with the same issue? Is there a setting on SQL server that makes it a STA thread? |
|
|
|
|