Re: [PHP-DB] ODBC avec PHP
You will have much better results if you use the odbtp extension instead of the odbc extenstion, especially on Linux. The odbtp_field_type() function will give you the correct type name. Also, you could use the mssql extension. However, mssql_field_type() returns type names that are not exact. For example, it returns char for all character fields even if their type is varchar, text, nchar, nvarchar or ntext. -- bob On Thu, 8 Jul 2004, Jean-François Léost wrote: hi I want to use the function odbc_field_type on a linux mandrake 10 with PHP 4.3.7 with unixODBC et freeTDS This function never give me a good answer : Example of an answer : Xÿ¿p [EMAIL PROTECTED] [EMAIL PROTECTED]@[EMAIL PROTECTED]@ Someone can help me ? Jeff -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] ODBC avec PHP
Hi Thanks for your answer but : What is odbtp extension I don't find it on www.php.net ??? I use ADOdb to database abstraction and I can't change all the ADOdb code. Do you know why the function odbc_field_type don't give me the good result ? Is is a PHP error, an unixODBC error or a freeTDS error ? To acces to MsSqlServer, which ODBC connection do you prefer ? thx to help me Jeff Robert Twitty [EMAIL PROTECTED] a écrit dans le message de news:[EMAIL PROTECTED] You will have much better results if you use the odbtp extension instead of the odbc extenstion, especially on Linux. The odbtp_field_type() function will give you the correct type name. Also, you could use the mssql extension. However, mssql_field_type() returns type names that are not exact. For example, it returns char for all character fields even if their type is varchar, text, nchar, nvarchar or ntext. -- bob On Thu, 8 Jul 2004, Jean-François Léost wrote: hi I want to use the function odbc_field_type on a linux mandrake 10 with PHP 4.3.7 with unixODBC et freeTDS This function never give me a good answer : Example of an answer : Xÿ¿p [EMAIL PROTECTED] [EMAIL PROTECTED]@[EMAIL PROTECTED]@ Someone can help me ? Jeff -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] ODBC avec PHP
The latest version of ADODb supports odbtp. You can get it at http://odbtp.sourceforge.net. There are 2 versions of the ADODb driver: odbtp and odbtp_unicode. The problem you are having is caused by the inability of the ODBC driver to provide what the desired information. The FreeTDS ODBC driver still needs some more work. The odbtp extension currently provides the most complete support for SQL Server 2000. -- bob On Thu, 8 Jul 2004, Jean-François Léost wrote: Hi Thanks for your answer but : What is odbtp extension I don't find it on www.php.net ??? I use ADOdb to database abstraction and I can't change all the ADOdb code. Do you know why the function odbc_field_type don't give me the good result ? Is is a PHP error, an unixODBC error or a freeTDS error ? To acces to MsSqlServer, which ODBC connection do you prefer ? thx to help me Jeff Robert Twitty [EMAIL PROTECTED] a écrit dans le message de news:[EMAIL PROTECTED] You will have much better results if you use the odbtp extension instead of the odbc extenstion, especially on Linux. The odbtp_field_type() function will give you the correct type name. Also, you could use the mssql extension. However, mssql_field_type() returns type names that are not exact. For example, it returns char for all character fields even if their type is varchar, text, nchar, nvarchar or ntext. -- bob On Thu, 8 Jul 2004, Jean-François Léost wrote: hi I want to use the function odbc_field_type on a linux mandrake 10 with PHP 4.3.7 with unixODBC et freeTDS This function never give me a good answer : Example of an answer : Xÿ¿p [EMAIL PROTECTED] [EMAIL PROTECTED]@[EMAIL PROTECTED]@ Someone can help me ? Jeff -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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, 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
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]