Hey there folks... OK, so I am getting to the point where I am not sure where to look... It would seem that the combination of PHP & ODBC are just not happy. This is running on SLES 10 SP1, php 5.1.2 Zend Eng 2.1.0 FreeTDS is latest stable, UNIXOdbc Latest Stable I can connect just fine ie: $conn = odbc_connect(SrvIP,'sa','saPWD'); Changing databases is not problem ie: odbc_exec($conn,'use different_DB'); I can make calls to things like odbc_tables() and iterate through the table names. and I can do this from either the server command line or via a web page, all of this is fine. I can connect to the remove database server with both: tsql [serverip], [username],[password] isql [DSN], [username],[password] I can execute queries, I can create tables, drop tables, insert rows, all works just fine. The problem hits when I do something as simple as: $conn = odbc_connect(SrvIP,'sa','saPWD'); $query = 'select count(*) from sysobjects' ; $result = odbc_exec($conn,$query); I try this and it is game over. Nothing it all just hangs. I have tried reviewing the sql.log file and it just simply stops logging after the connect statement. This is the result, from either the command line ie:php5 sqltest.php or pulling it from a web page ie: http://server/sqltest.php I would be very appreciative if someone could provide me with a clue as to where to start looking. I have reviewed all the setting for PHP, Apache, ODBC, FreeTDS and I cannot find something wrong, but obviously, I am missing something here. Thanks in Advance, - Bill -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
