Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2004
    Location
    India
    Posts
    23

    Question Unanswered: OLEDB Connectivity for Db2 UDB V8.1

    Hi all....

    I am using a Visual Basic tool for database migration from M/S Access to DB2 UDB. The DB2 connections are done through OLEDB service provider. For the earlier project where the destination D/b was in 7.4 version, The tool worked fine. But for DB2 8.1 version it is not working. Is there any compatibility problem of OLEDB provider with 8.1 verion??? Do I need to use some different service provider or is there any way out???? Pls help me as early as possible......

    Thanks a lotts in advance.....

  2. #2
    Join Date
    May 2004
    Posts
    25
    Hi:
    I develope in VB with DB2 8.1 too. Here is the string connection I use with no problems.

    StrConect = "Provider=MSDASQL;DSN=DRTS;DBQ=BIFDB;PWD=" & usrDBPWD & ";UID=" & usrDBNAM
    Set DBCon = New ADODB.Connection
    DBCon.ConnectionTimeout = 15
    DBCon.CursorLocation = adUseClient
    DBCon.Open StrConect

    Is through ODBC. (you must create an ODBC source in the client)
    Hope it helps.
    Cheers.
    Last edited by javierfrank; 01-10-05 at 20:24.

  3. #3
    Join Date
    Dec 2004
    Location
    India
    Posts
    23
    Thnx a lott for ur reply

Posting Permissions

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