no suitable driver 1

[Smarty]

I want to use database access in my java program, but while running the program, I always get "No suitable driver found"

I guess the class 'sun.jdbc.odbc.JdbcOdbcDriver' is not found. Can someone help me to get this working?

Thanx,
Smarty

 

[ksolos]

You should always post your code with these kind of questions....

 

[Smarty]

code sections:

import java.sql.*;

[...]

try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"
Connection conn = DriverManager.getConnection(
"jdbcdbc:kamernet",
"",
""
Statement stmt = con.createStatement();

ResultSet rs = stmt.executeQuery("SELECT * FROM KHNK_KH_CONTACTPERSOON "

 

[ksolos]

The driver should be part of your default jre/jdk install...

what jdk do you have and what are your classpaths set to?

ksolos

 

[Smarty]

I have the jdk1.2.2 and my classpath is set to
c:\classpath (containing mailjars etc)
c:\jdk1.2.2\ (containing src.jar)
I also tried with
c:\jdk1.2.2\lib and c:\jdk1.2.2\jre\lib but none of this works.

 

[ksolos]

http://java.sun.com/j2se/1.3/docs/guide/jdbc/getstart/bridge.doc.html

(Taken from sun website for reference)

is a great source about the bridge. This may also have an answer.

ksolos

 

[ksolos]

you have an ODBC data source (DSN) set up properly?

 

[Smarty]

I have seen this before, but this also doesn't give me the answer on where these classes should be, how I can see them, or where I can download them

Thanks for your help already,

 

[ksolos]

All the jdbcodbc classes are in the rt.jar file. I would explicitly refrence this jar file in your classpath !!

this should work...

 

[Smarty]

I caught the classnotfoundexception, and it worked!
Thanks for your help