Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Connecting to DB via asp through IIS

385440Jan 14 2003 — edited Jan 15 2003

I have a web site that uses asp pages with ADODB.Connection objects to connect to my database. This works fine when the DB is SQL, Access or Oracle 8 but will NOT work for Oracle 9

My connection string is:
"Provider=OraOLEDB.Oracle;Data Source=TNS_Name;User ID=xxx;Password=xxx;"
Error message received is "Access is denied"

Any ideas? Connecting from SQLPlus and ODBC tester works fine. I can also use the same connection string from a VB program and it works - just not directly from the ASP page.

Many thanks,
Nicola

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 12 2003

Added on Jan 14 2003

#general-database-discussions

2 comments

310 views