Connect to Oracle database

[lloraine]

I am getting the following:

15 proc sql;
16 connect to odbc (user=lidf6pf password=XXXXXXXX dsn=SharePlex_SPICIS);
ERROR: CLI error trying to establish connection: [Microsoft][ODBC Driver Manager] Data source
name not found and no default driver specified
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.

This used to work. Apparently it doesn't like SharePlex_SPICIS

[Doc_Duke]

There are a number of "moving parts" here that may have been changed.

1) the tnsnames.ora file may have been changed. That is usually maintained by your Oracle admins and has the detail linkage for the database.
2) Something may have happened to your ODBC driver on your PC. You can test that (in XP), but going through Control Panel --> administrative tools --> ODBC.

You may well need your IT support folk to help untangle this. I usually do(!).

Doc Muhlbaier
Duke

[Ksharp]

Doc@Duke is right.
It looks like You did not setup Oracle in your PC and also not config a dsn in ODBC.
It is the best friend to search it in support.sas.com or chech documentation about this.

Ksharp