Delphi 7
MSSQL Driver Update
Release Notes
================================================== =====
This file contains important supplementary and late-
breaking information that may not appear in the main
product documentation, and supersedes information
contained in other documents, including previously
installed release notes, that accompany this product.
We recommend that you read this file in its entirety.
Important:
Delphi must be closed before installing this Update
Pack.
================================================== =====
CONTENTS
* ISSUES ADDRESSED IN THIS UPDATE PACK
* FILES INSTALLED BY THIS UPDATE PACK
================================================== =====
ISSUES ADDRESSED IN THIS UPDATE PACK
This update resolves two issues with the
MSSQL driver.
* Unable to connect with Empty Username/Password:
In the previous driver, trying to connect with an
empty Username/Password resulted in an
SQL error.
* Parameter binding into a VARCHAR column inserted an
extra trailing
ASCII 0 character
Attempting parameter binding inserts into a
VARCHAR column would insert an
ASCII 0 character at
the end of the data. For example, in a table with
Code defined as VARCHAR(12) and Description defined
as VARCHAR(50) the following code segment
demonstrates the problem.
sql.CommandText := 'INSERT INTO User1 (Code,
Description) ' + 'VALUES (:Code,
escription)';
sql.Params.ParamByName('Code').DataType := ftString;
sql.Params.ParamByName('Description').DataType :=
ftString;
sql.ParamByName('Code').AsString := 'TEST';
sql.ParamByName('Description').AsString := 'This is a
test';
sql.ExecSQL;
In the above example,
sql is a TSQLDataSet or
TSQLQuery.
Any subsequent SELECT's, like SELECT * FROM User1
where Code ='TEST' would fail to find the record.
Installing this Update resolves these issues.
================================================== =====
FILES INCLUDED IN THIS UPDATE PACK
* dbexpmss.dll
Replace these files in the Bin directory of your Borland
Delphi 7 installation with the files included in
this update. The default location for these files is:
C:\Program Files\Borland\Delphi\7\Bin
================================================== =====
Copyright (c) 2002 Borland Software Corporation.
All rights reserved.