Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2005
    Posts
    4

    Unanswered: SQL Server and the AS400??

    I have been tring to connect to the as400 through the IBM ODBC (IBMDA400),
    but have run into a wall. I was wondering, could i set up the 400 in SQL Server 2K as a DB or Table or something and maybe access it through SQLOLEDB?

    Thanks
    fvlmasl2

  2. #2
    Join Date
    Mar 2003
    Location
    Indiana, USA
    Posts
    100
    We are using the IBM client access OLEDB drivers to access our AS400 DB2 tables.

    The one wierd thing I remember is that we had to turn on journeling on the AS400 in order for us to update tables on the AS400.

    Tim S

    NOTE: Use the same version of client access as is on the AS400.
    Last edited by TimS; 02-18-05 at 17:32.

Posting Permissions

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