var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: VB .NET to DB2 connection
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.
Don't have the answer
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
Found a solution
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.
Originally Posted by Chessy
After installing the DB2 client on my windows 2008 R2 Sp1 Server and attempting to run a query from within a classic ASP page, I was getting the below error:
ADODB.Connection error '800a0e7a'
Provider cannot be found. It may not be properly installed.
I renamed the connection string from Provider= to DataProvider= and this solved the problem!!