NTWDBLIB.DLL ver 7.00.694, MsSQL 7.0 + 1 SP
The field is described as VARCHAR (1000)
At returning this field in SELECT - 255 characters come back only, other
characters do not come back.
Fido Net 2:5023/1.14
Neil Pike MVP/MCSE. Protech Computing LtdQuote:> NTWDBLIB.DLL ver 7.00.694, MsSQL 7.0 + 1 SP
> The field is described as VARCHAR (1000)
> At returning this field in SELECT - 255 characters come back only, other
> characters do not come back.
>> NTWDBLIB.DLL ver 7.00.694, MsSQL 7.0 + 1 SP
>> The field is described as VARCHAR (1000)
>> At returning this field in SELECT - 255 characters come back only, other
>> characters do not come back.
> Neil Pike MVP/MCSE. Protech Computing Ltd
> (Please reply only to newsgroups)
> SQL FAQ (412 entries) see
> or www.ntfaq.com/sql.html (+ ntfaq download)
> or http://www.sql-server.co.uk
Neil Pike MVP/MCSE. Protech Computing LtdQuote:> I have written many programs with use of this library, and I would not like
> them to alter. Really it so is difficult for correcting?
Beside that DB-Library does not support Unicode data types, the GUID data
type, new cursor models like fast forward only etc.
DB-Library is a dead API, it works as is against 7.0 and Shiloh but only
supports 6.5 level functionality. This is clearly stated in the Books Online
from SQL Server 7.0
It seems to me that the current ntwdblib.dll with MS SQL Server 7 CD
(beta 3) is not compatiable with MS SQL Server 7. If a table has nchar,
nvarchar, or ntext data type field, the application used the
ntwdblib.dll will not work properly. For example, the following simple
statemet cannot be executed successfully:
Select * from TableWithNTextField
However, an application used Sqlsrv32.dll will work fine.
In the past, isqlw.exe used ntwdblib.dll but the new isqlw.exe (with MS
SQL Server 7 beta 3 CD) uses sqlsrv32.dll. What is the reason for the
change? I cannot find the type definitions of nvarchar, nchar and ntext
in the new sqlfront.h, which defines the types of varchar, char and
ntext. When I used the dbcolinfo to get the data type info for nchar
field, the reture value is 0x2f, which is just char data type. So,
ntwdblib.dll is either not upgraded or cannot support the new MS SQL
Can any one shed some light one my problem? Thanks in advance.