Hi Objects,
I am having problem in the following case:
I am developing an application using
servlet program.
In which, I need to connect with Database (Oracle)
I have tried with
JDBC Type1 driver(JDBC-ODBC Bridge driver) to connect my servlet with Database with the help of DSN.
But it throws the following SQL exception at runtime:
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source) ...
The same DSN is tested with local
java program(having main method) whic is working fine.
I would like to know,whether JDBC-ODBC brigde driver is supported with Oracle database through Servlet programming?
If yes the how?
If not,then I think we have to use other types of driver(2,3,4).Right?
Please suggest...
Thank you.
Regards
Baseet Ahmed
"God has made every living thing from water."