Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004

    Question Unanswered: Sql Server 2000 linked server to DB2

    I'm trying to connect to a DB2 database on an AS400, by adding a linked server to SQL 2000 using an ODBC and OLEDB data source, but when i try to access the tables i get this error message:

    "Error 7399: OLE DB Provider MSDASQL reported an error. Authentication Failed. Data Truncated] Client unable to establish connection] OLE DB error trace [OLE/DB Provider 'MSDASQL' IDNInitialize returned 0x80040e4d: Authentication failed.]."

    No error message appears when you create the linked server, just when you try to see the tables.

    Can anyone help???

  2. #2
    Join Date
    Nov 2002
    Did you add a login for your process id to the db2 box?

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Jan 2004
    Originally posted by Brett Kaiser
    Did you add a login for your process id to the db2 box?
    I'm using a user id in my OLEDB data source that has already been set up on the DB2 box. The user i am trying to connect as is the equivalent to SA on SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts