Hi, i'm getting a very odd result, and i'd
like to know if this happened to anyone else.
I'm running php402 with the zend optimizer on win2k, and have an odbc conection to a sql7.0 DB.
I have a simple table, with a numeric key and a text field. Now , when i try to get something from it, with the code:
$rs = odbc_execlString, $sqlConn);
$status = odbc_fetch_row($rs);
a row is taken from the result, i'm sure the result is not empty, and then:
$mytext = odbc_result($rs, "tableTextField");
I always get the error "ODBC SQL Server Driver]Invalid Descriptor Index, SQL state S1002 in SQLGetData in filename.php line XX"
Now, if i change the field type to varchar, the php script works fine.
So, where is the problem? is an ODBC thing, or does php have any issue about real long data fields?
Thanks for the time.
like to know if this happened to anyone else.
I'm running php402 with the zend optimizer on win2k, and have an odbc conection to a sql7.0 DB.
I have a simple table, with a numeric key and a text field. Now , when i try to get something from it, with the code:
$rs = odbc_execlString, $sqlConn);
$status = odbc_fetch_row($rs);
a row is taken from the result, i'm sure the result is not empty, and then:
$mytext = odbc_result($rs, "tableTextField");
I always get the error "ODBC SQL Server Driver]Invalid Descriptor Index, SQL state S1002 in SQLGetData in filename.php line XX"
Now, if i change the field type to varchar, the php script works fine.
So, where is the problem? is an ODBC thing, or does php have any issue about real long data fields?
Thanks for the time.