Sunil,

Go into your ODBC Administration and check what type of ODBC Data Source
Name you have configured. Most likely it's a "user" DSN (which is the
default). If a servlet engine is installed as an NT service (which JWS is)
then it will only have access to a "system" DSN. This is why a regular
application can find your ODBC DSN and the servlet engine can't.

If anyone is interested I have a servlet which uses native code that lists
all of the ODBC Data Source Names available to the servlet engine (it's one
of the examples I developed for the upcoming second edition of "Java
Servlets"). I'm putting together a new web site that will contain all of the
examples, but I'd be glad to send it along to anyone who wants it.

Karl.

-----Original Message-----
From: Sunil Reddy.T [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 21, 1999 6:23 AM
To: [EMAIL PROTECTED]
Subject: odbc driver conncection exception


Iam getting an exception when iam connecting to the data base(msaccess)
using servlets  in the JWS server
 exception java.sql.SQLException:
[Microsoft][ODBC Driver Manager] Data source name not found and
 no default driver specified
  iam able to connect to the same data base using applets and
 through  standalone programs  using jdk1.1
  iam using javawebserver1.1 and iam not able to cope up
   with the problem
  any one can suggest me a solution
sunil

___________________________________________________________________________
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

___________________________________________________________________________
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

Reply via email to