RE: [PHP-DB] ODBC and PHP
Ariadne, This appears to be an error in the driver itself, but without a trace I cannot be sure. Best regards, Andrew > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 01, 2001 10:52 AM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > >> Sent: Friday, July 27, 2001 6:30 PM > >> To: [EMAIL PROTECTED] > >> 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: [EMAIL PROTECTED] > >> For additional commands, e-mail: [EMAIL PROTECTED] > >> To contact the list administrators, e-mail: > [EMAIL PROTECTED] > >> > >> > > > > > > > > > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] >> Sent: Friday, July 27, 2001 6:30 PM >> To: [EMAIL PROTECTED] >> 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: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> To contact the list administrators, e-mail: [EMAIL PROTECTED] >> >> > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] ODBC and PHP
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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Friday, July 27, 2001 6:30 PM > To: [EMAIL PROTECTED] > 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: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]