Invalid ODBC result resource
| From: | FAHIM K S | Date: | Wed, 26 Jun 2002 06:41:37 +0000 |
| Subject: | Invalid ODBC result resource | ||
| Groups: | php.install | ||
| Request: | Send a blank email to php-install+get-7487@lists.php.net to get a copy of this message | ||
Dear All,
I am usinng IIS (Internet Information Server) on windows 2000 Advanced Server. PHP is installed.
When I write the following script:
----------------------------------------------------------
<?php
$connection=odbc_connect("task","","") or die("Couldn't
connect.");
$sql="SELECT id,notes FROM task";
$sql_statement=odbc_prepare($connection,$sql) or die("Couldn't connect.");
$sql_result=odbc_execute($sql_statement) or die("Couldn't connect.");
odbc_result_all($sql_result);
odbc_free_result($sql_result);
odbc_close($connection);
?>
----------------------------------------------------------
I get an error which says:
Warning: Supplied argument is not a valid ODBC result resource in
c:\inetpub\wwwroot\tt.php on line 6
Warning: Supplied argument is not a valid ODBC result resource in
c:\inetpub\wwwroot\tt.php on line 7
Can anyone Please suggest me what to do.
Thanking you,
FAHIM