Openlink support broken in PHP4

Anon

Did anybody find that Openlink support does not work in PHP4.01? Compilation error as following:

gcc -DHAVE_CONFIG_H -I. -I/usr/local/install/php-4.0.1/ext/odbc -I/usr/local/install/php-4.0.1 -I/usr/local/in
stall/php-4.0.1/main -I/usr/local/install/php-4.0.1/Zend -I/usr/local/install/php-4.0.1 -I/usr/local/include/m
ysql -I/usr/local/openlink/odbcsdk/include -I/usr/local/install/php-4.0.1/ext/xml/expat/xmltok -I/usr/local/in
stall/php-4.0.1/ext/xml/expat/xmlparse -DXML_BYTE_ORDER=12 -g -O2 -c php_odbc.c && touch php_odbc.lo
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
make[3]: Leaving directory /usr/local/install/php-4.0.1/ext/odbc' make[2]: *** [all-recursive] Error 1 make[2]: Leaving directory/usr/local/install/php-4.0.1/ext/odbc'
make[1]: [all-recursive] Error 1
make[1]: Leaving directory `/usr/local/install/php-4.0.1/ext'
make: *** [all-recursive] Error 1

Anon

Silen,

I'm interested if you ever found a solution to this error. I am having the exact same problem on a SuSE Linux box, trying to make PHP 4.0.1pl2 with support for OpenLink.

Any help from anyone about this would be appreciated.

Anon

I've post a message in PHP.net's bug database and they have analysised and assigned to some guy named Zeev. I think it should be resolved already or in near future.

There is a temp workaround:

search for "SQLINTEGER len;" string in /ext/odbc/php_odbc.c file in php4 source directory and replace it with "SDWORD len;"

happy with your compiling!

silen

Anon

Hi,

Are u sure what you're saying works? I mean I tried it. The installation process worked out well but when I tested it with php with just a simple program it gave me this error:

SQL error: [OpenLink][ODBC][Driver]General error, SQL state S1000 in SQLExecDirect

Breughel

Anon

HI:

Ya, That really works! At least for php 4.0.1. Are you sure you have following the instruction of my mini-howto at:
http://www.silen.net/openlink-php-odbc.txt
?

You have to put .odbc.ini (installed in the process of openlink installation) under the home directory of the user who need to use openlink-php. and don't forget to edit your /etc/udbc.ini to add data source. You can test openlink connectivity like this (run php like normal binary):

$ php
<?
echo $conn_id = odbc_connect("dsn=THE_DSN_NAME_SET_IN_YOUR_UDBC_INI",
"YOUR_DB_USER_NAME","YOUR_DB_USER_PASSWORD");
^D( press ctrl+D )
( wait for a while to connect, then ...)
Content-type: text/html

Resource id #1

$ _

If you compile php4 with apache, keep in mind which user role your apache is run under. Normally, that is "nobody", in Linux, the home of nobody user is usually "/", so you got to put a .odbc.ini under "/"...

regards,
Silen

Anon

Hello,

I looked at your mini-HOWTO and its very similar to the steps that I took. I have already sucessfully installed openlink, php3 and apache for more than 5 times.

I just can't use php4.0.1 because it won't compile with pdflib3.02. Anyway, I checked for bug reports and its already been reported.

I'll just wait for updates. Thanx for responding anyway.

Breughel