Problem with ODBC of Oracle8i

[id29]

Hi,
I was trying to create a JSP application page connecting with Oracle8i database. I am working on Windows 2000 server with JDK 1.2, Java Web Server 2.0. While adding the DSN in the ODBC Data Source Administrator in the control panel, I am using the only Oracle ODBC Driver (SQORA32.dll).

While execution it is not connecting to the Oracle data source.

When I am using a Ms Access data source, I am adding the DSN and using Microsoft Access Driver (ODBCJT32.dll), in the ODBC Data Source Administrator in the control panel.

The program is connecting with Ms Access data source and is executing smoothly.

I would like to know why I am unable to connect with the Oracle data source ? How I can get it done ?

Thanx.

 

[spenglerr]

Hi

try the JDBC-driver and not the ODBC from Oracle