Connect to a MS Access database with XAMPP 1.7.1 for Linux

Problems with the Linux version of XAMPP, questions, comments, and anything related.

Connect to a MS Access database with XAMPP 1.7.1 for Linux

Postby nunonuno » 19. June 2009 19:35

Hello All,

I'm trying to connect form PHP to a MS Access database file in a Linux directory, but I get the error "Fatal error: Call to undefined function odbc_connect() in ..." .

The distribution I'm using is Ubuntu 9.04.

I'm using unixODBC and I can connect to the database with "iqsl DNS", on the shell. I have installed mdbtools too.
It seems that PHP does not recognise the function odbc_connect(), but in php.ini there is a line "extension="dbx.so".
I think it should support ODBC, since when I run phpinfo() I get "supported databases MySQL ODBC PostgreSQL Microsoft SQL Server FrontBase Oracle 8 (oci8) Sybase-CT SQLite " for dbx that is enabled.


Is there anybody that knows how to solve this problem?


Thank you.
nunonuno
 
Posts: 1
Joined: 19. June 2009 13:51

Re: Connect to a MS Access database with XAMPP 1.7.1 for Linux

Postby caltuna » 21. June 2009 16:13

http://nixcraft.com/databases-servers/1 ... erver.html

or
http://www.google.com/#hl=en&num=50&q=p ... OcDI-RcCQo

Bottom line, Access is designed to run under the Windows OS, not Linux. I suggest you convert your Access to MySQL. There are a number of utilities out there that will do that for you.

Al
http://www.insol123.com
caltuna
 
Posts: 111
Joined: 05. May 2009 16:35


Return to XAMPP for Linux

Who is online

Users browsing this forum: No registered users and 4 guests