-
linked server from mssql 2005 to as400
I am trying to use the linked server option in mssql 2005. i have my udl connection working successfully and my odbc working. it works with Excel. I get an error when trying to link the server that reads:
"an exception occurred while executing transact-sql statement or batch. (microsoft.sqlserver.connectioninfo)
cannot initialize the data source object of ole db provider "ibmda400" for linked server "as-400". (microsoft sql server, error:7303)
i was successful in creating the linked server with the mediacatalogmergeddb ole db provider and was able to link, but not access my table. please help!
-
Tried with Microsoft ole db provider for odbc driver? It worked for me.
-
Tried testing the connection from the ODBC or OLEDB after you installed the client tools?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|