LinuxQuestions.org
Register a domain and help support LQ
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 01-18-2005, 08:06 PM   #1
mabus92920
Member
 
Registered: Jan 2005
Posts: 48

Rep: Reputation: 15
ODBC drivers


I need some help on ODBC drivers. The thing is I am running on redhat 9, and I also run crossover office and wine in it to run windows applications such as Microsoft Access or Excel.

I made an applicaion, using JAVA, that connects to a MsAccess database, and a MSExcel worksheet using ODBC. I used windows XP to run that, but I want it to run on linux. There's no problem running the app since its made in JAVA.

So how do I connect to excel and access using linux????


can anyone help? thanks in advance..
 
Old 01-18-2005, 08:33 PM   #2
jerm1701
Member
 
Registered: Nov 2004
Location: Wisconsin
Distribution: Mandriva 2007
Posts: 94

Rep: Reputation: 15
I have no idea about ODBC, but you may want to try JDBC, the Java version.

Good luck!
Jeremy
 
Old 01-22-2005, 03:15 PM   #3
cswor
Member
 
Registered: Apr 2004
Location: TN
Distribution: Only used RH but have heard good things about Mandrake. BSD might be interesting.
Posts: 46

Rep: Reputation: 15
i dnn't have first hand experience with this, but:

fedora core 3 ships with unixODBC. you can check your install with "rpm -q unixODBC". you will need this. beyond that, you can go to http://www.unixODBC.org to get more info. google will also turn up info.

for java apps, why not switch over to JDBC. i assume (don't know for sure) that there is a JDBC driver for msaccess.
 
Old 01-23-2005, 03:58 AM   #4
mabus92920
Member
 
Registered: Jan 2005
Posts: 48

Original Poster
Rep: Reputation: 15
yes, there is. but if I'll use JDBC for access, then I will have to change my connection strings, which means modifying m y program again. is there any other way ? would it be possible to run it under wine ?
 
  


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 Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Using ODBC to MS SQL ejennings_98 Linux - Software 7 08-05-2005 01:10 PM
MS access ODBC for linux eloviyandhi Programming 3 06-23-2005 01:37 AM
ODBC sql.h question javakid Programming 0 11-16-2004 09:34 AM
Linux Odbc munna_502 Linux - Software 1 03-30-2004 04:03 PM
odbc connection jstu Linux - General 1 11-12-2002 11:01 AM


All times are GMT -5. The time now is 04:58 PM.

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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration