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
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(!).