ASP Oracle 9i Connection Problem

Hi,

I am trying to connect to Oracle 9i Database Installed on Win 2000 Server using a DSN and i am getting the foll error :

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC driver for Oracle][Oracle]
/test/includes/openconn.asp, line 7

No error description

The line 7 is where I am opening the connection using
objConn.open "Dsn=test;uid=xxx;pwd=xxx;"

I am able to connect to the Oracle 9i Database using my SQL Plus and also thru Oracle Management Server.

Kindly some one give me a solution.

Thanks in Advance
Rohit

Cm.ActiveConnection = "Provider=OraOLEDB.Oracle;Data Source=SERVER;User ID=" & UID & ";Password=" & PWD & ";"

This is how I connect to my Oracle DB, not sure if this is what you are looking for.

Hi,

I tried the way you connected but got and error saying that the driver might not be correctly installed.

but i am trying to use DSN connection. I used to do the same and was able to connect when i had Oracle 8i on Linux. But when i installed Oracle 9i on Windows 2k and tried to connect i got this eror