Re: strange ora-12545 when connecting with pro*c program

Ups, it's all right now - I made wrong CONNECT:

instead of :
EXEC SQL CONNECT :oracle_connect_str; /*usrename/pwd_at_tns_db*/

one should use:
exec sql declare connect_db database;
EXEC SQL CONNECT :oracleid IDENTIFIED BY :oraclepwd USING :connect_db;

The first option works, when compiled on Windows version, but ommits tns_db when run on Unix and takes the default database there.

Regards
Johny Received on Tue Sep 03 2002 - 06:49:49 CDT