Pice of my code, have error provider not found...???
Private Sub SetupADO()
On Error GoTo SetupADO_Err
Dim adoParm As ADODB.Parameter
' Create connection object and connect to database
Set acnBooks = New ADODB.Connection
.ConnectionString = "Provider=IBMDADB2.1;Data Source=SAMPLE;Persist Security Info=False"
.CursorLocation = adUseClient
But if i install a free version of DB2 client 9.0 have a free dll and provider to use the string in thi spost?
Is there any help for this? I have a similar error. I use DB2 and C# with Visual Studio 2008 and .NET 3.5 SP1. I want to connect to my DB2 Server via NHibernate, but the connection string seems to be wrong. Has anybody worked with it? I also tried to connect via another program (MyGenerate) and the same error occured (Provider not registered). Here are my configuration data. Is OleDB right? With ODBC i can't connect too.
By the way. I have installed the IBM DB" Serve Driver Pack (v9.5fp4_nt32_dsdriver_DE.exe). I run Windows 7 (64 Bit), but the 64 Bit version of this file is not working, so i have installed the 32 Bit version. But when i use the Entity Framework of Microsoft, i can connect to my db ia the DB2 Provider. But what do i have to set in this xml file???
Well, the link for this pdf was not valid, or it was loaded from the super fast IBM-Server with 0,05 kb/second, so i couldn't read it. but i solved it by my own. you have to set the driver_class do DB2Driber, and in the connection string there shouldn't be a provider. and the IBM.Data.DB2.dll MUST be in the folder of your app...
ah, and i forgot an important thing... because the 64 bit version of the driver is not working, i installed the 32 bit version. and so you HAVE TO select as the Target CPU the x86. If you select 64 bit you get an exception...