[PHP-DEV] PHP 4.0 Bug #7316 Updated: OpenLink/IODBC error From: kalowsky <email protected>
Date: 12/28/00

ID: 7316
Updated by: kalowsky
Reported By: joe <email protected>
Old-Status: Open
Status: Analyzed
Bug Type: ODBC related
Assigned To:
Comments:

please try this with the latest CVS version. You have experiences the SQLINTEGER vs SDWORD problem on your last configure example. This is the same as bug #5526.

The other options I'm not sure about at this time. Sorry.

Previous Comments:
---------------------------------------------------------------------------

[2000-10-18 15:21:28] joe <email protected>
I'm having problems with using openlinks drivers with 4.0.3pl1(everything worked fine in 4.0.1pl2)

I'm now receiving Warning: SQL error: [OpenLink][ODBC][Driver]General error, SQL state S1000 in SQLPrepare in /home/joe/public_html/grant/test.php on line 9 and possibly others, if the prepare would work.

Here's the code sample:
$conn=odbc_connect($db, $user,$pass);

$q="select * From tblAlbums";
$stmt = odbc_prepare($conn, $q ); //this is where it's dies

Configure line (stolen from working 4.0.1pl2)
./configure --with-apxs=/usr/local/apache/bin/apxs --with-openlink=/usr/local/openlink --with-iodbc=/usr/local/iodbc --with-mysql --enable-EAPI=yes

I know about not using --with-openlink and --with-iodbc and have also tried these configure options(none of which worked):
./configure --with-apxs=/usr/local/apache/bin/apxs --with-iodbc=/usr/local/iodbc --with-mysql -enable-EAPI=yes

./configure --with-apxs=/usr/local/apache/bin/apxs --with-openlink --with-mysql -enable-EAPI=yes

./configure --with-apxs=/usr/local/apache/bin/apxs --with-iodbc --with-mysql -enable-EAPI=yes

./configure --with-apxs=/usr/local/apache/bin/apxs --with-openlink=/usr/local/openlink --with-mysql -enable-EAPI=yes
The last option dies during compile:

make[3]: Entering directory `/usr/local/src/php-4.0.3pl1/ext/odbc'
/bin/sh /usr/local/src/php-4.0.3pl1/libtool --silent --mode=compile gcc -I. -I/usr/local/src/php-4.0.3pl1/ext/odbc -I/usr/local/src/php-4.0.3pl1 -I/usr/local/src/php-4.0.3pl1/main -I/usr/local/apache/include -I/usr/local/src/php-4.0.3pl1/Zend -I/usr/local/src/php-4.0.3pl1 -I/usr/local/src/php-4.0.3pl1/ext/mysql/libmysql -I/usr/local/openlink/odbcsdk/include -I/usr/local/src/php-4.0.3pl1/ext/xml/expat/xmltok -I/usr/local/src/php-4.0.3pl1/ext/xml/expat/xmlparse -I/usr/local/src/php-4.0.3pl1/TSRM -DEAPI -DXML_BYTE_ORDER=12 -g -O2 -c php_odbc.c
make[3]: Leaving directory `/usr/local/src/php-4.0.3pl1/ext/odbc'
make[2]: Leaving directory `/usr/local/src/php-4.0.3pl1/ext/odbc'
make[1]: Leaving directory `/usr/local/src/php-4.0.3pl1/ext'
php_odbc.c: In function `odbc_column_lengths':
php_odbc.c:619: `SQLINTEGER' undeclared (first use in this function)
php_odbc.c:619: (Each undeclared identifier is reported only once
php_odbc.c:619: for each function it appears in.)
php_odbc.c:619: parse error before `len'
php_odbc.c:648: `len' undeclared (first use in this function)
make[3]: *** [php_odbc.lo] Error 1
make[2]: *** [all-recursive] Error 1
make[1]: *** [all-recursive] Error 1
make: *** [all-recursive] Error 1

---------------------------------------------------------------------------

Full Bug description available at: http://bugs.php.net/?id=7316 

-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: php-dev-unsubscribe <email protected>
For additional commands, e-mail: php-dev-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>