I need to run a vbscript (from a windows 2003/2008 server) that will use a system DSN ODBC connection to a sybase database on a Unix server to do a query. (select statement)
I cant have the password in the script (cleartext) so I want to configure a DSN with the username and password in there .
It this possible?
Can I call a DSN odbc connection from VBscript and use something like trusted for the credentials?
If so, what do I use to open the connection to the DB?
The user account and password will be local sybase user/pass.