Hi,
I need to access from an JSP application in a Linux server to a
Microsoft Access database (only read) that is in another Windows server
(only accepts users in its domain, that are different from Linux server
users)
I have configured Samba so that I can access to the database file. When
I access through the folder navigator of Linux it requests me user,
domain and password and access without problems.
I do not know, how to access from a Java/JSP application, it's possible
to do it? what driver I must use? it is necessary to configure Samaba
to have permission some user in particular (tomcat, apache...)
Thanks!
Tim Van Wassenhove - 18 Jun 2006 15:04 GMT
> I need to access from an JSP application in a Linux server to a
> Microsoft Access database (only read) that is in another Windows server
Have a look at unixodbc
> (only accepts users in its domain, that are different from Linux server
>
[quoted text clipped - 3 lines]
> I access through the folder navigator of Linux it requests me user,
> domain and password and access without problems.
With smbmount you can mount the network share as if it's part of your
'regular/local' filesystem...

Signature
Met vriendelijke groeten,
Tim Van Wassenhove <http://timvw.madoka.be>
Martin Gregorie - 18 Jun 2006 15:51 GMT
> Hi,
>
[quoted text clipped - 14 lines]
> to do it? what driver I must use? it is necessary to configure Samaba
> to have permission some user in particular (tomcat, apache...)
Use a JDBC driver (assuming there is one) to access it via SQL.

Signature
martin@ | Martin Gregorie
gregorie. | Essex, UK
org |
Dražen Gemić - 19 Jun 2006 00:41 GMT
>> Hi,
>>
>> I need to access from an JSP application in a Linux server to a
>> Microsoft Access database (only read) that is in another Windows server
This is what you need:
http://mdbtools.sourceforge.net/
Check the FAQ. The UnixODBC driver is included, so
you can probably use JDBC-ODBC bridge.
DG