Watch, Follow, &
Connect with Us

CodeCentral

ID: 25934, Delphi 7 MS SQL Driver Update

by Tim DelChiaro Email: Anonymous


This update resolves two issues with the MSSQL driver
Available only to registered users of Delphi 7
Download Details
CDN Login Required to Download. (You will be redirected to the login page if you click on the Download Link)
Network License Users

If you are a network license user, click  here  to download this submission.

To download this, you must have registered [one of]:
Delphi 7 Personal Promotion
Delphi 7 Studio Architect Edition
Delphi 7 Studio Enterprise Edition
Delphi 7 Studio Enterprise Education Edition
Delphi 7 Studio Professional Edition
Delphi 7 Studio Professional Education Edition
Delphi 7 Personal Edition

For Delphi, Version 7.0  to 7.0
Copyright: No significant restrictions


Size: 60,729 bytes
Updated on Thu, 07 Oct 2010 17:04:48 GMT
Originally uploaded on Tue, 26 Aug 2008 16:03:39 GMT
SHA1 Hash: 149FBD34EC5EAF8A6E077AFA13CB6B4CCCA3C62D
MD5 Hash: 5741B4B044DCEEBC8EB9F0F9AA19B1E8

    Explore the files in this upload

Description
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, :Description)';
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\Delphi7\Bin

=======================================================
Copyright (c) 2002 Borland Software Corporation.
All rights reserved.

   Latest Comments  View All Add New

Move mouse over comment to see the full text

Server Response from: ETNACDC02

Copyright© 1994 - 2013 Embarcadero Technologies, Inc. All rights reserved.