[PHP-DEV] Does these ODBC_EXEC function changed their sintax in PHP4? From: Andre Felipe (Andre.Felipe <email protected>)
Date: 12/07/00

Hi friends,
after some digging I've found that to compile PHP 4.0.2 (or 4.0.3PL1 or 4.0.4RC4) with Openlink ODBC on Sun Solaris we must alter
php_odbc.c, changing:
"SQLINTEGER len" to "SDWORD len".

Ok, it now compiles. But ODBC functions that used to work in PHP 3.0.12 doesn't work anymore.
The following code gives the error:
Warning: SQL error: [OpenLink][ODBC][Driver]Syntax error or access, SQL state 37000 in
             SQLExecDirect in /software/apache/htdocs/aplic/teste/teste.htm on line 28

<?
$db = odbc_connect("DSN=Producao;UID=notes" , "" , "");
$query = "select nomefunc, matrica from srhtb002";
$result = odbc_exec ($db, $query); // THIS is line 28
print "ok. result = $result";

$nextrow = odbc_fetch_row($result, 1);
if (! $nextrow ) {
 print "Nothing...<br>";
    }
else {
    print odbc_result($result , 1 );
    print "<br>";
    print odbc_result($result , 2 );
}
?>

Does these ODBC functions changed their sintax ???????? 

-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: php-dev-unsubscribe <email protected>
For additional commands, e-mail: php-dev-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>