Results 1 to 3 of 3

Thread: linked server from mssql 2005 to as400

  1. #1
    Join Date
    Jan 2009
    Posts
    1

    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!

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Tried with Microsoft ole db provider for odbc driver? It worked for me.

  3. #3
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    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
  •