• 0

[Java] Need Help with ODBC and Access Database


Question

So I have an access database, its a phone directory basically. I had it in an mdb format, i setup an ODBC connection under the system DSN. I chose the appropriate dirver and selected the database on my network drive, lets say Z:\access.mdb, i get the following error when the application tries to update the database from the file.


INFO | jvm 1 | 2012/01/25 14:43:01 | java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
INFO | jvm 1 | 2012/01/25 14:43:01 | at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958)
INFO | jvm 1 | 2012/01/25 14:43:01 | at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)
INFO | jvm 1 | 2012/01/25 14:43:01 | at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:3074)
INFO | jvm 1 | 2012/01/25 14:43:01 | at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:323)
INFO | jvm 1 | 2012/01/25 14:43:01 | at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:174)
INFO | jvm 1 | 2012/01/25 14:43:01 | at java.sql.DriverManager.getConnection(DriverManager.java:512)
INFO | jvm 1 | 2012/01/25 14:43:01 | at java.sql.DriverManager.getConnection(DriverManager.java:171)
INFO | jvm 1 | 2012/01/25 14:43:01 | at com.tenovis.apps.ospc.updateservice.UpdateTask.createResultSet(UpdateTask.java:200)
INFO | jvm 1 | 2012/01/25 14:43:01 | at com.tenovis.apps.ospc.updateservice.UpdateTask.run(UpdateTask.java:152)
INFO | jvm 1 | 2012/01/25 14:43:01 | at java.util.TimerThread.mainLoop(Timer.java:432)
INFO | jvm 1 | 2012/01/25 14:43:01 | at java.util.TimerThread.run(Timer.java:382)
[/CODE]

If i point the ODBC connection to the C:\ drive and copy the access.mdb there it works no problem. This database is updated by a service run by another program, I have run the service as a domain user who has full permissions to the shared directory and still come up empty, any help would be appreciated.

I dont want people messing the the sql database, so they update the access database, which in turn the application then accesses the database (access.mdb) and imports changes into the SQL database.

1 answer to this question

Recommended Posts

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Posts

    • Right Click on My Computer Icon -> Properties(?)
    • HomeBank 5.9.2 by Razvan Serea HomeBank is a free software (as in "free speech" and also as in "free beer") that will assist you to manage your personal accounting. It is designed to easy to use and be able to analyse your personal finance and budget in detail using powerful filtering tools and beautiful charts. If you are looking for a completely free and easy application to manage your personal accounting, budget, finance then HomeBank should be the software of choice. HomeBank also benefits of more than 19 years of user experience and feedback, and is translated by its users in around 56 languages. Highlights: Cross platform, supports GNU/Linux, Microsoft Windows, Mac OS X Import easily from Intuit Quicken, Microsoft Money or other software Import bank account statements (OFX, QIF, CSV, QFX) Duplicate transaction detection Automatic cheque numbering Various account types : Bank, Cash, Asset, Credit card, Liability Scheduled transaction Category split Internal transfer Month/Annual budget Dynamic powerful reports with charts Automatic category/payee assignment Vehicule cost HomeBank 5.9.2 fixes: bugfix: #2112135 scheduled with limitation don't stop and goes erroneous data bugfix: #2111663 variable scope issue in ui-assign.c bugfix: #2111359 remind status not synced in transfers Download: HomeBank 5.9.2 | 20.2 MB (Open Source) Download: 3rd party packages (macOSX. Ubuntu...etc) View: HomeBank Website | Support | Features | Screenshot Get alerted to all of our Software updates on Twitter at @NeowinSoftware
    • How long until the Windows 11 hating bots come and say that Windows 11 committed atrocities against their family and their dog?
  • Recent Achievements

    • Week One Done
      jbatch earned a badge
      Week One Done
    • First Post
      Yianis earned a badge
      First Post
    • Rookie
      GTRoberts went up a rank
      Rookie
    • First Post
      James courage Tabla earned a badge
      First Post
    • Reacting Well
      James courage Tabla earned a badge
      Reacting Well
  • Popular Contributors

    1. 1
      +primortal
      400
    2. 2
      +FloatingFatMan
      178
    3. 3
      snowy owl
      171
    4. 4
      ATLien_0
      169
    5. 5
      Xenon
      134
  • Tell a friend

    Love Neowin? Tell a friend!