First of all, you should probably use the JDBC drivers that come with Oracle
(or download them from www.oracle.com), but if you need to use the JDBC/ODBC
Bridge, make sure you use a System DSN and not a User DSN.
(*Chris*)
----- Original Message -----
From: "Naresh Singh Chhonker" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, December 08, 1999 3:19 AM
Subject: Connection with oracle
> hi all,
> i am having Drivers
> 1. Microsoft ODBC for oracle of Microsoft Corporation
> 2. Oracle ODBC dirver for Rdb ver 2.10.11.00 of Orcale
> Corperation
> Orcale8 Client on my machine.
> i had Created User DSN entries with name QMS
>
> and write a code of servlet as
>
> // load driver
> Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
> file://get Connection
> con =
DriverManager.getConnection("jdbc:odbc:QMS","qms","qms");
> stmt = con.createStatement();
> rs = stmt.executeQuery("SELECT NAME FROM abcd");
> display result set rs in html
> file....................................................
>
> and it is not working
> What can I do now? So that my servlet works
>
> thank you in advance
> naresh chhonker
>
>
___________________________________________________________________________
> 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
