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.....

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.

Thnx a lott for ur reply