Search code examples
sqlms-accessjtds

JTDS with absolute path (JDBC connection to an Access MDB File)

I've spent lots of time searching a solution to this, tried Google it, BING it, tried JTDS community but no solution, or maybe I haven't searched enough, nevertheless this is my situation:

I have the JTDS library in my project, and want to connect to a local MDB database file located at a local folder (C:\path\to\databasefile.mdb), but all I see is that I need the following connection String:

"jdbc:jtds:sqlserver://url:port[;option1]..."

I want to use something like this:

"jdbc:jtds:sqlserver://[C:\\path\to\databasefile.mdb]:port[;option1]..."

is it possible?

Solution

  • Moved into using Jackcess... http://jackcess.sourceforge.net/

    I needed a solution to read/write access local databases, which a jdbc-odbc bridge on a 64 bit machine cannot be accomplished.