D
dhotman
Hello everyone,
As someone who's never really used MS Access I need some help
please
We have a requirement to retrieve data from an MS Access database
running on a Windows 2000 server from a J2EE application server
running on a Linux machine.
using a JDBC - ODBC bridge from EasySoft.
This all works very well as long as the Acess database is on the same
machine that the JDBC - ODBC bridge is installed on but if the Access
database (.mdb file) is on a network share the connection fails. A
little more detail around the configuration.
Machine1:
- MS Access database
Machine2:
- Mapped drive on to network share from machine1
- Easysoft JDBC - ODBC bridge
- System Data Source connecting to the remote mdb file
Machine3:
- J2EE Application server
- JDBC connection to the Easysoft JDBC bridge on machine2
If the mdb file is on machine2 everything works fine but if its on
machine1 then it fails.
I found a knowledge base article on the Easysoft website (http://
www.easysoft.com/support/kb/kb00813.html) that talks about Microsoft
Access .mdb file on a mapped network drive only being accessed by a
named user.
I don't really know what that means because I've checked that the file
is accessible from all of the machines...
Any assistance would be appreciated.
Thank yo
As someone who's never really used MS Access I need some help
please

We have a requirement to retrieve data from an MS Access database
running on a Windows 2000 server from a J2EE application server
running on a Linux machine.
makes most sense and as Access does not support JDBC natively we areFrom the application server point of view using a JDBC connection
using a JDBC - ODBC bridge from EasySoft.
This all works very well as long as the Acess database is on the same
machine that the JDBC - ODBC bridge is installed on but if the Access
database (.mdb file) is on a network share the connection fails. A
little more detail around the configuration.
Machine1:
- MS Access database
Machine2:
- Mapped drive on to network share from machine1
- Easysoft JDBC - ODBC bridge
- System Data Source connecting to the remote mdb file
Machine3:
- J2EE Application server
- JDBC connection to the Easysoft JDBC bridge on machine2
If the mdb file is on machine2 everything works fine but if its on
machine1 then it fails.
I found a knowledge base article on the Easysoft website (http://
www.easysoft.com/support/kb/kb00813.html) that talks about Microsoft
Access .mdb file on a mapped network drive only being accessed by a
named user.
I don't really know what that means because I've checked that the file
is accessible from all of the machines...
Any assistance would be appreciated.
Thank yo