RE: [PHP-DB] how do I connect to MSSQL2000 and mySQL with PHP4 and Linux?

> The Quick and Dirty instructions are > > 1. download the iODBC sdk from www.iodbc.org, can you give me the EXACT URL's for EVERYTHING I need to download and install re: ODBC I have RedHat 6.2, (so glibc2) > 2. add --with-iodbc=/path/to/iodbc in to your configure I'm having difficulties with that line. ./configure --with-openlink=/path/to/openlink/ --with-iodbc=/path/to/iodbc/ what exactly is /path/to/openlink and /path/to/iodbc? is it the .h file? is it the .so files? is it the .a files? I've tried several combinations and nothing is working. What's worse is that PHP4 just happily 'skips' that and compiles anyways. UGH! I wish it would blow up there and stop so I'd know. You have to 'catch' it as it zips on by to know that the path is incorrect. ./WTConfigure: --with-iodbc=/usr/src/WT_Apache_Setup/libiodbc-2.50.3: No such file or directory or ./WTConfigure: --with-iodbc=/usr/local: No such file or directory or ./WTConfigure: --with-iodbc=/usr/local/lib: No such file or directory I have "stuff" here: [root=pts/2]8:39pm@content:{/usr/src/WT_Apache_Setup/php}> l /usr/local/lib total 696 -rw-r--r-- 1 root root 182076 Jan 8 21:01 libgd.a -rw-r--r-- 1 root root 349772 Mar 29 20:30 libiodbc.a -rwxr-xr-x 1 root root 569 Mar 29 20:30 libiodbc.la* lrwxrwxrwx 1 root root 18 Mar 29 20:30 libiodbc.so -> libiodbc.so.2.0.50* lrwxrwxrwx 1 root root 18 Mar 29 20:30 libiodbc.so.2 -> libiodbc.so.2.0.50* -rwxr-xr-x 1 root root 148391 Mar 29 20:30 libiodbc.so.2.0.50* lrwxrwxrwx 1 root root 14 Nov 7 13:43 mysql -> /usr/lib/mysql/ drwxr-xr-x 15 root root 4096 Mar 29 20:09 php/ lrwxrwxrwx 1 root root 12 Jan 5 22:36 php.ini -> /etc/php.ini lrwxrwxrwx 1 root root 13 Nov 7 13:43 php3.ini -> /etc/php3.ini drwxr-xr-x 2 root root 4096 Jan 25 19:39 zend/ All the source from the tarball is in "/usr/src/WT_Apache_Setup/libiodbc-2.50.3" This libiodbc thing seemed to install correctly? it didn't do anything fancy, and there didn't seem to be any thing interesting going on with the "make check" I've tried the RPMs too. I also have this: [root=pts/2]8:50pm@content:{/usr/src/WT_Apache_Setup/php}> l /usr/local/openlink total 244 drwxrwxr-x 2 nobody html 4096 Mar 29 20:19 bin/ -rwxr-xr-x 1 nobody html 16137 Mar 29 17:54 install.sh* -rw-r--r-- 1 nobody html 196347 Mar 29 17:54 l2oczzzz.taz drwxrwxr-x 2 nobody html 4096 Mar 29 17:55 lib/ -rw------- 1 nobody html 483 Mar 29 20:21 odbc.ini -rw------- 1 nobody html 180 Mar 29 20:21 odbcinst.ini -rwxr-xr-x 1 nobody html 895 Mar 29 17:55 openlink.csh* -rwxr-xr-x 1 nobody html 983 Mar 29 17:55 openlink.sh* -rw------- 1 nobody html 0 Mar 29 20:20 oplrqb.ini [root=pts/2]8:51pm@content:{/usr/src/WT_Apache_Setup/php}> l /usr/local/openlink/lib total 400 -rwxr-xr-x 1 nobody html 669 Mar 7 14:43 libiodbc.la* lrwxrwxrwx 1 nobody html 17 Mar 29 20:05 libiodbc.so -> libiodbc.so.2.1.2* lrwxrwxrwx 1 nobody html 17 Mar 29 20:05 libiodbc.so.2 -> libiodbc.so.2.1.2* -rwxr-xr-x 1 nobody html 117877 Mar 7 14:43 libiodbc.so.2.1.2* lrwxrwxrwx 1 nobody html 17 Mar 29 20:05 libodbc.so -> libiodbc.so.2.1.2* -rw-r--r-- 1 nobody html 678 Mar 7 14:43 oplodbc.la lrwxrwxrwx 1 nobody html 16 Mar 29 20:05 oplodbc.so -> oplodbc.so.1.0.0 lrwxrwxrwx 1 nobody html 16 Mar 29 20:05 oplodbc.so.1 -> oplodbc.so.1.0.0 -rw-r--r-- 1 nobody html 272057 Mar 7 14:43 oplodbc.so.1.0.0