Hi to all...please can you help me ...because i cant retrieve any row
of the database on MS SQL Server 7 with ODBC . i did use Openlink
driver on a Solaris 6 machine (Sparc) , the database are on WIN NT4.0
my code is.
<?
/* some environment variables, you can test to comment them out to see
if things
* still work.
*/
putenv("LD_LIBRARY_PATH=/base/odbc/lib:$LD_LIBRARY_PATH");
putenv("UDBCINI=/base/odbc/bin/udbc.ini");
putenv("ODBCINI=/base/odbc/bin/odbc.ini");
putenv("DebugFile=/tmp/udbc.out"); // debug trace output
$dsn="NT"; // note 'DSN=' is required
$user="shark";
$password="shark";
$sql="select * from frases ";
$connect_odbc=odbc_connect($dsn,"shark","shark",SQL_CUR_USE_ODBC) or
die("Erreur
de connexion au serveur");
if (!odbc_autocommit($connect_odbc, TRUE)) {
echo 'pb auto_commit';
return;
}
// selection avant
$Req_hebd = "select * from frases ";
echo $Req_hebd .'<br>';
if (!($Res_hebd=odbc_prepare($connect_odbc,$Req_hebd))) {
echo 'pb prepare';
}
if (!odbc_execute($Res_hebd)) {
echo 'pb execute';
}
if (!($res=odbc_result_all($Res_hebd))) {
echo 'pb result_all';
}
?>
this code reply "NO ROWS FOUND" , the connection are OK...the databse
have many rows(of course)..
Thank's a lot.
Cristian
--
PHP Database 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]
