|
hi, i am trying to connect Ms-access database in my remote machine but it is giving me the following error:"java.sql.sqlexception;//131.254.7.89/DATA DOESNOT EXIST".what should i do to connect to database in a remote machine.i have tomcat server in my machine.plz guide me.
|
>//131.254.7.89/DATA DOESNOT EXIST
What's your remote url? Are you using network file share or AccessServer?
|
i am using network file share.
|
i am using network file share. but it doest not work.what should be done in the tomcat server installed machine.plz guide me as soon as possible.
|
i am using network file share. but it doest not work.what should be done in the tomcat server installed machine.my remote machine ip adress is 131.254.89 and the database is in the F drive under data folder which is shared.i am using the url in the connection method as shown "jdbc:access://///131.254.7.89/data"plz guide me where is the mistake and what i should do.
with regards
|
>jdbc:access://///131.254.7.89/data
Whether do you have the enough security right to access that directory?
You can try:
jdbc:access:///\\131.254.7.89\data
Or
jdbc:access:/
then
select * from "\\131.254.7.89\data\test.mdb".testtable
|
Main
webmaster@hxtt.com