i want to use access driver so downloaded your HXTT Accessv3.1
in my java code i want to use database of other system
i have return below code:
for getting connection
Class.forName("com.hxtt.sql.access.AccessDriver");
Connection con = DriverManager.getConnection("jdbc:access://///192.168.1.159/C:/Electronic part 30-05-07.mdb");
i am getting the following error:
Exception in thread "main" java.sql.SQLException: //192.168.1.159/C:/Electronic
part 30-05-07.mdb doesn't exist or can't be accessed. If you're using mapped dr
ves to access database files, you may need to check the security permissions.
at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.sql.bm.a(Unknown Source)
at com.hxtt.sql.access.ae.(Unknown Source)
at com.hxtt.sql.access.EmbeddedDriver.connect(Unknown Source)
at com.hxtt.global.SQLState.getConnection(Unknown Source)
at com.hxtt.sql.HxttDriver.if(Unknown Source)
at com.hxtt.sql.HxttDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at GetTab.main(GetTab.java:9)
i have another doubt like oracle we can use this access driver or not:
jdbc:oracle:thin:@localhost:1521:dbsname
give me replay as early as possible please
|
>jdbc:access://///192.168.1.159/C:/Electronic part 30-05-07.mdb
If that program is run on 192.168.1.159, you can use jdbc:access:/C:/Electronic part 30-05-07.mdb .
If your program is on the different host, but has right to access 192.168.1.159, you can use jdbc:access:///\\192.168.1.159\C$\Electronic part 30-05-07.mdb
Remote Access Questions and Client/Server Mode Questions is at here.
|