Angela What exception does it give you? Is it a ClassNotFoundException because it cant find the classes 'textFileDriver' and 'imaginary.sql.iMsqlDriver:'. Or does the colon on the end of the second one have something to do wtih it?
Originally posted by Angela D'souza: What should I set in Classpath? Thanks, Angela
the classpath has the path's to all needed java classes that you use. There should be a classpath entry pointing to sun's java classes ( jdk ), you should have also have an entry to the place where your jdbc drivers reside. If you downloaded your mySQL drivers to c:/jdbc/drivers/<driver_name>.zip then you should have a classpath entry in your autoexec.bat file of 'c:/jdbc/drivers;' which will allow your java programs to find the java classes that your driver uses to implement the JDBC interface. if you are using sun's jdbc dbc drivers then you will not have to alter your classpath, but you must set up the database as an ODBC datasource before you can connect to it. Jamie