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.
I use the search function and little else since Windows 11 (but there are times where Saved Searches take precedence since the search feature on the Start menu is worse than before). I use other features in previous releases.
Here is what I don't understand. I know Samsung is supplying the display. But, if it is "out of this world technology, why would Samsung, sell it to their competitor without using it in THEIR phones first?
Question
Got3n
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.
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.
Link to comment
https://www.neowin.net/forum/topic/1054067-java-need-help-with-odbc-and-access-database/Share on other sites
1 answer to this question
Recommended Posts