FreeTDS Development Group

["Thomas, Christopher (LLU)" <cwthomas AT llu.edu>]

It has been my experience that when doing select queries with odbc or the 
mssql php api, you have to free the results before you can execute another 
query.

-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org 
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Tamás Benkó
Sent: Thursday, September 28, 2006 2:43 AM
To: FreeTDS AT lists.ibiblio.org
Subject: [freetds] php problem

Hi,

i try to migrate a web page from windows to linux, and I get trouble.

My problem is the folloing script:

$connection_string = 'DRIVER={FreeTDS};SERVER=192.168.1.100;DATABASE=teszt 
ca';
$connect = odbc_connect($connection_string, "user", "userpwd"); 

$query = "SELECT * FROM causer"; 

echo "Befor executing the 1.<br />";
$result1 = odbc_exec($connect, $query); 
echo "After executing the 1.<br />";
$result2 = odbc_exec($connect, $query); 
echo "After executing the 2.<br />";

echo "result1: " . $result1 . "<br>";
echo "result2: " . $result2 . "<br>";

odbc_close($connect);

The first odbc_exec is ok, but at the second I get the folloing error: 
Warning: odbc_exec(): SQL error: l†Õ 
, SQL state 00000 in SQLExecDirect 
in /var/www/conn.php on line 10 

I use apache 1.3; unixodbc: 2.2.4-11; freetds-dev 0.61-6.2; 

Thanks,

Benkó Tamás

MÁV INFORMATIKA Kft.
PKI Üzleti Egység
Számítástechnikai Rendszermérnök

benko AT mavinformatika.hu
+36-1-457-94-12
+36-30-257-46-61
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds