[SOLVED] ODBC extension not working anymore

tomkin · 04-29-2013, 06:26 AM

Hello,

I am quite a newby in Linux. I tried to install unixODBC and FreeTDS and suddenly there was no ODCB info shown anymore in the phpinfo. But in the "Additional .ini files parsed" section I still see /etc/php5/conf.d/odbc.ini and /etc/php5/conf.d/pdo_odbc.ini

In Apache's error log I found this:

Quote:

PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib64/php5/extensions/odbc.so' - libodbc.so.1: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib64/php5/extensions/pdo_odbc.so' - libodbc.so.1: cannot open shared object file: No such file or directory in Unknown on line 0

Yesterday I had problems with unixODBC libraries which could not be found. After I did ldconfig -p and ldconfig -v these worked again. Maybe this caused this new error?

Can anybody give me a hint, how I could fix this issue?

Adickel · 04-30-2013, 10:46 PM

Check the permissions on that file as well as make sure any logical that need to be setup are in place. Make sure the ODBC user has access to it, also what distro are you running?

tomkin · 05-08-2013, 08:10 PM

Problem solved.

libodbc.so.1 was missing. I deleted the old version of unixODBC where libodbc.so.1 was used. Now it's libodbc.so.2. Somewhere there was still a reference to libodbc.so.1. So I made a symbolic link named libodbc.so.1 to libodbc.so

Thanks for your help!

tix · 07-27-2021, 09:01 AM

2021 - BACK TO THE FUTURE:
---------------------------

I know that this post is old, but my reply can point a desperate soul in the right direction:

1) You are using odbc and the command "isql" works just fine
2) You are using FreeTDS and the command "tsql" works just fine
3) Trouble is running the php scripts that have calls to odbc via FreeTDS -> keeps giving errors

Kindly read:
https://www.linuxquestions.org/quest...-5-13-5-38621/

Cheers happy souls!

Powered By Slackware Linux!!!