RE: [PHP-DB] ODBC and PHP

The error message is: ------------------------------------------------------------- Cadastro de Fornecedor Warning: SQL error: [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionTransact (TransactNamedPipe())., SQL state 01000 in SQLExecDirect in c:\inetpub\inventario\cadastro\fornecedor.php on line 364 Warning: Supplied argument is not a valid ODBC result resource in c:\inetpub\inventario\cadastro\fornecedor.php on line 366 Warning: SQL error: [Microsoft][ODBC SQL Server Driver]Communication link failure, SQL state 08S01 in SQLExecDirect in c:\inetpub\inventario\cadastro\fornecedor.php on line 386 ------------------------------------------------------------- But the trace works fine. To make it work again I have to remove the configuration from the ODBC and create again. []s Ariadne Mensagem original >Ariadne, > >What is the exact error you get? >Among other debugging tricks, you can get an ODBC trace from the ODBC >Administrator control panel (if using Win32 on client side) and look at >where the API calls are failing. > >Best regards, >Andrew Hill >Director of Technology Evangelism >OpenLink Software http://www.openlinksw.com >Universal Data Access & Data Integration Technology Providers > >> -----Original Message----- >> From: acastilh@vento.com.br [mailto:acastilh@vento.com.br] >> Sent: Friday, July 27, 2001 6:30 PM >> To: php-db@lists.php.net >> Subject: [PHP-DB] ODBC and PHP >> >> >> >> I´m using PHP 4 with ODBC and sometimes I get a response that was unable >> to connect to the MSSQL database. Then I go to the ODBC configuration >to >> test the connection and I get a response that everything is working fine, >> but my pages still can´t connect. Is that normal? What can I do? >> >> I´m using NT Server 4 with apache 1.3. >> >> []s >> >> Ariadne >> >> >> >> >> -- >> PHP Database Mailing List (http://www.php.net/) >> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net >> For additional commands, e-mail: php-db-help@lists.php.net >> To contact the list administrators, e-mail: php-list-admin@lists.php.net >> >> > >