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 from Classic ASP to Oracle 10g database - ORA-12154: TNS Error

591264Sep 11 2007 — edited Sep 12 2007

Hi,

I have looked into the posts here and still I do not know what to do to eliminate this error:

Error Type:
OraOLEDB (0x80004005)
ORA-12154: TNS:could not resolve the connect identifier specified
/test/oracle_db_new.asp, line 24

I have installed Oracle 10g. It has been re-booted several times since then. My code is as follows: line 24:

cst = "Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=apps;Data Source=SKYDEV;Extended Properties="""";PASSWORD=apps;"
set conn = CreateObject("ADODB.Connection")
conn.open cst

Line 24 is:

conn.open cst

So it comes down to the Connection String.

What should I do for the ORA-12154: TNS error?

Any suggestions, any ideas would be great.

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 10 2007

Added on Sep 11 2007

#general-database-discussions

6 comments

1,057 views