Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot
 
PerlMonks  

Re: create ODBC DSN entries in Windows

by Asim (Hermit)
on Sep 06, 2006 at 19:54 UTC ( [id://571535]=note: print w/replies, xml ) Need Help??


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.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://571535]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (4)
As of 2024-04-20 10:10 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found