DB2 v8 fixpak 2 (hotfix special_7650)
VB .NET 2003

When trying to connect to the database using the following connection string, I get the error below.

"Provider=DB2OLEDB;Persist Security Info=False;" & "User ID=" & uid & ";" & "Password='" & pwd & "';" & "Data Source=" & dsn_PrymDritz & ";" & "Connect Timeout=15;Extended"

Error 3706 "provider cannot be found. It may not be properly installed"

I have the datasource setup in the datasources section with DB2 ODBC as the driver. The database is on the local machine.

Does anyone have an idea of the proper connection string or know what is not setup correctly?, if that is the case.

but I am getting the same error when trying to connect from VB 6.0. Hope someone can help with this soon.

You need not give the provider name if you installed db2 client.
Try using just DSN,userId, Password and database name in your connection string



Cheers

Thanks, beepyata!

The solution I found was to put the word "data" before the word "provider". Weird, but my app is working now.

Sure is slow. I am hitting a remote DB2 DB on a mainframe using os390.