I use com.hxtt.sql.access.AccessDriver to connect
from Java program in Linux environment to
MS Access database located:
Domain: DOC
Server: hud-aiu-srv1\aiubkp (10.240.178.51)
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Class.forName("com.hxtt.sql.access.AccessDriver");
1). conn = DriverManager.getConnection("jdbc:access://///10.240.178.51//hud-aiu-srv1\\aiubkp\\05-Friday\\NYCDOC.mdb");
Exception:
java.sql.SQLException: //10.240.178.51//hud-aiu-srv1\aiubkp\05-Friday\NYCDOC.mdb doesn't exist or can't be accessed!
Why it can not be accessed ?
The statement is correct ?
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
2). conn = DriverManager.getConnection("jdbc:access://DOC:3099:/hud-aiu-srv1\\aiubkp\\05-Friday\\NYCDOC.mdb");
Exception: Invalid port number: 3099.
What port number to be used ?
Regards
Vladimir Lyakhovich
|
use com.hxtt.sql.access.AccessDriver to connect
from Java program in Linux environment to
MS Access database located:
Domain: DOC
Server: hud-aiu-srv1\aiubkp (10.240.178.51)
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Class.forName("com.hxtt.sql.access.AccessDriver");
1). conn = DriverManager.getConnection("jdbc:access://///10.240.178.51//hud-aiu-srv1\\aiubkp\\05-Friday\\NYCDOC.mdb");
Exception:
java.sql.SQLException: //10.240.178.51//hud-aiu-srv1\aiubkp\05-Friday\NYCDOC.mdb doesn't exist or can't be accessed!
Why it can not be accessed ?
The statement is correct ?
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
2). conn = DriverManager.getConnection("jdbc:access://DOC:3099:/hud-aiu-srv1\\aiubkp\\05-Friday\\NYCDOC.mdb");
Exception: Invalid port number: 3099.
What port number to be used ?
Regards
Vladimir Lyakhovich
|
>1). conn = DriverManager.getConnection("jdbc:access://///10.240.178.51//hud-
>aiu-srv1\\aiubkp\\05-Friday\\NYCDOC.mdb");
>Exception:
>java.sql.SQLException: //10.240.178.51//hud-aiu-srv1\aiubkp\05-
>Friday\NYCDOC.mdb doesn't exist or can't be accessed!
Are you accessing Windows file from Linux? It's security issue. You need to login manually Windows SAMBA service, or use SAMBA table.
>2). conn = DriverManager.getConnection("jdbc:access://DOC:3099:/hud-aiu-srv1
>\\aiubkp\\05-Friday\\NYCDOC.mdb");
>Exception: Invalid port number: 3099.
Wrong url. First, ://DOC:3099:/ should be ://DOC:3099/ . Secondly, you should run An AccessServer at doc:3099.
|