trouble with odbc
| From: | Michael Geier | Date: | Thu, 01 Feb 2001 17:44:25 +0000 |
| Subject: | trouble with odbc | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-37671@lists.php.net to get a copy of this message | ||
I am running php4.04pl1 on RedHat6.2 with --esoob (EasySoft) connecting to
MSSQL 7.0 on WinNT 4.
The connection to this db works from another program on same machine.
<?
$connection = odbc_connect("dsn","user","password") or die
('could not
connect to db');
$query = "SELECT * FROM customer WHERE email LIKE 'user@%'";
$result = odbc_exec($connection,$query) or die('could not execute query');
$count = odbc_num_rows($result);
echo $count;
?>
$count is returning -1.
When running SQL Server Enterprise Mgr. on NT box, this query reurns 3 dummy
records. Does anyone see the error? All help appreciated.
Michael Geier
CDMSports Systems Administration
EMail: mgeier@cdmsports.com