I am attempting to set up a linked server using the a DSN created with the qodbc driver. I am using sql server 2005 management studio to do this, however I get the an error when I attempt to set this up (see BEGIN ERROR):
The link server properties I am using are as follows:
- Provider = Micorsoft OLE DB provider ODBC Drivers
- Product Name = QODBC
- Data Source = mydsn
- Provider String = <blank>
- Location = <blank>
- Catalog = <blank>
Can you help me set up this linked server? - Thanks
BEGIN ERROR:
TITLE: Microsoft SQL Server Management Studio
------------------------------
"The linked server has been created but failed a connection test. Do you want to keep the linked server?"
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "QB ALEXANDRA SMITH TRUST".
OLE DB provider "MSDASQL" for linked server "QB ALEXANDRA SMITH TRUST" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed".
OLE DB provider "MSDASQL" for linked server "QB ALEXANDRA SMITH TRUST" returned message "[QODBC] QB Begin Session Failed. Error = 80040408, Could not start QuickBooks.
". (Microsoft SQL Server, Error: 7303)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=7303&LinkId=20476
------------------------------
BUTTONS:
&Yes
&No
------------------------------
| 
