ID: 24752 Updated by: [EMAIL PROTECTED] Reported By: ssc at coolspot dot de -Status: Open +Status: Suspended Bug Type: MSSQL related Operating System: Linux PHP Version: 4.3.8 New Comment:
Behave like this and receive no help. Previous Comments: ------------------------------------------------------------------------ [2004-08-24 08:40:10] [EMAIL PROTECTED] Please keep your insulting comments in front of you. What version doesn't work? ------------------------------------------------------------------------ [2004-08-23 21:36:29] ssc at coolspot dot de Ok, once again a lesson in the usage of a really famous tool, called "diff", which could by new to some of you. A TIP : if you are searching a release manager, call me. It is "really" anoying to double-check PHP each time i need to update. /mssql/php_mssql.h iff -wu php-4.3.8.working/ext/mssql/php_mssql.h php-4.3.8/ext/ --- php-4.3.8.working/ext/mssql/php_mssql.h 2004-08-23 15:56:59.000000000 +0200 +++ php-4.3.8/ext/mssql/php_mssql.h 2004-04-21 01:37:26.000000000 +0200 @@ -38,7 +38,7 @@ #if HAVE_FREETDS #ifndef SHORT -//typedef short SHORT; +typedef short SHORT; #endif #define SQLTEXT SYBTEXT #define SQLCHAR SYBCHAR @@ -62,7 +62,9 @@ #define SQLIMAGE SYBIMAGE #define SQLBINARY SYBBINARY #define SQLVARBINARY SYBVARBINARY +#ifdef SQLUNIQUE /* FreeTSD 0.61+ */ #define SQLUNIQUE SYBUNIQUE +#endif #define DBERRHANDLE(a, b) dberrhandle(b) #define DBMSGHANDLE(a, b) dbmsghandle(b) #define DBSETOPT(a, b, c) dbsetopt(a, b, c, -1) ------------------------------------------------------------------------ [2004-08-23 21:23:33] ssc at coolspot dot de Open again dudes. Is there somebody who needs lessons in CVS usage, or what ? ------------------------------------------------------------------------ [2004-08-12 18:52:08] zakharm at hotmail dot com I see that the following is in ext/mssql/php_mssql.h: #ifdef SQLUNIQUE /* FreeTSD 0.61+ */ #define SQLUNIQUE SYBUNIQUE #endif When configuring PHP via ./configure, is there a parameter I can send to configure to enable SQLUNIQUE? I did get it working by removing the #ifdef & #endif, but is there another way? My configuration: freedts ./configure --prefix=/usr/local/freetds --with-tdsver=8.0 php ./configure --with-mssql=/usr/local/freetds --with-regex=php --with-config-file-path=/etc/php4/apache --disable-rpath --enable-memory-limit --disable-debug --with-layout=GNU --with-pear=/usr/share/php --with-mysql=shared --with-apxs=/usr/bin/apxs ------------------------------------------------------------------------ [2004-06-08 15:44:31] dave at daveonline dot com I am having a simular issue, however I am getting type (36) unknown and not 35. The SQl server is Enterprise 2000. and the field is a uniqueidentifier type. here is a line from the error: Warning: mssql_query(): column 14 has unknown data type (36) in /opt/mysql-standard-4.0.18-pc-linux-i686/scripts/test.php on line 34 and here is the conf file -------------------------------------------- [global] # TDS protocol version tds version = 8.0 ; initial block size = 512 # uses some fixes required for some bugged MSSQL 7.0 server that # return invalid data to big endian clients # NOTE TDS version 7.0 or 8.0 should be used instead ; swap broken dates = no ; swap broken money = no # Database server login method, if both server and domain # logins are enabled, domain login is tried first if a domain # is specified, and if that fails the server login will be used. # OBSOLETE ; try server login = yes ; try domain login = no # The default authentication domain, can be overridden by # specifying a username with a domain prefix, e.g. DOMAIN\username # OBSOLETE use DOMAIN\username as username ; nt domain = WORKGROUP # If the server responds with different domain try that one? # OBSOLETE never been used ; cross domain login = no # Whether to write a TDSDUMP file for diagnostic purposes # (setting this to /tmp is insecure on a multi-user system) ; dump file = /tmp/freetds.log ; debug level = 10 # Command and connection timeouts ; timeout = 10 ; connect timeout = 10 # If you get out of memory errors, it may mean that your client # is trying to allocate a huge buffer for a TEXT field. # (Microsoft servers sometimes pretend TEXT columns are # 4 GB wide!) If you have this problem, try setting # 'text size' to a more reasonable limit text size = 64512 [testserver] host = <<DELETED>> port = 1433 tds version = 8.0 ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/24752 -- Edit this bug report at http://bugs.php.net/?id=24752&edit=1