cannot connect to PHP/ODBC

[Jokull]

I am using Mandrake 9.1 with Xampp 1.66 installed on my computer. I also installed UnixODBC and the MYsql connector to connect to the system. I can successfully connect to Mysql test database using the command isql –v. Using PHP script such as mysql_connect I can connect to Mysql. I have recently installed the PHP ODBC extension from the php5-odbc-5.0.2-1mdk.i586.rpm. Now the php will not able to run the line odbc_connect() an any script. It just displays the error log.

[Ransom]

I think the main reason you are getting this issue because the odbc extension you have installed is not supported by the current php5 version. Check manually that whether the extension odbc.so is installed on “/usr/lib/php5/extensions/” this location or not. The php.ini expects you to put the link to it in opt/lampp/lib/php/extensions/non-debug-non-zts-20060613/ and a line extension=odbc.so in php.ini. After linking try to run the same command, it will definitely work I think.

[Radames]

I searched many times over the net using Google search. At last I found the 2 php5-odbc packages which hare specifically for Mandriva in this link .The packages versions are
php-odbc-5.2.5-13mdv2008.1.i586.rpm
php-odbc-5.2.5-14.7mdv2008.1.i586.rpm
These are really made for your php version and definitely going to suit it and I hope that it will going to fit the php installation also.

[Appaji]

mysql_connect command or script needs several parameters to connect Mysql to the server. The parameters are

• Server -It includes port number and also the Mysql server. Ex. Hostname:port and for PHP script mysql.default_host is set by deafualt
• Username- the value if defined by mysql.default_user. It is the default value.
• Password- mysql.default_password
• New link
• Client flags