database connection

[jrthor2]

We currently have a site that uses asp and microsoft access. I want to change one of my pages to get data from a db2 udb database. Below is my connection string I currently use. What would I need to change to talk to db2 udb?

if (db) <> "" then
Set conn = server.createobject("adodb.connection")
DSNtemp="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath(db)
conn.Open DSNtemp
End If

Thanks

[macker]

sorry, wrong thread

[jrthor2]

Our network server person said they installed the db2 client, imported the dsn names and checked out the ones they had connection to. That being said, how do I get my asp (not .NET) page to connect to this database?

Thanks.

[buntine]

You will need to consult the docs of the database you are attempting to connect to. Also ensure it complies to ODBC standards, etc.

[jrthor2]

I've had my network admin and our database admin working on this, but we can't seem to get my asp (not .NET) page to connect to the DB2 table. They have installed the DB2 client and have done a test connection to the DB2 table. When I try to connect usig the below, I get the below error:

if (dbtype = "DB2") then
		DSNtemp = "Provider=IBMDADB2;DSN=INET;User ID=netbtprd;Password=SOY6ITN8"	
		conn.Open DSNtemp

Error:

Provider error '80004005'
Unspecified error
/corp/inc/dbconn.asp, line 13

Can anyone here help?

Thanks

[buntine]

Could be permissions. Or perhaps an unregistered DLL. Or even a corrupt file. It could literally be one of a million things. Keep trying!