Re: Re: MSSQL query problem

That is true, DB-Library used to build the MSSQL extension was designed for MS SQL Server 4.x, and updated for version 6.x. Microsoft has not opdated the library since version 6.0 but many new types (ntext, nvarchar, char(8000) and varchar(8000)) has beed added to SQL Server 7.0 and SQL Server 2000. These new types are not supported. If you are running PHP on a Win32 platform you can use ODBC or ADO DB (a COM object) to access the database. - Frank > Some data types are not supported by the php_mssql extension I suspect. > Frank Kromann, php_mssql author might be able to enlighten us. > > Regards, John > > Jorge giménez mayorgas <jorgegmamg@hotmail.com> wrote in message > news:OE74WPPIHSuXrqqiYQN0000ae99@hotmail.com... > Hi there. > > I am using PHP 4.06 + W2k server + MSSQL > > When trying to make a simple query like > "select * from table", the result is the following strange message : > > Warning: MS SQL message: No se puede enviar datos de Unicode de > intercalación exclusiva de Unicode o datos ntext mediante DB-Library (como > ISQL) o la versión ODBC 3.7 o anterior. (severity 16) in > D:\yntraweb\programas\gestion.php on line 25 > > > The line 25 has this > $result = mssql_query($query,$link) ; > > The connection is ok and the selection of db is ok too. > > Any idea will be welcomed > > Thanks , > Jorge Giménez > > > > > -- > 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 > > >