[PHP-DEV] PHP 4.0 Bug #9044 Updated: Compiling with latest Openlink ODBC fails with PHP4

2001-02-03 Thread antiphobo 

ID: 9044
User Update by: [EMAIL PROTECTED]
Status: Open
Bug Type: Compile Failure
Description: Compiling with latest Openlink ODBC fails with PHP4

Allegedly PHP404sp1 fixes this Openlink problem ... but see bug id 
http://bugs.php.net/?id=9088edit=1 for why i couldnt get PHP404sp1 to work with 
apache :(

Previous Comments:
---

[2001-02-01 17:44:06] [EMAIL PROTECTED]
Compiling Openlink4 with PHP 403sp1 and Apache 1.3.12 using the custom iodbc.h file I 
have included WORKS "FINE":

as in 
 - it compiles without errors
 - has warning: `SQL_LEN_DATA_AT_EXEC' redefined
 - produces a fully PHP-functional apache webserver

I still cannot manage to properly communicate to talbles using Openlink4, however, I 
recieve:

SQL error: [OpenLink][ODBC][Driver]Syntax error or access, SQL state 37000 in 
SQLExecDirect for complex selects such as "SELECT TOP 10 RECORD_NR, StatusField, 
ExtendedStatusField, PICTURE, SURNAME, FIRSTNAME, FORM, DOB, DESTINATION, EXPIRY FROM 
(SELECT TOP 10 * FROM WELLGIRLS ORDER BY RECORD_NR ASC,RECORD_NR ASC) ORDER BY 
RECORD_NR DESC,RECORD_NR DESC"

and for simple selects "SELECT * FROM TABLENAME", i get 

Warning: SQL error: [OpenLink][ODBC][Driver]Driver not capable, SQL state S1C00 in 
SQLExecDirect in /home/sites/home/web/current/Admin/admin_odbcsetup.php on line 125

The battle continues ... 

- Siggy

---

[2001-02-01 16:16:49] [EMAIL PROTECTED]
Modified Openlink3.2 iodbc.h so that it could be used with openlink4:

contents of /usr/local/openlink/odbcsdk/include/iodbc.h now:
##

#ifndef _CONFIG_H
#define _CONFIG_H

# if!defined(WINDOWS)  !defined(WIN32_SYSTEM)
#  define   _UNIX_

#  include  stdlib.h
#  include  sys/types.h

#  define   MEM_ALLOC(size) (malloc((size_t)(size)))
#  define   MEM_FREE(ptr)   {if(ptr) free(ptr);}

#  define   STRCPY(t, s)(strcpy((char*)(t), (char*)(s)))
#  define   STRNCPY(t,s,n)  (strncpy((char*)(t), (char*)(s), (size_t)(n)))
#  define   STRCAT(t, s)(strcat((char*)(t), (char*)(s)))
#  define   STRNCAT(t,s,n)  (strncat((char*)(t), (char*)(s), (size_t)(n)))
#  define   STREQ(a, b) (strcmp((char*)(a), (char*)(b)) == 0)
#  define   STRLEN(str) ((str)? strlen((char*)(str)):0)

#  define   EXPORT
#  define   CALLBACK
#  define   FAR


# endif /* _UNIX_ */

# ifdefined(WINDOWS) || defined(WIN32_SYSTEM)

#  include  windows.h
#  include  windowsx.h

#  ifdef_MSVC_
#   define  MEM_ALLOC(size) (fmalloc((size_t)(size)))
#   define  MEM_FREE(ptr)   ((ptr)? ffree((PTR)(ptr)):0))
#   define  STRCPY(t, s)(fstrcpy((char FAR*)(t), (char FAR*)(s)))
#   define  STRNCPY(t,s,n)  (fstrncpy((char FAR*)(t), (char FAR*)(s), 
(size_t)(n)))
#   define  STRLEN(str) ((str)? fstrlen((char FAR*)(str)):0)
#   define  STREQ(a, b) (fstrcmp((char FAR*)(a), (char FAR*)(b) == 0)
#  endif

#  ifdef_BORLAND_
#   define  MEM_ALLOC(size) (farmalloc((unsigned long)(size))
#   define  MEM_FREE(ptr)   ((ptr)? farfree((void far*)(ptr)):0)
#   define  STRCPY(t, s)(_fstrcpy((char FAR*)(t), (char FAR*)(s)))
#   define  STRNCPY(t,s,n)  (_fstrncpy((char FAR*)(t), (char FAR*)(s), 
(size_t)(n)))
#   define  STRLEN(str) ((str)? _fstrlen((char FAR*)(str)):0)
#   define  STREQ(a, b) (_fstrcmp((char FAR*)(a), (char FAR*)(b) == 0)
#  endif

# endif /* WINDOWS */

# defineSYSERR  (-1)

# ifndefNULL
#   define  NULL((void FAR*)0UL)
# endif

#endif

##

Compiled OK(version 404sp1); './configure' '--with-openlink=/usr/local/openlink' 
'--with-mysql' '--with-apache=../apache_1.3.17' '--enable-track-vars' 

Caused This WARNING when make-ing: 

make[3]: Entering directory `/tmp/php-4.0.4pl1/ext/odbc'
gcc  -I. -I/tmp/php-4.0.4pl1/ext/odbc -I/tmp/php-4.0.4pl1/main -I/tmp/php-4.0.4pl1 
-I/tmp/apache_1.3.17/src/include -I/tmp/apache_1.3.17/src/os/unix 
-I/tmp/php-4.0.4pl1/Zend -I/tmp/php-4.0.4pl1/ext/mysql/libmysql 
-I/usr/local/openlink/odbcsdk/include -I/tmp/php-4.0.4pl1/ext/xml/expat/xmltok 
-I/tmp/php-4.0.4pl1/ext/xml/expat/xmlparse -I/tmp/php-4.0.4pl1/TSRM  
-DXML_BYTE_ORDER=12 -g -O2  -c php_odbc.c  touch php_odbc.lo
In file included from php_odbc.h:128,
 from php_odbc.c:31:
/usr/local/openlink/odbcsdk/include/udbcext.h:47: warning: `SQL_LEN_DATA_AT_EXEC' 
redefined
/usr/local/openlink/odbcsdk/include/sqlext.h:250: warning: this is the location of the 
previous definition

***

Now Apache won't run; NOTHING reported in /etc/httpd/logs - where can i find failure 
reason?

Trying again with older versions of PHP and Apache.

[PHP-DEV] PHP 4.0 Bug #9044 Updated: Compiling with latest Openlink ODBC fails with PHP4

2001-02-01 Thread antiphobo 

ID: 9044
User Update by: [EMAIL PROTECTED]
Status: Open
Bug Type: Compile Failure
Description: Compiling with latest Openlink ODBC fails with PHP4

Modified Openlink3.2 iodbc.h so that it could be used with openlink4:

contents of /usr/local/openlink/odbcsdk/include/iodbc.h now:
##

#ifndef _CONFIG_H
#define _CONFIG_H

# if!defined(WINDOWS)  !defined(WIN32_SYSTEM)
#  define   _UNIX_

#  include  stdlib.h
#  include  sys/types.h

#  define   MEM_ALLOC(size) (malloc((size_t)(size)))
#  define   MEM_FREE(ptr)   {if(ptr) free(ptr);}

#  define   STRCPY(t, s)(strcpy((char*)(t), (char*)(s)))
#  define   STRNCPY(t,s,n)  (strncpy((char*)(t), (char*)(s), (size_t)(n)))
#  define   STRCAT(t, s)(strcat((char*)(t), (char*)(s)))
#  define   STRNCAT(t,s,n)  (strncat((char*)(t), (char*)(s), (size_t)(n)))
#  define   STREQ(a, b) (strcmp((char*)(a), (char*)(b)) == 0)
#  define   STRLEN(str) ((str)? strlen((char*)(str)):0)

#  define   EXPORT
#  define   CALLBACK
#  define   FAR


# endif /* _UNIX_ */

# ifdefined(WINDOWS) || defined(WIN32_SYSTEM)

#  include  windows.h
#  include  windowsx.h

#  ifdef_MSVC_
#   define  MEM_ALLOC(size) (fmalloc((size_t)(size)))
#   define  MEM_FREE(ptr)   ((ptr)? ffree((PTR)(ptr)):0))
#   define  STRCPY(t, s)(fstrcpy((char FAR*)(t), (char FAR*)(s)))
#   define  STRNCPY(t,s,n)  (fstrncpy((char FAR*)(t), (char FAR*)(s), 
(size_t)(n)))
#   define  STRLEN(str) ((str)? fstrlen((char FAR*)(str)):0)
#   define  STREQ(a, b) (fstrcmp((char FAR*)(a), (char FAR*)(b) == 0)
#  endif

#  ifdef_BORLAND_
#   define  MEM_ALLOC(size) (farmalloc((unsigned long)(size))
#   define  MEM_FREE(ptr)   ((ptr)? farfree((void far*)(ptr)):0)
#   define  STRCPY(t, s)(_fstrcpy((char FAR*)(t), (char FAR*)(s)))
#   define  STRNCPY(t,s,n)  (_fstrncpy((char FAR*)(t), (char FAR*)(s), 
(size_t)(n)))
#   define  STRLEN(str) ((str)? _fstrlen((char FAR*)(str)):0)
#   define  STREQ(a, b) (_fstrcmp((char FAR*)(a), (char FAR*)(b) == 0)
#  endif

# endif /* WINDOWS */

# defineSYSERR  (-1)

# ifndefNULL
#   define  NULL((void FAR*)0UL)
# endif

#endif

##

Compiled OK(version 404sp1); './configure' '--with-openlink=/usr/local/openlink' 
'--with-mysql' '--with-apache=../apache_1.3.17' '--enable-track-vars' 

Caused This WARNING when make-ing: 

make[3]: Entering directory `/tmp/php-4.0.4pl1/ext/odbc'
gcc  -I. -I/tmp/php-4.0.4pl1/ext/odbc -I/tmp/php-4.0.4pl1/main -I/tmp/php-4.0.4pl1 
-I/tmp/apache_1.3.17/src/include -I/tmp/apache_1.3.17/src/os/unix 
-I/tmp/php-4.0.4pl1/Zend -I/tmp/php-4.0.4pl1/ext/mysql/libmysql 
-I/usr/local/openlink/odbcsdk/include -I/tmp/php-4.0.4pl1/ext/xml/expat/xmltok 
-I/tmp/php-4.0.4pl1/ext/xml/expat/xmlparse -I/tmp/php-4.0.4pl1/TSRM  
-DXML_BYTE_ORDER=12 -g -O2  -c php_odbc.c  touch php_odbc.lo
In file included from php_odbc.h:128,
 from php_odbc.c:31:
/usr/local/openlink/odbcsdk/include/udbcext.h:47: warning: `SQL_LEN_DATA_AT_EXEC' 
redefined
/usr/local/openlink/odbcsdk/include/sqlext.h:250: warning: this is the location of the 
previous definition

***

Now Apache won't run; NOTHING reported in /etc/httpd/logs - where can i find failure 
reason?

Trying again with older versions of PHP and Apache.


Previous Comments:
---

[2001-02-01 03:09:06] [EMAIL PROTECTED]
Well using the old (ver3.2) iodbc.h doesn't work with ver 4 :(

gcc  -I. -I/tmp/php-4.0.2/main -I/tmp/php-4.0.2 -I/tmp/php-4.0.2/main 
-I/tmp/apache_1.3.17/src/include -I/tmp/apache_1.3.17/src/os/unix 
-I/tmp/php-4.0.2/Zend -I/tmp/php-4.0.2 -I/tmp/php-4.0.2/ext/mysql/libmysql 
-I/usr/local/openlink/odbcsdk/include -I/tmp/php-4.0.2/ext/xml/expat/xmltok 
-I/tmp/php-4.0.2/ext/xml/expat/xmlparse  -DXML_BYTE_ORDER=12 -g -O2  -c 
internal_functions.c  touch internal_functions.lo
In file included from /tmp/php-4.0.2/ext/odbc/php_odbc.h:115,
 from internal_functions.c:38:
/usr/local/openlink/odbcsdk/include/udbcext.h:47: warning: `SQL_LEN_DATA_AT_EXEC' 
redefined
/usr/local/openlink/odbcsdk/include/sqlext.h:250: warning: this is the location of the 
previous definition
In file included from /usr/local/openlink/odbcsdk/include/sql.h:37,
 from /usr/local/openlink/odbcsdk/include/isql.h:32,
 from /tmp/php-4.0.2/ext/odbc/php_odbc.h:113,
 from internal_functions.c:38:
/usr/local/openlink/odbcsdk/include/sqltypes.h:68: conflicting types for `WORD'
/usr/local/openlink/odbcsdk/include/iodbc.h:25: previous declaration of `WORD'
/usr/local/openlink/odbcsdk/include/sqltypes.h:69: conflicting types for `DWORD'

[PHP-DEV] PHP 4.0 Bug #9044 Updated: Compiling with latest Openlink ODBC fails with PHP4

2001-02-01 Thread antiphobo 

ID: 9044
User Update by: [EMAIL PROTECTED]
Status: Open
Bug Type: Compile Failure
Description: Compiling with latest Openlink ODBC fails with PHP4

Compiling Openlink4 with PHP 403sp1 and Apache 1.3.12 using the custom iodbc.h file I 
have included WORKS "FINE":

as in 
 - it compiles without errors
 - has warning: `SQL_LEN_DATA_AT_EXEC' redefined
 - produces a fully PHP-functional apache webserver

I still cannot manage to properly communicate to talbles using Openlink4, however, I 
recieve:

SQL error: [OpenLink][ODBC][Driver]Syntax error or access, SQL state 37000 in 
SQLExecDirect for complex selects such as "SELECT TOP 10 RECORD_NR, StatusField, 
ExtendedStatusField, PICTURE, SURNAME, FIRSTNAME, FORM, DOB, DESTINATION, EXPIRY FROM 
(SELECT TOP 10 * FROM WELLGIRLS ORDER BY RECORD_NR ASC,RECORD_NR ASC) ORDER BY 
RECORD_NR DESC,RECORD_NR DESC"

and for simple selects "SELECT * FROM TABLENAME", i get 

Warning: SQL error: [OpenLink][ODBC][Driver]Driver not capable, SQL state S1C00 in 
SQLExecDirect in /home/sites/home/web/current/Admin/admin_odbcsetup.php on line 125

The battle continues ... 

- Siggy

Previous Comments:
---

[2001-02-01 16:16:49] [EMAIL PROTECTED]
Modified Openlink3.2 iodbc.h so that it could be used with openlink4:

contents of /usr/local/openlink/odbcsdk/include/iodbc.h now:
##

#ifndef _CONFIG_H
#define _CONFIG_H

# if!defined(WINDOWS)  !defined(WIN32_SYSTEM)
#  define   _UNIX_

#  include  stdlib.h
#  include  sys/types.h

#  define   MEM_ALLOC(size) (malloc((size_t)(size)))
#  define   MEM_FREE(ptr)   {if(ptr) free(ptr);}

#  define   STRCPY(t, s)(strcpy((char*)(t), (char*)(s)))
#  define   STRNCPY(t,s,n)  (strncpy((char*)(t), (char*)(s), (size_t)(n)))
#  define   STRCAT(t, s)(strcat((char*)(t), (char*)(s)))
#  define   STRNCAT(t,s,n)  (strncat((char*)(t), (char*)(s), (size_t)(n)))
#  define   STREQ(a, b) (strcmp((char*)(a), (char*)(b)) == 0)
#  define   STRLEN(str) ((str)? strlen((char*)(str)):0)

#  define   EXPORT
#  define   CALLBACK
#  define   FAR


# endif /* _UNIX_ */

# ifdefined(WINDOWS) || defined(WIN32_SYSTEM)

#  include  windows.h
#  include  windowsx.h

#  ifdef_MSVC_
#   define  MEM_ALLOC(size) (fmalloc((size_t)(size)))
#   define  MEM_FREE(ptr)   ((ptr)? ffree((PTR)(ptr)):0))
#   define  STRCPY(t, s)(fstrcpy((char FAR*)(t), (char FAR*)(s)))
#   define  STRNCPY(t,s,n)  (fstrncpy((char FAR*)(t), (char FAR*)(s), 
(size_t)(n)))
#   define  STRLEN(str) ((str)? fstrlen((char FAR*)(str)):0)
#   define  STREQ(a, b) (fstrcmp((char FAR*)(a), (char FAR*)(b) == 0)
#  endif

#  ifdef_BORLAND_
#   define  MEM_ALLOC(size) (farmalloc((unsigned long)(size))
#   define  MEM_FREE(ptr)   ((ptr)? farfree((void far*)(ptr)):0)
#   define  STRCPY(t, s)(_fstrcpy((char FAR*)(t), (char FAR*)(s)))
#   define  STRNCPY(t,s,n)  (_fstrncpy((char FAR*)(t), (char FAR*)(s), 
(size_t)(n)))
#   define  STRLEN(str) ((str)? _fstrlen((char FAR*)(str)):0)
#   define  STREQ(a, b) (_fstrcmp((char FAR*)(a), (char FAR*)(b) == 0)
#  endif

# endif /* WINDOWS */

# defineSYSERR  (-1)

# ifndefNULL
#   define  NULL((void FAR*)0UL)
# endif

#endif

##

Compiled OK(version 404sp1); './configure' '--with-openlink=/usr/local/openlink' 
'--with-mysql' '--with-apache=../apache_1.3.17' '--enable-track-vars' 

Caused This WARNING when make-ing: 

make[3]: Entering directory `/tmp/php-4.0.4pl1/ext/odbc'
gcc  -I. -I/tmp/php-4.0.4pl1/ext/odbc -I/tmp/php-4.0.4pl1/main -I/tmp/php-4.0.4pl1 
-I/tmp/apache_1.3.17/src/include -I/tmp/apache_1.3.17/src/os/unix 
-I/tmp/php-4.0.4pl1/Zend -I/tmp/php-4.0.4pl1/ext/mysql/libmysql 
-I/usr/local/openlink/odbcsdk/include -I/tmp/php-4.0.4pl1/ext/xml/expat/xmltok 
-I/tmp/php-4.0.4pl1/ext/xml/expat/xmlparse -I/tmp/php-4.0.4pl1/TSRM  
-DXML_BYTE_ORDER=12 -g -O2  -c php_odbc.c  touch php_odbc.lo
In file included from php_odbc.h:128,
 from php_odbc.c:31:
/usr/local/openlink/odbcsdk/include/udbcext.h:47: warning: `SQL_LEN_DATA_AT_EXEC' 
redefined
/usr/local/openlink/odbcsdk/include/sqlext.h:250: warning: this is the location of the 
previous definition

***

Now Apache won't run; NOTHING reported in /etc/httpd/logs - where can i find failure 
reason?

Trying again with older versions of PHP and Apache.


---

[2001-02-01 03:09:06] [EMAIL PROTECTED]
Well using the old (ver3.2) iodbc.h doesn't work with ver 4 :(

gcc  -I. -I/tmp/php-4.0.2/main -I/tmp/php-4.0.2 -I/tmp/php-4.0.2/main 
-I/tmp/apache_1.3.17/src/include -I/tmp/apache_1.3.17/src/os/unix

[PHP-DEV] PHP 4.0 Bug #9044 Updated: Compiling with latest Openlink ODBC fails with PHP4

2001-01-31 Thread antiphobo 

ID: 9044
User Update by: [EMAIL PROTECTED]
Status: Open
Bug Type: Compile Failure
Description: Compiling with latest Openlink ODBC fails with PHP4

Ok, well obviously PHP isn't make'ing because of the missing iodbc.h:

My openlink4 dir (/usr/local/openlink/odbcsdk/include) 
contains: 

isql.h   isqltypes.h  sqlext.h udbcext.h
isqlext.hsql.hsqltypes.h

I just unzipped the Openlink 3.2, and the dir contained:
iodbc.hisql.h isqlext.h  udbcext.h
^^
^^

In both instances, only lmbr.taz and lmko.taz were used to install openlink. 
I'll try using the v3.2 iodbc.h (and a few other things if that doesn't work).

Previous Comments:
---

[2001-02-01 02:04:52] [EMAIL PROTECTED]
Tested with PHP402, 404Sp1 and Openlink version 4 :

php configured as:

/configure --with-openlink=/usr/local/openlink --with-mysql 
--with-apache=../apache_1.3.17 --enable-track-vars 

then make fails with :

gcc  -I. -I/tmp/php-4.0.2/main -I/tmp/php-4.0.2 -I/tmp/php-4.0.2/main 
-I/tmp/apache_1.3.17/src/include -I/tmp/apache_1.3.17/src/os/unix 
-I/tmp/php-4.0.2/Zend -I/tmp/php-4.0.2 -I/tmp/php-4.0.2/ext/mysql/libmysql 
-I/usr/local/openlink/odbcsdk/include -I/tmp/php-4.0.2/ext/xml/expat/xmltok 
-I/tmp/php-4.0.2/ext/xml/expat/xmlparse  -DXML_BYTE_ORDER=12 -g -O2  -c 
internal_functions.c  touch internal_functions.lo
In file included from internal_functions.c:38:
/tmp/php-4.0.2/ext/odbc/php_odbc.h:112: iodbc.h: No such file or directory
In file included from /tmp/php-4.0.2/ext/odbc/php_odbc.h:115,
 from internal_functions.c:38:
/usr/local/openlink/odbcsdk/include/udbcext.h:47: warning: `SQL_LEN_DATA_AT_EXEC' 
redefined
/usr/local/openlink/odbcsdk/include/sqlext.h:250: warning: this is the location of the 
previous definition
make[2]: *** [internal_functions.lo] Error 1
make[2]: Leaving directory `/tmp/php-4.0.2/main'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/tmp/php-4.0.2/main'
make: *** [all-recursive] Error 1

---


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


-- 
PHP Development 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]