Hi,

I would connect me to DB2 database with ASP. I've a ASP server and DB2 server (where there's the database).

I installed DB2 Connect on ASP server , created a DSN System and tested (the connection is successful).

But when I try with a ASP page, it's impossible. I use the same DSN, same uid and same pwd.

In my ASP page :
<%
Dim connBdD
Set connBdD = Server.CreateObject("ADODB.Connection")
connBdD.ConnectionString = "DSN=D2CPLOC;uid=D2CPAD1;pwd=HUBERT"
connBdD.open
%>

If I execute this, I've :
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[IBM][CLI Driver] SQLSTATE=
/Ordo/TWS/test.asp, line 5

Where's the problem ?

Thanks

Yannick

If you can't get the DSN connection to work, perhaps you could try this:

http://www.carlprothman.net/Default....ProviderForDB2