note 28835 added to function.odbc-fetch-into
| From: | free at muktimedia dot com | Date: | Sat, 25 Jan 2003 11:23:25 +0000 |
| Subject: | note 28835 added to function.odbc-fetch-into | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-42723@lists.php.net to get a copy of this message | ||
Problem w/ MSSQL 2000 (or 7 possibly):::::
Warning: SQL error: [Microsoft][ODBC SQL Server Driver]Invalid
Descriptor Index, SQL state S1002 in SQLGetData in ...
http://bugs.php.net/bug.php?id=18514
The above error will be seen when calling @ODBC_RESULT_ALL() on a resultset that contains a field of
type 'text' (MSSQL 2K). If you see this error in @ODBC_RESULT_ALL then surely
@ODBC_FETCH_INTO() will return false when the resultset contains a field of type 'text'
(MSSQL 2K) - causing headaches.
WORKAROUND : change the field type to NTEXT (SQL 2K/7) - this is preferable in many cases (except DB
storage space) since NTEXT is simply Unicode Text.
I tried a workaround at http://www.phpbuilder.com/mail/php-db/2001071/0240.php
but this didn't work.
It appears PHP could benefit from an update to its ODBC libraries since 'text' and
'memo' fields are often used in Win32 environments...
--
http://www.php.net/manual/en/function.odbc-fetch-into.php
http://master.php.net/manage/user-notes.php?action=edit+28835
http://master.php.net/manage/user-notes.php?action=delete+28835
http://master.php.net/manage/user-notes.php?action=reject+28835