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" <rtwitty@xxxxxxxxxxxxxxxxx> a écrit dans le message de > news:Pine.GSO.4.44.0407080848320.29757-100000@xxxxxxxxxx > 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 ÿ¿h¼fL@p ÿ?HÙ25ù¹áÈJ@XûX@»Q@èÿ¿Q@ > > > > 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
