Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > Java > Java access to Microsoft Access database through Samba

Reply
Thread Tools

Java access to Microsoft Access database through Samba

 
 
JC
Guest
Posts: n/a
 
      06-18-2006
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!

 
Reply With Quote
 
 
 
 
Tim Van Wassenhove
Guest
Posts: n/a
 
      06-18-2006
On 2006-06-18, JC <(E-Mail Removed)> wrote:
> 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
>
> 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.


With smbmount you can mount the network share as if it's part of your
'regular/local' filesystem...

--
Met vriendelijke groeten,
Tim Van Wassenhove <http://timvw.madoka.be>
 
Reply With Quote
 
 
 
 
Martin Gregorie
Guest
Posts: n/a
 
      06-18-2006
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...)
>

Use a JDBC driver (assuming there is one) to access it via SQL.


--
martin@ | Martin Gregorie
gregorie. | Essex, UK
org |
 
Reply With Quote
 
=?ISO-8859-2?Q?Dra=BEen_Gemi=E6?=
Guest
Posts: n/a
 
      06-18-2006
Martin Gregorie wrote:
> 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
>>


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
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
microsoft.public.certification, microsoft.public.cert.exam.mcsa, microsoft.public.cert.exam.mcad, microsoft.public.cert.exam.mcse, microsoft.public.cert.exam.mcsd loyola MCSE 4 11-15-2006 02:40 AM
microsoft.public.certification, microsoft.public.cert.exam.mcsa, microsoft.public.cert.exam.mcad, microsoft.public.cert.exam.mcse, microsoft.public.cert.exam.mcsd loyola Microsoft Certification 3 11-14-2006 05:18 PM
microsoft.public.certification, microsoft.public.cert.exam.mcsa, microsoft.public.cert.exam.mcad, microsoft.public.cert.exam.mcse, microsoft.public.cert.exam.mcsd loyola MCSD 3 11-14-2006 05:18 PM
microsoft.public.certification, microsoft.public.cert.exam.mcsa, microsoft.public.cert.exam.mcad, microsoft.public.cert.exam.mcse, microsoft.public.cert.exam.mcsd realexxams@yahoo.com Microsoft Certification 0 05-10-2006 02:35 PM
microsoft.public.dotnet.faqs,microsoft.public.dotnet.framework,microsoft.public.dotnet.framework.windowsforms,microsoft.public.dotnet.general,microsoft.public.dotnet.languages.vb Charles A. Lackman ASP .Net 1 12-08-2004 07:08 PM



Advertisments