• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

MS Access database

 
Javed Mohammed
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.



PA is the ODBC connection to the actual database.

 
Shinelin Samuel
Ranch Hand
Posts: 55
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Bartender
Posts: 2608
14
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic