in reply to create ODBC DSN entries in Windows

this script creates the dsn using sql server authentication. what i need is windows authentication.

Unless I'm wrong, the "SQL Server" refered to in:

my $result = Win32::ODBC::ConfigDSN( ODBC_ADD_DSN, "SQL Server", ## this last is the driver name ( ##options "DSN=$dsn", ## DSN identifier "NETWORK=DBMSSOCN", ## use TCP/IP library "SERVER=test_server", ## server name "DATABASE=test_db", ## database name "DESCRIPTION=My test DSN" ) ); ## end of ConfigDSN call
is a reference to the driver, NOT the authentification; it says as much in the code, itself. The authentification for who's allowed to create the DSN is based on, basically, the login that runs the program.

----Asim, known to some as Woodrow.