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

Re: DSN's

by strat (Canon)
on Dec 04, 2001 at 20:24 UTC ( #129353=note: print w/ replies, xml ) Need Help??


in reply to DSN's

By the way: if you are looking for the options to Win32::ODBC::ConfigDSN, just enter a DSN manually and then goto Registry into the following Branch:
SystemDsn: HKEY_LOCAL_MACHINE\Software\ODBC
UserDsn: HKEY_CURRENT_USER\Software\ODBC
and browse through the subdirectories. If there you find a value like "Thrusted_Connection" with the value "Yes", then just use it about like that:

if (Win32::ODBC::ConfigDSN( ODBC_ADD_SYS_DSN, "SQL Server", ( "DSN=$dsn", "DESCRIPTION=$dsnDescription", "SERVER=$sqlServer", "DATABASE=$database", "UID=$uid", "PWD=$password", "Trusted_Connection=Yes", ) ) ){ print ("DSN $dsn sucessfully created\n");
That example was taken from MsSql-Server, but for the other ones it's just the same way.


Comment on Re: DSN's
Download Code

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (13)
As of 2014-12-22 13:43 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (118 votes), past polls