Hello, I am evaluating the Server Edition on a WinXP Pro, QB2003, SQL2005 machine.

I set up the software, QODBC connection, etc....and i can run Queries in the VB Demo app.  I set up a linked server as described in other posts.  I setup the dcom using the auto-decom utility, and i can run the TestDCOM.asp page with successfull replies.  When i open up SQL2005 managment studio, i can run certain queries like :

but I receive the following error when I try to query other tables like

the error returned is:

I have tried with DCOM checked, without it checked, and with Optimized checked/unchecked but still the same error.  Does anyone out htere have any idea how I can get this stuff working?  Any Help is greatly appreicated.

Thanks, Mike

Hi Tom,  Thank you for the reply.  That option is already checked.  That tab looks exactly like your screenshot, except the "Integrated Application Defaults" section on my tab is grayed out (although the same options are checked).  Any other ideas?  Thanks, Mike

There is nothing in the "QODBC Message" button, but the following is in the "SDK Messages" button.  When I run a query in SQL it actually pulls back the column layout (with no records of course), and the error posted above on the Messages tab.  The only messages in the SQL log are just informational from me changing flags at setup (they are down below).

20070329.205212 D 4984 SAXParseMediator EndElement: empty aggregate: name and currentTag are the same: HostQueryRq
20070329.205212 D 4984 QBXMLMsgs HostQueryRq
20070329.205212 D 4984 QBXMLMsgs DataExtDefQueryRq
20070329.205212 I 4984 SpecVersion Current version of qbXML in use: 2.1
20070329.205212 D 4984 MsgSetHandler Parsing took 0.0780 seconds
20070329.205212 I 4984 QBSDKMsgSetHandler QUERY: Host
20070329.205212 I 4984 QBSDKMsgSetHandler Request 1 completed successfully.
20070329.205212 I 4984 QBSDKMsgSetHandler QUERY: DataExtension Definition
20070329.205212 I 4984 QBSDKMsgSetHandler Request 3 completed successfully.
20070329.205212 D 4984 QBSDKMsgSetHandler There were total of 2 requests processed
20070329.205212 D 4984 MsgSetHandler Executing Requests took 0.016 seconds
20070329.205212 D 4984 MsgSetHandler Creating Responses took 0.000 seconds
20070329.205212 D 4984 MsgSetHandler Response is 988 characters long
20070329.205212 D 4984 MsgSetHandler Writing Responses took 0.000 seconds
20070329.205212 D 4984 MacroManager::DumpMacroMap Map contains no entries
20070329.205212 I 4984 MsgSetHandler Finished.
20070329.205212 I 4984 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 2220), ret = 0.
20070329.205212 D 2220 RequestProcessor Finished processing requests, no errors.
20070329.205212 D 2220 RequestProcessor Processing requests took 0.126 seconds.
20070329.210128 D 2220 RequestProcessor During this session processed 1 request.
20070329.210128 I 2220 RequestProcessor "EndSession" has not been called.
20070329.210128 D 2220 RequestProcessor End Session finished OK.
20070329.210128 I 2220 RequestProcessor "CloseConnection" has not been called.

Message
Configuration option 'Ole Automation Procedures' changed from 0 to 1. Run the RECONFIGURE statement to install.

Message
Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.

Sorry, I should have spotted this earier, QuickBooks 2003 isn't supported for use with SQL Server using DCOM.

Please Note: Effective April 30, 2006, in accordance with Intuit's QuickBooks Sunset Policy, QODBC is no longer actively supported on QuickBooks 2003 (or earlier) and QuickBooks Enterprise Solutions Version 2.0 & 3.0.

Tom

I receive the same error when using QuickBooks Enterprise 6.0.  I am using a linked server in MS SQL Server.

OLE DB provider "MSDASQL" for linked server "qodbc" returned message "[QODBC] Error".
Msg 7330, Level 16, State 2, Procedure spGetCustomer, Line 13
Cannot fetch a row from OLE DB provider "MSDASQL" for linked server "qodbc".

Any thoughts as to what I'm doing wrong?

Thanks