[PHP] Help with Linux RPM install (ODBC access)
Hi, I have just installed RedHat 7 with support to PHP4 and MySQL. phpinfo() reports the following at the 'configure command' entry: './configure' '--target=i386-redhat-linux' '--prefix=/usr' '--with-config-file-path=/etc' '--disable-debug' '--enable-pic' '--enable-inline-optimization' '--with-apxs=/usr/sbin/apxs' '--disable-static' '--with-exec-dir=/usr/bin' '--with-regex=system' '--with-gettext' '--with-gd' '--with-jpeg-dir=/usr' '--with-png' '--with-zlib' '--with-db2' '--with-db3' '--with-gdbm' '--enable-debugger' '--enable-magic-quotes' '--enable-safe-mode' '--enable-sysvsem' '--enable-sysvshm' '--enable-track-vars' '--enable-yp' '--enable-ftp' '--without-mysql' '--with-xml' Although it shows option '--without-mysql' at the 'MySQL' section it reports that MySQL is enabled, and indeed we can connect to our MySQL database normally. We need though to have access to MySQL through ODBC and would like to configure PHP to run with 'unixODBC' compiled. I can see that ODBC support is currently not built in, because invoking function odbc_connect() I receive the following message: Fatal error: Call to undefined function: odbc_connect() in /var/www/html/odbc.php on line 6 RedHat reports that the RPM package for unixODBC is installed, but how do I make it to be built with PHP? And why does the compile options show that MySQL support was not built in and in fact it is? Is this because of the way RPMs function? That is, I believe I should really not rebuild PHP with commands './configure', 'make' and 'make install' but instead work with the RPM RedHat system. Any hints for a Linux RedHat newbie? TIA, Paulo
[PHP] PHP compile with ODBC support (iODBC x Openlinkx unixODBC...) and MyODBC
Hi, We are currently configuring PHP4.0.4 with MySQL and Apache. We *need* to access MySQL via ODBC as well. Which is the best thing to do? There are many options of different ODBC drivers that can be configured, like 'iodbc' or 'openlink' from Openlink or unixODBC. Which driver is best? Which has better administration tools? Which has GUI's? Any comments about pros and cons about each one, functionalities available, ease of installation ? When building PHP, I know I should choose among options like (I quote here from memory): --with-iodbc --with-openlink --with-unixODBC --with-customODBC I tried building it with iODBC support, but make failed because of some source header files needed that were missing. About MyODBC: it is just an API and not the proper driver I suppose. We are going to access the Linux server both locally as well as remotely from Windows98 workstations. So I believe we should install MyODBC only on our Windows clients machines and not on the server, right? What about MySQLGUI? Should I install it only at my windows machines or also on the server. Is it somewhat similar to what I have seen about a unixODBC grphical manager for KDE? Any tips would be greatly appreciated, TIA, Paulo