RE: [PHP-DB] Install PHP with custom ODBC
Hi WC, There is a HOWTO at www.iodbc.org/odbc-phpHOWTO.html If you have problems, free support is available at http://www.openlinksw.com/support/suppindx.htm Best regards, Andrew Andrew Hill Director Technology Evangelism OpenLink Software http://www.openlinksw.com XML & E-Business Infrastructure Technology Provider > -Original Message- > From: WC Ip [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 30, 2001 4:15 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Install PHP with custom ODBC > > > > > Thanks for reading my question! I would like to install PHP on Linux to > connect MS SQL server in another computer (Win NT). I have > install the ODBC > Client Components on Linux and OpenLink Generic 32 bit driver on Win NT. > After configurating, the connect test is successful. So I try to start to > install PHP, but when making, it seems that PHP cannot found the ODBC > driver. Acutally I have install ODBC Client Components on "/usr/local". > > When I install PHP... I have typed... > > ./configure --with-custom-odbc=/usr/local --with-apache=../apache_1.3.12 > --enable-track-vars > > Then when making, it prompt that odbc.h cannot be found! > Do I do anything wrong? Thanks for your help!!! > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Install PHP with custom ODBC
1. Instead of customodbc, you should use --with-openlink=/usr/local/openlink/ 2 .Are you sure it asks that odbc.h can't be found ? Or is it that you recieve this error: php_odbc.c: In function `odbc_column_lengths': php_odbc.c:606: `SQLINTEGER' undeclared (first use in this function) php_odbc.c:606: (Each undeclared identifier is reported only once php_odbc.c:606: for each function it appears in.) php_odbc.c:606: parse error before `len' php_odbc.c:634: `len' undeclared (first use in this function) make[3]: *** [php_odbc.lo] Error 1 To fix it, change line 606 : "SQLINTEGER len;" should be replaced by "SDWORD len;" 3. You are using MS SQL. Why not use the MS SQL functions "built in" to PHP ? They are ALOT faster, more reliable etc than ODBC functions. Plus, a VERY useful functoin, mssql_num_rows function works, whereas odbc_num_rows() does not. See http://php.net/mssql Siggy - Original Message - From: "WC Ip" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, January 30, 2001 10:15 PM Subject: [PHP-DB] Install PHP with custom ODBC > > > Thanks for reading my question! I would like to install PHP on Linux to > connect MS SQL server in another computer (Win NT). I have install the ODBC > Client Components on Linux and OpenLink Generic 32 bit driver on Win NT. > After configurating, the connect test is successful. So I try to start to > install PHP, but when making, it seems that PHP cannot found the ODBC > driver. Acutally I have install ODBC Client Components on "/usr/local". > > When I install PHP... I have typed... > > ./configure --with-custom-odbc=/usr/local --with-apache=../apache_1.3.12 > --enable-track-vars > > Then when making, it prompt that odbc.h cannot be found! > Do I do anything wrong? Thanks for your help!!! > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Install PHP with custom ODBC
Thanks for reading my question! I would like to install PHP on Linux to connect MS SQL server in another computer (Win NT). I have install the ODBC Client Components on Linux and OpenLink Generic 32 bit driver on Win NT. After configurating, the connect test is successful. So I try to start to install PHP, but when making, it seems that PHP cannot found the ODBC driver. Acutally I have install ODBC Client Components on "/usr/local". When I install PHP... I have typed... ./configure --with-custom-odbc=/usr/local --with-apache=../apache_1.3.12 --enable-track-vars Then when making, it prompt that odbc.h cannot be found! Do I do anything wrong? Thanks for your help!!! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]