[odbc] SQLDriverConnect with a user identified externally

Hi

    In Window NT environment via ODBC, I want to connect an Oracle database using a user identified externally to avoid any password management in my database.

• On server side, I've properly configured init.ora file OS_AUTHENT_PREFIX="" REMOTE_OS_AUTHENT=TRUE and declared my oracle user with IDENTIFIED EXTERNALY
• On PC side, after having opened NT session, I can properly connect my user with SQLPLUS tool (using '/' as user name)
  -> It works with an ORACLE native connection.
  
• I can also connect to my database using MSQUERY tool. I just leave blank user and password fields in connection dialog box and it works
  -> It works with an ODBC connection.
  
• Now, I would like to obtain the same behavior programatically in my C++/ODBC application. I want to connect without asking any user name and password during application starup.

I use SqlDriverODBC function

    RETCODE SQLDriverConnect(

                hdbc,
                NULL,
                szConnStrIn,          // Input connect string
                strlen(szConnStrIn),
                szConnStrOut,         // Output connect string
                cbConnStrOutMax,      // Length of output connect string
buffer
                &cbConnStrOut,
                SQL_DRIVER_NOPROMPT  )

I have set SQL_DRIVER_NOPROMPT do avoid any complementary dialog box display.

!!! But I can't find any appropriate ODBC connect string to use this 'identified externally' feature.

I've tried following connect strings :

    DSN=MY_ORACLE_SOURCE;
    DSN=MY_ORACLE_SOURCE;UID=;PWD=;
    DSN=MY_ORACLE_SOURCE;UID='';PWD='';
    DSN=MY_ORACLE_SOURCE;UID=/

None of these connect string works.

Does anybody have a solution to connect a user identified externally ???

Please answer via e-mail nicolas.germain_at_mc2.fr

Thanks in advance for any help

--

Nicolas Germain                mailto:Nicolas.Germain_at_mc2.fr
MC2                            tel:+33 (0)4 76 04 5000 (direct 5026)
4, Chemin de Malacher          fax:+33 (0)4 76 04 5001
ZIRST 4401                     http://www.mc2.fr

38944 MEYLAN CEDEX             GRENOBLE - FRANCE