We are upgrading one of our application to Oracle 9.2, it was 7.3.4. The following code works when connecting to the old 7.3.4 app but not to the new 9.2 app. Could this be a tnsnames or dblink problem? Thanks! Ron EXEC SQL CONNECT :USERID-ORA-IPRM IDENTIFIED BY :PASSWD-ORA-IPRM AT :DB-SID-ORA-IPRM USING :DB-TNSNAME-ORA-IPRM END-EXEC. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------