I'm running QB UK 2006 Pro, MSSQL 2005 & QODBC v8 on my server (SBS 2003), vb demo works fine connecting to the QB database, however, I have been through all of the Auto & manual setups for DCOM configuration, set access permissions for the specific files as stated on this forum but still get errors when testing the linked server:

An exception occurred while executing a Transact-SQL statement or batch.

Cannot initialise the data source object of OLE DB provider "MSASQL" 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, Unkown Error.. Created qbXMLRP2 OK.".

(Microsoft SQL Server, Error: 7303)

The SQL test script returns 'Access is denied' on both QBXMLRPEQODBCInteractive.RequestProcessor & QBXMLRP2EQODBCInteractive.RequestProcessor. It successfully creates QBXMLRP.RequestProcessor, QBXMLRP2RequestProcessor & Xerces.DOMDocument.

The only thing that did not follow your steps was not having an ASP.NET machine account available so I had to create one (could be due to my server set-up although I have .NET 3.5 installed) If it is an access issue I'm not sure what logins to apply to which program?

I don't think I'm trying to do anything unusual - create VB frontend to read / update the SQL db then use QODBC to link to our QB file. I would really appreciate your help on this issue before the office hits meltdown point!

You must be logged in as the Administrator, a member of the Domain Admins group account is not sufficent.

Try looking at: Slow performance, Domain Admin, Local Admin, SQL Admin privilege issues using SQL Server 2005 

Tom, Thanks for the speedy response.

The topic you gave has the linked table set up OK (unlike mine) & I have already moved the optimiser files to a generic folder & set access permissions to it. All of my testing & setup has been done while logged in to the server as Administrator.

Any further help?

I just got off the phone with Intuit US who tell me that QODBC only works with the US version of quickbooks - So it looks like I will have to wait until we purchase the Enterprise version (US Only) & run that to get full ODBC functionality.