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
|
|
No columns? |
Author |
Message |
|
Posted : 2007-10-27 10:08:07 |
I'm using a linked server object in MSSQL to run queries against QODBC/Quickbooks. When trying to insert invoice lines I consistently receive the following error message:
The OLE DB provider 'MSDASQL' indicates that the object has no columns.
I searched your forum for clues and found this post with the same error being reported. Your recommendation there was to reload the Optimizer record, but when I tried to do so I get the message:
Reload All Data did not complete (3).
I've tried rebooting the server without any luck. Hopefully you'll recognize the trouble...
Thanks, paul
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-10-29 08:12:35 |
See: How do I do INSERTs, UPDATEs and DELETEs using OPENQUERY with Linked MS SQL Servers?
To rebuild a optimized table do:
SELECT * FROM OPENQUERY(QBLS, 'SELECT FullName FROM Customer VERIFY where FullName = ''x''')
for list tables and this for transaction type tables:
For Update Sync: SELECT * FROM OPENQUERY(QBLS, 'SELECT TxnID FROM InvoiceLine OPTIMIZE WHERE TxnID = ''x''')
And for Full Sync: SELECT * FROM OPENQUERY(QBLS, 'SELECT TxnID FROM InvoiceLine VERIFY WHERE TxnID = ''x''')
|
|
|
|
|
Posted : 2007-10-30 04:18:36 |
Thanks, Tom. Do you know what creates the need to manually rebuild an optimized table? I ask because we'd like to automate these processes and I don't want to have it erroring out or requiring manual rebuilds. Is there something I might avoid doing that would prevent the error? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-10-30 07:36:43 |
Most likely you are using VB Demo and Management Studio at the same time. The QODBC optimizer is single user only so you need to setup a different optimizer file for the SQL Server to use than the other desktops applications. To do this step up a seperate System DSN (see: How do I create or configure a QODBC DSN? ) and specify a fixed location of the optimizer database folder for SQL Server to use (like: C:\Program Files\QODBC Driver for QuickBooks) instead of the default %UserProfile% method.
|
|
|
|
|