Hi,
Thanks for the prompt reply, but could you please
eloberate as I could not cleary understand what you
meant.
Unlike as I stated before, the JVM in IPlanet can
now see the JDBC-ODBC Driver classes, because I
changed the name of the driver ( just appended "1" at
the end) and found that it gave a
ClassNotFoundException
..
..
[09/Jun/2000:22:27:08] info ( 172): /servlet/Login:
After passing the contraints
[09/Jun/2000:22:27:08] info ( 172): /servlet/Login:
111a1111111
[09/Jun/2000:22:27:08] info ( 172): /servlet/Login:
----java.lang.ClassNotFoundException:
sun.jdbc.odbc.JdbcOdbcDriver1
[09/Jun/2000:22:27:08] info ( 172): /servlet/Login:
11111444411111
..
..
So the error is not beacuse of the classes not
being found to the JVM, but because of the
registering of the dirver name and stuff like that.
So after correcting the driver name I am getting the
following error.
..
..
[09/Jun/2000:22:23:54] info ( 286): /servlet/Login:
111a1111111
[09/Jun/2000:22:23:54] info ( 286): /servlet/Login:
111b1111111
[09/Jun/2000:22:23:57] info ( 286): /servlet/Login:
----java.sql.SQLException: [Microsoft][ODBC Driver
Manager] Data source name not found and no default
driver specified
[09/Jun/2000:22:23:57] info ( 286): /servlet/Login:
11111444411111
..
..
My code is as follows
..
..
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con =
DriverManager.getConnection("jdbc:odbc:book_store");
..
..
I went to control panel and then to ODBC Drivers
and registerd a driver with a name book_store. So
could you please help me solve this problem
Thank You very much,
Sreenu
--- Roussi Popov <[EMAIL PROTECTED]> wrote:
> Hi!
> JDBC-ODBC drver uses System Data Source Name
> registered in ODBC.
> May be you have ristered your data source name as
> user or file DSN.
>
> Regards,
> Roussi
>
> -----Original Message-----
> From: sreenu pallepati [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, June 08, 2000 10:47 PM
> To: [EMAIL PROTECTED]
> Subject: jdbc & servlet connectivity
> question...please help
>
>
> Hi ,
> I have problem with connecting to the Database
> from servlets.
> I working on windows NT. I am using IPlanet Web
> Server. I wrote a class to connect to he MS Access
> database which uses jdbc.odbc driver.
> It is working fine if I run it as an stand
> alone
> program i.e by invoking its main() method. But when
> I
> use it in a servlet, I am getting the following
> error.
>
> [SQLException]Driver Manager. Data source name not
> found and default driver is not found.
>
> I checked the name given to the driver and data
> sourse, they are correct.
> the code is as follows
>
> Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
> Connection con =
> DriverManager.getConnection("jdbc:odbc:bookstore");
>
> The problem is that the program is compiling
> correctly but giving error at runtime i.e it is
> unable to get the connection , which might be
> because
> the "java virtual machine" which IPlanet uses might
> have not found the class for jdbc.odbc dirver
> classes.
> ( Its just a guess becuase I can not think of any
> thing else )
> If some one can tell me if I should include some
> other classes of JDBC.ODBC Bridge dirver in the JRE
> path of the IPlanet which might solve the problem,
> or
> some thing else, it would be a great help.
> Thank You in advance.
> Sreenu
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Photos -- now, 100 FREE prints!
> http://photos.yahoo.com
>
>
___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED]
> and include in the body
> of the message "signoff SERVLET-INTEREST".
>
> Archives:
>
http://archives.java.sun.com/archives/servlet-interest.html
> Resources:
>
http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help:
> http://www.lsoft.com/manuals/user/user.html
>
__________________________________________________
Do You Yahoo!?
Yahoo! Photos -- now, 100 FREE prints!
http://photos.yahoo.com
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
