Very Computer

by **Steve Stoenne** » Wed, 03 Mar 2004 05:49:18

Does anybody know if you can call procedures such as sp_executesql that
require nvarchar
parameters using DBLIB?... I don't see any reference to the nvarchar
datatype in DBLIB.
Thanks

by **Alan Brewer [MSFT** » Wed, 03 Mar 2004 06:26:26

The thing most likely to impact this is that DB-Library basically operates
at the SQL Server 6.5 level, so all long strings are truncated to 255 bytes,
which was the max size of the character and binary datatypes back then.

Have a look at this topic in the SQL Server 2000 Books Online, it gives the
effects of connecting early version clients with SQL Server 2000:

http://msdn.microsoft.com/library/?url=/library/en-us/bldgapps/ba_hig...

DB-Library was frozen in SQL Server 6.5, so does not support some of the
features introduced in SQL Server 7.0 or SQL Server 2000.

--
Alan Brewer [MSFT]
Lead Programming Writer
SQL Server Documentation Team

This posting is provided "AS IS" with no warranties, and confers no rights

Very Computer

Using DBLIB to call sp_executesql

Using DBLIB to call sp_executesql

Using DBLIB to call sp_executesql