ASP to Oracle Connectivity(Urgent)

[retesh_gondal]

I have a problem connecting to Oracle 9i from ASP Page.
i m using the following code:
set conn=server.createobject("ADODB.Connection")
conn.Open "Provider=OraOLEDB.Oracle.1;User ID=some;Password=some;Data source=abc"

this code is not working, the error is like Provider not insalled properly.

i also used the following code using ODBC which is working fine with VB

set conn=server.createobject("ADODB.Connection")
conn.Open "Provider =MSDAORA.1;User ID=some;password=some;dsn=abc

but it is also giving some error like authentication failed
pls help..................

[buntine]

Retesh, did you install a MS ODBC for Oracle from the System DSN dialog?

Without it, you cannot connect to an Oracle database.

[PeOfEo]

Originally posted by retesh_gondal
I have a problem connecting to Oracle 9i from ASP Page.
i m using the following code:
set conn=server.createobject("ADODB.Connection")
conn.Open "Provider=OraOLEDB.Oracle.1;User ID=some;Password=some;Data source=abc"

this code is not working, the error is like Provider not insalled properly.

i also used the following code using ODBC which is working fine with VB

set conn=server.createobject("ADODB.Connection")
conn.Open "Provider =MSDAORA.1;User ID=some;password=some;dsn=abc

but it is also giving some error like authentication failed
pls help.................. why did you report this post to me. You are only supposed to report a post to the moderators if it is spam or advertsing or breaks some other forum rule. :o

[buntine]

Also, you posted this same question a couple of days ago... I dont see how anyone can help you more than what we already have..