Delphi 7 - updated MSSQL driver and updated CORBA support

By: Anders Ohlsson

Abstract: Updated MSSQL driver, updated CORBA support and updated docs

These updates for Delphi 7 contain 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. There's also an update for CORBA support. More information in the README below.

The update also contain several documentation updates.

The update itself can be downloaded 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
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\Delphi\7\Bin
 
=======================================================
Copyright (c) 2002 Borland Software Corporation.
All rights reserved.

Server Response from: ETNASC03