Access is a microsoft product which can be accessed by JDBC if you use ODBC
(another microsoft product)
Therefore Access is designed to be used in a microsoft environment.
The linux community is not really fond of microsoft, and there just might
not be a JDBC driver. I don't know actually. What I know is that access is
not a database server, it doesn't listen on a port waiting for a client to
connect like Oracle or mySQL.
ODBC allows this, it listens for connections and fetches data from the
access file and sends them to the client.
I doubt that there is a JDBC driver for access in linux, because JDBC opens
a connection on a server... There is no Access server/ODBC on linux. MS
Access is just not a server.
What I would do is this :
Setup 2 machines, one linux, one NT.
The NT server has an ODBC link on your access file.
The linux server has your servlet running
The servlet queries your NT server for MS Access data trought jdbdc:odbdc,
and sends it to your oracle server via the JDBC thin client. The Oracle
server can either be on the NT machine or the Linux machine. (I'd put it on
the NT machine, the linux machine is already running a servlet engine, and I
personnally like to separate web servers and database servers, but that's up
to you, some will say oracle runs better on linux)
Well, to make it short, there's probably no way to fetch data from an access
DB using JDBC on linux, look for an alternative.
Am I making sense or confusing you ?
Best regards, AD
=================================================
The alternative side of the web http://www.twomadcows.com
L'alternatif du web http://www.twomadcows.com
----- Original Message -----
From: "Deo Prakash" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 07, 2000 1:02 PM
Subject: Using Access DB in Linux server......
> Hi,
> I am unable to find any JDBC driver for Access DB.
> Actually I have a servlet which is connecting to an Access DB and fetching
> records from that DB.
> It is then inserting those record in a seperate oracle DB.
> If I am running this with web server on NT, there is no problems.
> but I am unable to run it on Linux.
> The reason I could figure out is that I dont have appropriate driver for
> Access DB on Linux.
> Can any one help me????
> bye
> Deo
>
>
___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
