Connection from Windows 2000 to AS/400

chchsi · #1 (**permalink**) 11-13-03, 21:52

Hello,

I'm writing an asp.net program to connect from Windows 2000 to AS/400 DB2. But i got an message saying that "The 'DB2OLEDB' provider is not registered on the local machine.".

connStr = "Provider=DB2OLEDB;" & _
"Network Transport Library=TCPIP;" & _
"Network Address=10.1.1.42;" & _
"Initial Catalog=testdta;" & _
"User ID=myid;" & _
"Password=12345678"

I didn't install any additional driver or software to support for the connection. Can anyone guide me what to do ?

Thanks

sathyaram_s · #2 (**permalink**) 11-14-03, 03:39

DB2 Connect is the client For AS/400 DB2

You should install it on the client side before trying to connect to the host

Cheers
Sathyaram

Quote:

Originally posted by chchsi
Hello,

I'm writing an asp.net program to connect from Windows 2000 to AS/400 DB2. But i got an message saying that "The 'DB2OLEDB' provider is not registered on the local machine.".

connStr = "Provider=DB2OLEDB;" & _
"Network Transport Library=TCPIP;" & _
"Network Address=10.1.1.42;" & _
"Initial Catalog=testdta;" & _
"User ID=myid;" & _
"Password=12345678"

I didn't install any additional driver or software to support for the connection. Can anyone guide me what to do ?

Thanks

Internet Services

Web Development

Digital Marketing

Consumer Tech