Hi,
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")
oConn.Open "DSN=MySystemDSN"
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.

No I have never got this to work with out providing a UN and PW through code.

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature