Problem connecting Microsoft Access to Java GUI

[Chrysler]

public Connection connect() {
//Connection conn;
String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
String url = "jdbc:easysoft://localhost/C:/Documents and Settings/Chrysler/Desktop/MovieDatabase.accdb";
String username = "Chrysler";
String password = "chrisujt782";

try{
Class.forName("easysoft.sql.jobDriver").newInstanc e();
conn = DriverManager.getConnection(url, username, password);
new JOptionPane().showMessageDialog(null, "IT WORKED");
}catch(Exception e){System.out.println(e.getMessage());}
finally{return conn;}
}

-- The catch block always prints "valid logonuser and optional logonpassword must be specified to gain access to this system". I've tested the user name and password on a separate program linked to the same database and everything works fine on that separate program. Any ideas anyone?? Thanks in advance.

[masijade]

Try leaving off the "//localhost/"

Edit: Then again nevermind. I have no idea about this "easysoft" driver. I would say to ask the authors.

[Chrysler]

i tried leaving it out, but it returns an error. thanks anyway.

[Tolls]

Does the documentation for this driver tell you what the format of the url should be?

I'm wondering if the uname and pword should be stuck into the url...

[Tolls]

Quoting from this easysoft page.

Why can’t I connect to my Microsoft Access .mdb file using the Easysoft JDBC-ODBC Bridge?
...
Add the following attributes to the JDBC connection URL:

logonuser=username:logonpassword:password

So uname and pword need to be part of the url.

[Chrysler]

"jdbc:easysoft://127.0.0.1/C:/Documents and Settings/Chrysler/Desktop/MovieDatabase.accdb:logonuser=
Chrysler:logonpassword=chrisujt782"

jdbc:easysoft://127.0.0.1/C:/Documents and Settings/Chrysler/Desktop/MovieDatabase.accdb:logonuser=
'Chrysler':logonpassword='chrisujt782' "

"jdbc:easysoft://localhost/C:/Documents and Settings/Chrysler/Desktop/MovieDatabase.accdb:logonuser=
Chrysler:logonpassword=chrisujt782"

hey thanks for the tip. i've tried all of the above, but it doesnt seem to work. the catch block prints out a syntax error this time,
Syntax Error in jdbc url at '/Documents and Settings/Chrysler/Desktop/MovieDatabase.accdb:logonuser=Chrysler:logonpasswo rd=chrisujt782'

this is becoming a pain in the neck hahaha

[masijade]

Describe, in full, "doesn't seem to work".

Also, that user and password, are those set in the Acess DB? If so those options are user and password. logonuser and logonpassword are, obviously, the user and password you use to log onto that system. Also, if you log onto that system using a domain, the the user is probably not "Chrysler", but rather "Domain\Chrysler".

Edit: You did, also, see the note about "non-local admin" users in the documentation, right?

[Tolls]

Is there a difference between an accdb and an mdb?
I know next to nothing about Access and its varieties.

Which driver is it you're using?
Do you have the documentation for it?
Since easysoft have several drivers it's quite possible I picked the wrong one to look at...

ETA: See? Can't rely on some chap on t'internet to do your googling and documentation reading for you...
:)

[masijade]

Is there a difference between an accdb and an mdb?
I know next to nothing about Access and its varieties.

Which driver is it you're using?
Do you have the documentation for it?
Since easysoft have several drivers it's quite possible I picked the wrong one to look at...

ETA: See? Can't rely on some chap on t'internet to do your googling and documentation reading for you...
:)

"accdb" is Access 2007 (and later)
"mdb" is Access 97-2003

[Tolls]

Ta.
Thought it might be something like that.