MS Access database

[Javed Mohammed]

ADMINS : I have duplicated this post in 'Engineering - general computing' by mistake. Please delete the other one. Thank you.

Hi,

I am using an MS Access database and JDBC-ODBC Bridge with ODBC connection to get my data. This works fine when the database is on local computer but fails when the database is on network

Am I missing anything? I am posting the DB connection code below.

Thank you for the help.

Javed.

    

            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection con = DriverManager.getConnection("jdbc:odbc:PA", "", "");
            return con;

PA is the ODBC connection to the actual database.

[Shinelin Samuel]

Javeed,

The DB connection url should have the following.
jdbcdbc://servername/datasource:logonuser=username:logonpassword=password

Looks like you are missing the DB host (server) name, and also make sure you create a datasource in the host machine as well.


Regards,
Shinelin

[Jan Cumps]

Hi Javed,

Is your ODBC source PA set up as a system datasource?
Does the ODBC connection work? You could use an ODBC Test Utility (Google for it) to see if the ODBC datasource works.
Does the (operating system) user that runs the java application have rights to access the Access file on the network?
Is the failing database on the network the same one as the succeeding database on your computer?
Can you show us how you configured the ODBC source?

What does "fails" mean? Can you show us the complete error message?


(aside: MS Access is not really suited for network access.)

Regards, Jan