ODBC DSN connection to Oracle
I am using Microsoft ODBC driver for Oracle using system DSN I created for Oracle.
I don't want to provide userid/password in connection string on asp page for security reasons. On some websites I found code sample which doesn't provide uid/pwd after DSN at all, for example:
Set oConn = Server.CreateObject("ADODB.Connection")
When i run this code, I get error message "ORA-01017: invalid username/password; logon denied".
Was someone able to make it work by using system DSN and this type of connection without providing uid/pw ?
Appreciate any help.