LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (http://www.linuxquestions.org/questions/linux-software-2/)
-   -   Unable to connect to MS ACCESS(mdb) from Linux (http://www.linuxquestions.org/questions/linux-software-2/unable-to-connect-to-ms-access-mdb-from-linux-4175453889/)

sree.m 03-13-2013 05:41 AM

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

Habitual 03-13-2013 06:02 AM

Quote:

Originally Posted by sree.m (Post 4910618)
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

sree.m 03-16-2013 02:44 AM

1 Attachment(s)
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

TB0ne 03-16-2013 09:10 AM

Quote:

Originally Posted by sree.m (Post 4912714)
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?

sree.m 03-18-2013 03:56 AM

Quote:

Originally Posted by TB0ne (Post 4912860)
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

TB0ne 03-18-2013 08:12 AM

Quote:

Originally Posted by sree.m (Post 4913712)

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.

sree.m 03-19-2013 09:53 AM

Quote:

Originally Posted by TB0ne (Post 4913841)
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

TB0ne 03-19-2013 10:42 AM

Quote:

Originally Posted by sree.m (Post 4914535)
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.


All times are GMT -5. The time now is 12:50 AM.