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 / General / June 2006

Tip: Looking for answers? Try searching our database.

Java access to Microsoft Access database through Samba

Thread view: 
JC - 18 Jun 2006 12:45 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!
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


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.