Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    176

    Unanswered: ODBC Driver for AS400

    Hi,

    I am presently using Client Access ODBC driver (32-bit) to connect to the AS400. I have set up a linked server that enables me to run queries against the AS400 using the driver. However I seek to have a driver that could give better performance. Right now I can extract 6 million rows from the AS400 table in like 2 hrs. Now is there an ODBC driver that can do better than that? Also I seek an evaluation edition of the driver if possible. Moreover I am the only developer and so a single user license is what I can have my supervisor budget.

    Thanks,

    Vivek

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    Look at www.hitsw.com. I've never used their drivers, but a friend of mine did and he praised their performance to the sky.

    Regards,

    hmscott

    Quote Originally Posted by vivek_vdc
    Hi,

    I am presently using Client Access ODBC driver (32-bit) to connect to the AS400. I have set up a linked server that enables me to run queries against the AS400 using the driver. However I seek to have a driver that could give better performance. Right now I can extract 6 million rows from the AS400 table in like 2 hrs. Now is there an ODBC driver that can do better than that? Also I seek an evaluation edition of the driver if possible. Moreover I am the only developer and so a single user license is what I can have my supervisor budget.

    Thanks,

    Vivek
    Have you hugged your backup today?

Posting Permissions

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