DSN too long- ODBC Error. i've tried everything!

[Brett Swift]

Using: VisualAge 2.0, Access2000.
I've double checked my DSN pointing to the right DB, and checked my code. My Select query works fine, but when I try to dynamically connect to the DB I get the error that my DSN name is too long. If I don't connect dynamically, then I get an error saying 'Optional Feature Not Implemented'.
I have the Jet 4.0 driver, haven't found any later releases.
I know Access isn't a great database, but its only going to be deployed on 1 computer.
If anyone has had this much trouble with this, please offer any solutions you have.
The code I am using is below. There is a lot of code commented out so you can see the code I am using for dynamic/non dynamic DB connections, as well as normal statements and PreparedStatements.
I hope someone out there can offer a helpful tip! Thanks!

 public void addCar(Object aCar) {
/* Perform the addCar method. */
CarData addCar = (CarData)aCar;
CarData carX = new CarData(addCar);
carX.setMake(addCar.getMake());
carX.setName(addCar.getName());
carX.setColor(addCar.getColor());
carX.setPrice(addCar.getPrice());
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();

java.sql.Connection con = null;
java.sql.Statement stmt = null;
java.sql.ResultSet rs = null;
/*
//   \" will put the quote into the string.
String str = "INSERT INTO tblCars (Make,Name,Color,Price)" ;
str += " VALUES  (\"" + carX.getMake() +" \",\" "+ carX.getName();
str +=  " \",\" "+ carX.getColor() +" \", "+carX.getPrice()+ ")";
con = java.sql.DriverManager.getConnection("jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=C:\\DBs\\Car.mdb","","");
//con = java.sql.DriverManager.getConnection("jdbc:odbc:Car","","");
stmt = con.createStatement();
int result = stmt.executeUpdate(str);
*/
//con = java.sql.DriverManager.getConnection("jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=C:\\DBs\\Car.mdb","","");
con = java.sql.DriverManager.getConnection("jdbc:odbc:Car","","");
//preparedStatement to fix too few parameters error.
//although this gives "optional feature not implemented" error.

java.sql.PreparedStatement pstmt = con.prepareStatement("INSERT INTO tblCars(Make,Name,Color,Price) VALUES (?,?,?,?)");
pstmt.setString(1,carX.getMake());
pstmt.setString(2,carX.getName());
pstmt.setString(3,carX.getColor());
pstmt.setFloat(4,carX.getPrice());

pstmt.executeUpdate();


addElement("added");
}
catch(Exception ivjExc)
{
com.sun.java.swing.JFrame jfMessage = new com.sun.java.swing.JFrame();
com.sun.java.swing.JOptionPane.showMessageDialog(jfMessage, ivjExc.getMessage());
}
finally
{}
return;
} 

[ August 03, 2002: Message edited by: Brett Swift ]
ps. how do you get rid of those smileys!!!??
[ August 03, 2002: Message edited by: Brett Swift ]

(Let's see if this is better -- Marilyn)
[ August 04, 2002: Message edited by: Marilyn de Queiroz ]

[Marilyn de Queiroz]

At the bottom of the editing page, below the box where you type, below the smilies are some checkboxes. One is "Disable smilies in this post".

[Peter Reinhardt]

I think DSN less connection strings are not supported for MS Access.
Have a look at:
dsn less connection strings
Peter.