Re: Java access to Microsoft Access database through Samba


JC wrote:
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!

I have never tried it, but AFAIK, you would need ODBC drivers on linux,
as that is the origin of your JVM. MS Access is not a database server,
so you would have to access it either on the host on which it resides,
or through a mapped drive (such as Samba)...but either way, you would
need ODBC drivers.

DataDirect provides these for *nix, but they are $$$.

Regards,

Steve

.

Relevant Pages

  • Re: [PHP] Mysql Insert/Update Problem
    ... > that will open a dbx file extract records from the dbf file ... > then it will update the mysql database on the linux server. ...
    (php.general)
  • Re: PWS - Adding a Db to my website
    ... not trying to host a web site. ... I have a web page hosted on a linux server. ... requires that I use PHP and mySql to create a database. ... > If you wish to use features available on IIS servers, ...
    (microsoft.public.frontpage.client)
  • Re: Limiting OS resources on Linux on per process basis
    ... of databases on a linux server, is there a way to guarantee that each ... available CPU resources. ... database is busy, do you really want the CPU to limit it to 20%? ... for resources rather than as individual processes. ...
    (comp.os.linux.networking)
  • Re: PWS - Adding a Db to my website
    ... > You don't publish to local host, you open the FP web at localhost and create / run your ASP pages and DB there ... The linux server I am hosted on ... > | requires that I use PHP and mySql to create a database. ...
    (microsoft.public.frontpage.client)
  • Re: Server issue?
    ... windows server unlike lik on a LINUx server. ... Are you saying PHP is not stable on LAMP? ... I doubt installing it on Windows will improve your situation. ...
    (comp.lang.php)