Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Posts
    5

    Exclamation Unanswered: ERRORS on Insert/Update DB2 from SQL Enterprise Manager (linked server)

    I've set up an AS400/DB2 as a linked server, all standard configs (V4R5) on a SQL server 2000 machine and can select all day long. When I go to update or insert it throws an error referencing my driver. I'm using the HIS/OLEDB2 driver. Any ideas? Someone mentioned turning on Journaling on the 400?

    Anything at this point would help

  2. #2
    Join Date
    Oct 2002
    Posts
    369

    Re: ERRORS on Insert/Update DB2 from SQL Enterprise Manager (linked server)

    RE:
    Q1 I'm using the HIS/OLEDB2 driver and can select all day long. When I go to update or insert it throws an error referencing my driver. Any ideas? Anything at this point would help
    A1 Perhaps DB2 Connect provides a better odbc driver? Per IBM, DB2 Connect: "Provides extensive application programming tools for developing client-server and web applications using industry standard APIs such as ODBC, ADO, OLE DB, JDBC, SQLJ, DB2 CLI and Embedded SQL."

    See: http://www-3.ibm.com/software/data/db2/db2connect/

  3. #3
    Join Date
    Jan 2003
    Posts
    5

    Found another answer that worked

    I found an answer that worked from a colleague. Thanks.

Posting Permissions

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