1. what is the most likely cause of this error message.
rgc-ad/Public/Engineering/Mercury/db1.mdb doesn't exist or can't be
accessed!
2. In trying to use the JDBC driver
from an IBM AS400, is it necessary for me to start the Access Server?
|
>rgc-ad/Public/Engineering/Mercury/db1.mdb
Try jdbc:access:////rgc-ad/Public/Engineering/Mercury/db1.mdb if your path is /rgc-ad/Public/Engineering/Mercury/db1.mdb
>In trying to use the JDBC driver from an IBM AS400, is it necessary for me to start the Access Server?
You needn't. It's a pure Java engine, and it can access your mdb file if java.io.* package can access that file. But if you are accessing a mdb file on Windows from AS400, maybe you will meet security limiation issue, then we will discuss more about it.
|
OK, tried jdbc:access:////rgc-ad/Public/Engineering/Mercury/db1.mdb. Still receiving same message.
If i open explorer and type in the following \\rgc-ad\public\Engineering\mercury\db1.mdb the file opens.
If i try to access this path from the AS400, i get invalid Database URL.
I can access this file from my desktop via a java program or just typing in the URL from explorer or from DOS Cmd prompt.
Any other ideas.
Thanks.
|
>OK, tried jdbc:access:////rgc-ad/Public/Engineering/Mercury/db1.mdb. Still
> receiving same message.
>>If i open explorer and type in the following \\rgc-ad\public\Engineering\mercury\db1.mdb the file opens.
I see now. rgc-ad is a host name, then you should use jdbc:access://///rgc-ad/Public/Engineering/Mercury/db1.mdb (five continuous'/')
|
I have tried using the five continuous '/' as directed above. Still receiving the 'doesn't exist or can't be accessed message.
I don't know if it matters or not, but i am using JNI functions.
anything else i can try?
|
1. Try JDBC url:
jdbc:access:/\\rgc-ad\public\Engineering\mercury\db1.mdb
In Java code, you can should use two \\ for every \.
2. Try SAMBA url to skip security issue.
|