The driver comes with the JDK. You must reference, and use it with something
like the following:
String query =("SELECT * FROM users_renew ");
StringBuffer budgetBuffer = new StringBuffer("");
/// The JDBC Connection object
Connection con = null;
/// The JDBC Statement object
Statement stmt = null;
/// The JDBC ResultSet object
ResultSet rs = null;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
/// Create a new database connection.
con = DriverManager.getConnection("jdbc:odbc:DATABASE_NAME", "",
"");
/// Create a statement object that we can execute queries with
stmt = con.createStatement();
/// Execute the query
rs = stmt.executeQuery(query);
while(rs.next())
{
System.out.pritntln(rs.getString(1);
}///while
}///try
John D. McDonald
CipherStream Systems
email: [EMAIL PROTECTED]
web: www.cipherstream.com
-------------------------------------------------------
Secure E-Business Is Our Business
-------------------------------------------------------
----- Original Message -----
From: Jenn <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, November 14, 1999 7:37 PM
Subject: Sun JDBC ODBC Driver
> Thanks to all who replied my previous mail,
>
> I think my main problem is to find the driver itself. I went
through the
> java website several times and was told that the
> sun.jdbc.odbc.JdbcOdbcDriver should be found in the Java2 SDK. I have the
> Java2 SDK standard edition 1.2.2 and I keep on receiving the ClassNotFound
> Exception. Should I be doing something to my class path? where is the
> package sun.jdbc anyway? Most importantly, where can I get the driver?
>
> Jenn
>
>
___________________________________________________________________________
> 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
