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.
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
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
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
: 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
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