Hi,
It seems that you have downloaded thin driver type 4 jdbc driver.
for that the Driver class name will be different. it wont be lik
sun.jdbc.odbc.jdbcodbcdriver.
check the site for documentation of how to use the driver.
Regards,
Sukumar
Gilson Nascimento D Elrei wrote:
> sorry if it's off topic,
> I have downloaded from oracle.com the jdbc driver for Oracle 8.1.5 and i
> have upload the zipped files (classes111.zip and nls_charset.zip) on
> <jrun_root>\lib that is on classpath; I'm trying to connect using JDBC/ODBC
> bridge.
> My Question is:
> - Where's the common Jar Files like mysql jdbc driver ?
>
> The JSP code is here (go down), and it's ok on Tomcat using Mysql driver;
> Oracle documentation is confuse about How to access Oracle Database using
> JDBC;
> Any Idea?
> Thanks in advance;
>
> <%@ page import="java.sql.*" %>
> <%
> String connectionURL = "jdbc:odbc:aceite";
> Connection connection = null;
> Statement statement = null;
>
> ResultSet rs=null;
> %>
> <html><body>
> <%
> Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
> connection =
> DriverManager.getConnection(connectionURL,"aceite","pwdsomaace");
> statement = connection.createStatement();
> rs = statement.executeQuery("SELECT * FROM tsm_client");
> while (rs.next())
> {
> out.println(rs.getString("cd_clie")+"<br>");
> }
> rs.close();
> %>
> </body>
> </html>
>
> ===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
> For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
--
*******************************
S.Sukumar,
HP-ESD India,
19, Cunningham Road,B'lore-52
Phone : 2051959 / 2251554 extn: 1959
Voice Mail : (408) 447 6735
Home Page: http://sukumar.enmail.com
*******************************
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
