LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.

Notices



Reply
 
Search this Thread
Old 07-30-2002, 06:44 AM   #1
gokussj
Member
 
Registered: Mar 2002
Location: Italy
Distribution: RedHat7.3
Posts: 49

Rep: Reputation: 15
ODBC Microsoft Access for Linux


Hi all!

In these days i'm writing a java program and i must connect it to a database in the Access format, but i have not found any driver managers for Linux. I have Red Hat 7.3 and i already have installed unixODBC and the KDE utils to make DSN with database, but the only driver present is PostGreSQL.

Any help is appreciated and thanks to anyone.
 
Old 07-30-2002, 08:56 AM   #2
neo77777
LQ Addict
 
Registered: Dec 2001
Location: Brooklyn, NY
Distribution: *NIX
Posts: 3,704

Rep: Reputation: 55
You have to look for JDBC if you want your java program to connect to Access format DB, take a look here http://freshmeat.net/search/?q=jdbc&section=projects you might find something of your interest.
P.S. Also the best place to find more info on JDBC is ... vendor web site http://search.java.sun.com/search/java/?qt=jdbc

Last edited by neo77777; 07-30-2002 at 08:59 AM.
 
Old 07-30-2002, 10:20 AM   #3
gokussj
Member
 
Registered: Mar 2002
Location: Italy
Distribution: RedHat7.3
Posts: 49

Original Poster
Rep: Reputation: 15
Thanks neo, but JDBC is not talking with ODBC? If ODBC driver does not exists how can i create a DSN to a something that is non existent?

Java JDBC to work uses DSN connection to the ODBC of the system operative, right, so if we lack Access driver in ODBC, JDBC cannot work.

For now i think that under Linux i will make a MySQL database.
 
Old 07-30-2002, 10:49 AM   #4
neo77777
LQ Addict
 
Registered: Dec 2001
Location: Brooklyn, NY
Distribution: *NIX
Posts: 3,704

Rep: Reputation: 55
I see your point, take a look here you might find somethjing that suits your needs, unfortunately there are not many free alternatives (free as in beer), but it is worth of checking out http://www.linuxlinks.com/Software/D...ODBC_and_JDBC/
 
Old 07-30-2002, 12:48 PM   #5
gokussj
Member
 
Registered: Mar 2002
Location: Italy
Distribution: RedHat7.3
Posts: 49

Original Poster
Rep: Reputation: 15
Thanks Neo! Today i see in some sites that ODBC Access driver manager for Linux is not free and many sites sells it, so i think it is not possible to find it; for oracle i see an open source, but for Access nope :-(((

Thanks for all the precious links you gave me :-)
 
Old 07-30-2002, 01:58 PM   #6
neo77777
LQ Addict
 
Registered: Dec 2001
Location: Brooklyn, NY
Distribution: *NIX
Posts: 3,704

Rep: Reputation: 55
No, problem, in my company we are running a test webserver on RH7.3+apache+topmcat4 to serve JSP pages, and we are connecting to MS SQL database, let me find out what driver we are using. I'll hit you back tomorrow, I am at home right now.
 
Old 08-01-2002, 05:54 AM   #7
gokussj
Member
 
Registered: Mar 2002
Location: Italy
Distribution: RedHat7.3
Posts: 49

Original Poster
Rep: Reputation: 15
Thumbs up

Thanks neo i don't want that you make a lot of extra work to help me; you are really gentle, but for now i will code under Windows.
If one day you come find a solution thanks, but please don't search it too much.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
MS access ODBC for linux eloviyandhi Programming 3 06-23-2005 01:37 AM
Linux and Microsoft Access Databases j0217995 Linux - General 7 03-04-2004 12:08 PM
access Windows ODBC from Linux PHP Psykoral Linux - Software 2 12-15-2003 08:32 AM
microsoft access migration to linux mannybabe Linux - Software 2 04-07-2003 11:47 PM
ODBC Access and Linux JohnBradshaw Linux - Networking 8 07-18-2002 11:37 AM


All times are GMT -5. The time now is 05:17 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration