RE: [PHP-DB] ODBC and PHP
| From: | Andrew Hill | Date: | Wed, 01 Aug 2001 16:52:44 +0000 |
| Subject: | RE: [PHP-DB] ODBC and PHP | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-10961@lists.php.net to get a copy of this message | ||
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: acastilh@vento.com.br [mailto:acastilh@vento.com.br]
> Sent: Wednesday, August 01, 2001 10:52 AM
> To: ahill@openlinksw.com; php-db@lists.php.net
> 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: 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
> >>
> >>
> >
> >
>
>
>
>
>
>
>