• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Paul Clapham
  • Ron McLeod
Sheriffs:
  • Jeanne Boyarsky
  • Liutauras Vilda
Saloon Keepers:
  • Tim Holloway
  • Carey Brown
  • Roland Mueller
  • Piet Souris
Bartenders:

MS Access database

 
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.

 
Ranch Hand
Posts: 55
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Bartender
Posts: 2662
19
Netbeans IDE C++ Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Consider Paul's rocket mass heater.
reply
    Bookmark Topic Watch Topic
  • New Topic