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:
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:
That example was taken from MsSql-Server, but for the other ones it's just the same way.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");
|
---|
In Section
Seekers of Perl Wisdom