Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsWhite Papers
Discussion GroupsFirst AidDatabasesJavaBeansGUIJava 3DVirtual MachineCORBASecurityToolsGeneral
Java DirectoryOpen Source ProjectsSample Book ChaptersUser GroupsWeb Resources
Related Topics
Databases.NETMore Topics ...

Java Forum / Databases / June 2006

Tip: Looking for answers? Try searching our database.

Java access to Microsoft Access database through Samba

Thread view: 
JC - 16 Jun 2006 19:14 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
(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!
stevedhoward@gmail.com - 21 Jun 2006 21:06 GMT
> Hi,
>
[quoted text clipped - 12 lines]
>
> 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


Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.