DB2 - OLEDB

9 Aug 2006 6:48 PM

Jim Heavey

I create a ".UDL" file on my desktop. I double click the ICON and supplied
the connection information so that I could connect to DB2, I test the
connectiion and I get a message that the connection was successful. Now when
I take the connection string that this generates and paste that into me .Net
program, I get the following error "The 'IBMDADB2.1' provider is not
registered on the local machine.". How is it that the .UDL file finds the
driver just fine, but when I go into Visual Studio, the driver can not be
found? What can I do to resolve the error?

9 Aug 2006 9:14 PM

Jim Hughes

What is the connection string? (hide servername, password and username)

Have you checked www.connectionstrings.com?

Show quote

"Jim Heavey" <JimHea***@discussions.microsoft.com> wrote in message
news:D7D7676B-1676-41B0-8970-7FFB4669DF55@microsoft.com...
>I create a ".UDL" file on my desktop. I double click the ICON and supplied
> the connection information so that I could connect to DB2, I test the
> connectiion and I get a message that the connection was successful. Now
> when
> I take the connection string that this generates and paste that into me
> .Net
> program, I get the following error "The 'IBMDADB2.1' provider is not
> registered on the local machine.". How is it that the .UDL file finds the
> driver just fine, but when I go into Visual Studio, the driver can not be
> found? What can I do to resolve the error?