RE: [PHP] Help with Linux RPM install (ODBC access)

Paulo, My advice is to forgo RPMs and build the darn thing by hand. It's really quite easy - check out the Unix install instructions here: http://www.php.net/manual/en/install.unix.php I don't have specific UnixODBC docs, but iODBC should enable you to use any ODBC driver with it (iODBC is a driver manager, and makes PHP ODBC-aware, so you just pass in an ODBCINI envrionment variable pointing to your odbc.ini DSN file like: putenv("ODBCINI=path/to/odbc.ini"); Your odbc.ini will contain your DSNs You will prob also want to pass in env variables for LD_LIBRARY_PATH and ODBCINSTINI. A HOWTO on iODBC is here: http://www.iodbc.org/odbc-phpHOWTO.html Let me know if you run into trouble. Best regards, Andrew ---------------------------------------------------- Andrew Hill Director Technology Evangelism OpenLink Software http://www.openlinksw.com XML & E-Business Infrastructure Technology Provider > -----Original Message----- > From: Paulo Parola (PHP) [mailto:php@brazilinfo.com] > Sent: Tuesday, February 06, 2001 6:04 AM > To: php-general@lists.php.net > Subject: [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 > > >