X
xuri
Unregistered / Unconfirmed
GUEST, unregistred user!
Delphi 7 Update 1 - by Anders Ohlsson
Abstract:Updated MSSQL driver and updateddo
cs
This update for Delphi 7 contains an updated MSSQL driver that fixes the problem with empty user names and passwords. It also fixes an issue with extra NULL characters being added to VARCHAR columns. More information in the README below.
The update also contain severaldo
cumentation updates.
The update itself can bedo
wnloaded by clicking here.
README.TXT
Delphi 7
MSSQL Driver Update
Release Notes
=======================================================
This file contains important supplementary and late-
breaking information that may not appear in the main
productdo
cumentation, and supersedes information
contained in otherdo
cuments, 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.
Abstract:Updated MSSQL driver and updateddo
cs
This update for Delphi 7 contains an updated MSSQL driver that fixes the problem with empty user names and passwords. It also fixes an issue with extra NULL characters being added to VARCHAR columns. More information in the README below.
The update also contain severaldo
cumentation updates.
The update itself can bedo
wnloaded by clicking here.
README.TXT
Delphi 7
MSSQL Driver Update
Release Notes
=======================================================
This file contains important supplementary and late-
breaking information that may not appear in the main
productdo
cumentation, and supersedes information
contained in otherdo
cuments, 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.