FreeTDS Development Group

[Tamás Benkó <benko AT mavinformatika.hu>]

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