LinuxQuestions.org
LinuxAnswers - the LQ Linux tutorial section.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
Search this Thread
Old 03-13-2013, 06:41 AM   #1
sree.m
Member
 
Registered: Feb 2012
Posts: 56

Rep: Reputation: Disabled
Smile Unable to connect to MS ACCESS(mdb) from Linux


Hi there,

Can anyone suggest a way to access .mdb file from a Redhat linux machine?? I have googled a lot to find a free ODBC driver for linux, but did not help.

Your inputs are most important for making next step.

Regards,
Sree
 
Old 03-13-2013, 07:02 AM   #2
Habitual
Senior Member
 
Registered: Jan 2011
Distribution: Undecided
Posts: 3,577
Blog Entries: 1

Rep: Reputation: Disabled
Quote:
Originally Posted by sree.m View Post
Hi there,
I have googled a lot to find a free ODBC driver for linux, but did not help.
Sree
You need better google.fu

how to use an MS-Access file from Linux? - Stack Overflow
 
Old 03-16-2013, 03:44 AM   #3
sree.m
Member
 
Registered: Feb 2012
Posts: 56

Original Poster
Rep: Reputation: Disabled
Hi,

I have installed OpenOffice Base to connect to MS access Database, but gets the error while browsing for mdb file as shown in the attachment. Please suggest a way forward. I have tried installing several rpm's such as mdbtools,unixodbc,etc. Still getting the same error.

Regards,
Sree
Attached Images
File Type: jpg odbc driver error.jpg (187.4 KB, 15 views)
 
Old 03-16-2013, 10:10 AM   #4
TB0ne
Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 14,996

Rep: Reputation: 2673Reputation: 2673Reputation: 2673Reputation: 2673Reputation: 2673Reputation: 2673Reputation: 2673Reputation: 2673Reputation: 2673Reputation: 2673Reputation: 2673
Quote:
Originally Posted by sree.m View Post
Hi,
I have installed OpenOffice Base to connect to MS access Database, but gets the error while browsing for mdb file as shown in the attachment. Please suggest a way forward. I have tried installing several rpm's such as mdbtools,unixodbc,etc. Still getting the same error.
What version of Red Hat are you using, and where did you get the RPM? And are you using 32 or 64 bit? How did you install those RPM's? the unixODBC file provides that library...so either you didn't get the right library, right architecture, right version, or it didn't install correctly.

That file should be in the Red Hat Network repositories...have you contacted Red Hat, since you're having a problem with the software you subscribe to?
 
1 members found this post helpful.
Old 03-18-2013, 04:56 AM   #5
sree.m
Member
 
Registered: Feb 2012
Posts: 56

Original Poster
Rep: Reputation: Disabled
Smile

Quote:
Originally Posted by TB0ne View Post
What version of Red Hat are you using, and where did you get the RPM? And are you using 32 or 64 bit? How did you install those RPM's? the unixODBC file provides that library...so either you didn't get the right library, right architecture, right version, or it didn't install correctly.

That file should be in the Red Hat Network repositories...have you contacted Red Hat, since you're having a problem with the software you subscribe to?
Redhat Version : Linux cialdxi 2.6.32-279.el6.x86_64 #1 SMP Wed Jun 13 18:24:36 EDT 2012 x86_64 x86_64 x86_64 GNU/Linux

OpenOffice Version : Apache_OpenOffice_incubating_3.4.1_Linux_x86-64_install-rpm_en-US.

Unix ODBC Version : unixODBC-2.2.14-12.el6_3.x86_64

Even though UnixODBC is installed, odbc libraries are not available in /usr/lib. What could be the reason? I hope pkg versions are correct.

Rgrds,
Sree
 
Old 03-18-2013, 09:12 AM   #6
TB0ne
Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 14,996

Rep: Reputation: 2673Reputation: 2673Reputation: 2673Reputation: 2673Reputation: 2673Reputation: 2673Reputation: 2673Reputation: 2673Reputation: 2673Reputation: 2673Reputation: 2673
Quote:
Originally Posted by sree.m View Post

Redhat Version : Linux cialdxi 2.6.32-279.el6.x86_64 #1 SMP Wed Jun 13 18:24:36 EDT 2012 x86_64 x86_64 x86_64 GNU/Linux
OpenOffice Version : Apache_OpenOffice_incubating_3.4.1_Linux_x86-64_install-rpm_en-US.
Unix ODBC Version : unixODBC-2.2.14-12.el6_3.x86_64

Even though UnixODBC is installed, odbc libraries are not available in /usr/lib. What could be the reason? I hope pkg versions are correct.
Ok, so you're using Red Hat Enterprise 6, 64 bit. Again, where did you get the RPM, and how did you install it? Also, have you contacted Red Hat support yet?? This package is in the Red Hat Network repositories, which you are paying for access to, with your RHEL subscription. You should have been able to install it with "yum install unixODBC".

You can also use "yum provides libodbc.so", to tell you the package name you need, and install it with "yum install". Again, since you're using RHEL, this should be a very quick process, since you've got access to the Red Hat Network, and their support.

Last edited by TB0ne; 03-18-2013 at 09:20 AM.
 
1 members found this post helpful.
Old 03-19-2013, 10:53 AM   #7
sree.m
Member
 
Registered: Feb 2012
Posts: 56

Original Poster
Rep: Reputation: Disabled
Quote:
Originally Posted by TB0ne View Post
Ok, so you're using Red Hat Enterprise 6, 64 bit. Again, where did you get the RPM, and how did you install it? Also, have you contacted Red Hat support yet?? This package is in the Red Hat Network repositories, which you are paying for access to, with your RHEL subscription. You should have been able to install it with "yum install unixODBC".

You can also use "yum provides libodbc.so", to tell you the package name you need, and install it with "yum install". Again, since you're using RHEL, this should be a very quick process, since you've got access to the Red Hat Network, and their support.
Hi,

I have got these RPM from Redhat rpm repositories. unixODBC package is getting installed with yum command, but not libodbc.so.

Code:
]# yum provides libodbc.so
Loaded plugins: product-id, refresh-packagekit, rhnplugin, security,
              : subscription-manager
Updating certificate-based repositories.
Unable to read consumer identity
tdodbc-14.00.00.04-1.noarch : Teradata ODBC driver Package
Repo        : installed
Matched from:
Other       : Provides-match: libodbc.so



[root@cialdxi ~]#
[root@cialdxi ~]# yum install libodbc.so
Loaded plugins: product-id, refresh-packagekit, rhnplugin, security,
              : subscription-manager
Updating certificate-based repositories.
Unable to read consumer identity
Setting up Install Process
No package libodbc.so available.
I have opened a Service Request in Redhat Customer portal as well, but no response so far .

Rgrds,
Sreejith
 
Old 03-19-2013, 11:42 AM   #8
TB0ne
Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 14,996

Rep: Reputation: 2673Reputation: 2673Reputation: 2673Reputation: 2673Reputation: 2673Reputation: 2673Reputation: 2673Reputation: 2673Reputation: 2673Reputation: 2673Reputation: 2673
Quote:
Originally Posted by sree.m View Post
Hi,
I have got these RPM from Redhat rpm repositories. unixODBC package is getting installed with yum command, but not libodbc.so.
I doubt you got the RPM's from the Red Hat repositories, since the errors you posted indicate that you don't have access to them, since your system isn't registered/is having problems
Quote:
Code:
]# yum provides libodbc.so
Loaded plugins: product-id, refresh-packagekit, rhnplugin, security,
              : subscription-manager
Updating certificate-based repositories.
Unable to read consumer identity
tdodbc-14.00.00.04-1.noarch : Teradata ODBC driver Package
Repo        : installed
Matched from:
Other       : Provides-match: libodbc.so
Did you read what you posted? The libodbc.so file is provided by the tdodbc file referenced above. Which you can't access, since you're having issues with your Red Hat subscription/registration of your system.
Quote:
[root@cialdxi ~]# yum install libodbc.so
Loaded plugins: product-id, refresh-packagekit, rhnplugin, security,
: subscription-manager
Updating certificate-based repositories.
Unable to read consumer identity
Setting up Install Process
No package libodbc.so available.[/CODE]
You can't install a single file with the command. You use the "provides" directive to find out the PACKAGE name, then install the package that contains the file with install. You can't install it, because you're having problems.
Quote:
I have opened a Service Request in Redhat Customer portal as well, but no response so far .
Then pick up the phone and call them. They can solve the issue while you're on the phone.
 
1 members found this post helpful.
  


Reply

Tags
linux, redhat


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
Linux Open Office and MS Access .mdb files checkmate3001 Linux - Software 4 10-18-2008 08:07 PM
Access (mdb) file reader? logosys Linux - Software 2 08-31-2005 03:33 PM
read/write in *.MDB (MS-Access file) form Linux FC3 thuan1975 Linux - Software 1 08-11-2005 02:25 AM
NFS and MS Access MDB Files ja_nch Linux - Networking 1 09-20-2003 02:53 PM
how to access microsoft mdb in redhat linux 8 kjsubbu Linux - Software 8 06-02-2003 05:26 PM


All times are GMT -5. The time now is 10:48 PM.

Main Menu
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