naisha
September 14th, 2000, 09:30 PM
I am using Sun Java Web Server 2.0 and trying to make a database connection using jsp w/ bean. But it always got a message error that the "Database URL is wrong", when i tried to make the database connection.
Some details are as follow:
- Database source is a MS. Access which has been set up with a Microsoft Access ODBC driver. (Set in the ODBC Data Source Administrator in Windows Control Panel)
- JDBC-ODBC Bridge driver-"sun.jdbc.JdbcOdbcDriver" is used to access the database mentioned above.
- JSP files are located at [server]\public_html directory and the bean file is at [server]\classes directory.
I have been stuck with this issue for few days. Still don't know what's wrong with the codes.
Perhaps this has something to do with the subname syntax of the JDBC URL; jdbc:odbc:<subname>.
Or perhaps the location (directory) where I should put the database source then setting it up in the Java Web Server 2.0 administration tool ?
I would appreciate all kinds of comments/suggestions.
Thanks in advance.
JJ
Some details are as follow:
- Database source is a MS. Access which has been set up with a Microsoft Access ODBC driver. (Set in the ODBC Data Source Administrator in Windows Control Panel)
- JDBC-ODBC Bridge driver-"sun.jdbc.JdbcOdbcDriver" is used to access the database mentioned above.
- JSP files are located at [server]\public_html directory and the bean file is at [server]\classes directory.
I have been stuck with this issue for few days. Still don't know what's wrong with the codes.
Perhaps this has something to do with the subname syntax of the JDBC URL; jdbc:odbc:<subname>.
Or perhaps the location (directory) where I should put the database source then setting it up in the Java Web Server 2.0 administration tool ?
I would appreciate all kinds of comments/suggestions.
Thanks in advance.
JJ