I am running JRun4 server with an Oracle database. If I set up the ODBC data source with the host IP, SID, port and user ID and password, everything works fine. Now, since I wanted to have a logon page to authenticate the user and don't want to store the user name/password on the server, I removed the userID/password. After I restarted the server, I got the following exceptions: 04/18 14:23:04 error SQLException occurred in JDBCPool while attempting to conne ct, please check your username, password, URL, and other connectivity info. java.sql.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-01017: invali d username/password; logon denied at macromedia.jdbc.base.BaseExceptions.createException(Unknown Source)
And when I try to look the data source, I got the following exception: javax.naming.NameNotFoundException: No such binding: myOdbc java.lang.NullPointerException What should I do? Thanks, Walter
Joined: Jan 10, 2003
So in a nutshell, what I want to do is simply set up a ODBC data source without storing the user ID and password on the server (in this case JRun4). What is the best way to do this?