I'm working on WIN 2k pro and I have a simple Access database that I'm trying to connect to. I set up a data source in control panel, went through the advance function and made an anonymous user and a guest password available. So in my code, when I call DriverManager.getConnection( url, username, password ); it throws an SQLException on me. I've tried everything I can think of, creating a user dsn and a system dsn (what's the difference?). I tried placing the saved database in the same directory as my source code,no luck. I named the database the same as the dsn. I used for url: jdbc dbc:user and I had loaded the driver class with this: Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
does anybody no if I missed something?
SCJP 1.4 SCJD 1.5
Joined: Jan 11, 2002
Nevermind guys, I figured it out. I didn't select the db when I set up the dsn!