|
Subject:
|
ODBC DSN connection to Oracle
|
|
Posted By:
|
Vera
|
Post Date:
|
12/14/2006 4:54:04 PM
|
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.
|
|
Reply By:
|
dparsons
|
Reply Date:
|
12/15/2006 9:13:10 AM
|
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
|
