home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
PC Treasures, Inc.
/
pctreasures.mdf
/
LABEL
/
DATA1.CAB
/
BDE
/
READLINK.TXT
< prev
next >
Wrap
Text File
|
1998-04-30
|
6KB
|
168 lines
============================================================
WELCOME TO BORLAND 32-BIT SQL LINKS 4.5 FOR WINDOWS 95/NT
---------------------------------------------------------
This file contains important, late-breaking information
about Borland SQL Links for Windows, including revisions
to the documentation. Information in this file supersedes
information in the SQL Links documentation.
TABLE OF CONTENTS
-----------------
1. TIPS FOR USING SQL LINKS
2. KNOWN PROBLEMS
3. BEHAVIOR CHANGES
1. TIPS FOR USING SQL LINKS
---------------------------
WHERE TO START
For information about configuring and connecting to SQL
servers, see the Help file SQLLNK32.HLP. SQLLNK32.HLP also
contains a Hints, Problems, and Notes topic containing
various tips and troubleshooting information.
2. KNOWN PROBLEMS
-----------------
DB2 ON WINDOWS 95
In Windows 95, you should catalog DB2 nodes using TCP/IP on the client,
such as
CATALOG TCP/IP NODE MYNODE ...
If you use the Microsoft IPX/SPX protocol, the protocol will hang when
metadata is retrieved. IBM reports that this is a Microsoft problem.
The DB2 SQL Links driver can only access servers in the Windows 95
environment that are connected using TCP/IP.
ROLLBACKS AND INFORMIX LOGGING TABLES
Rolling back a transaction on an Informix Logging database
invalidates the cursor. To avoid this, use ANSI databases or
close the cursor after rolling back the transaction and
reopen it.
SYBASE CT-LIB STORED PROCEDURES
When ENABLE BCD is TRUE, stored procedures with MONEY fields
fail to retrieve MONEY output parameters.
SYBASE CT-LIB DRIVER
The CT-Lib driver works with Sybase version 10.0.4 EBF7033
or higher.
INFORMIX - DECIMAL AND MONEY PRECISION
DECIMAL and MONEY data types are rounded to two decimal
places when getting data from the server. For example,
DECIMAL 123.4567 is rounded to 123.45. This is a vendor
issue. To prevent this, set ENABLE BCD to TRUE in the BDE
Administrator.
INFORMIX - APPLYING FILTERS
Applying a filter on DECIMAL and MONEY fields in
Informix will fail, because the data types are all mapped
to the BDE logical type fldFLOAT. To avoid this, use
passthrough SQL.
UPDATABLE SQL QUERIES
Tables owned by another user must be qualified by owner
name. Use quotation marks around the entire qualified
name, for example "OWNER"."TABLE".
INFORMIX - USING VERSION 7.2 WITH BLOB FIELDS
If you open a BLOB field on an Informix 7.2 server, trying
to move to another record causes the server to crash. This
is caused by an Informix problem corrected in version 7.21
of their server. You can also revert to version 7.14 to
avoid the problem. Reference case number 55155 when
contacting Informix for an update.
INSTALLSHIELD TEMPORARY DIRECTORIES IN WINDOWS NT
When installing the SQL Links under Windows NT, InstallShield
does not remove temporary directories named _ISTMPx.DIR, where
x is a number from 0 to 9. You must delete them manually.
ADDING DBASE INDEXES ON WINDOWS NT 3.51
When you add an index using DbiAddIndex or DbiCreateTable to
a dBASE table under Windows NT version 3.51, you must close
any cursors referencing the table and reopen them before
using the table. This problem only occurs with tables
located on a Novell NetWare server being accessed by
Microsoft's NetWare client for NT. A workaround is to use
Novell's NetWare client for NT.
OPENING ACCESS TABLES IN PARADOX FOR WINDOWS VERSION 7
Opening an Access table in version 7 of Paradox for Windows
crashes the program. A solution is being researched.
USING QBE WITH ACCESS TABLES IN PARADOX FOR WINDOWS VERSION 7
You can't currently use QBE queries with Access tables in
version 7 of Paradox for Windows.
INFORMIX - USING NATIONAL LANGUAGE SETTINGS
If your Informix client software is set up to use German language
settings, extraneous data may be displayed in CHAR or VARCHAR
fields. This is a problem with the client software and is being
investigated by Informix. A workaround is to set all national
language parameters to blank using the Informix SETNET32 utility.
DB2 - UNDERSCORES ( _ ) TREATED LIKE WILDCARDS
If the names of two tables differ by only an underscore (for
example, TABLE1 and TABLE_), and the same user owns both
tables, attempts to retrieve the meta data for TABLE_ also
retrieves the meta data for TABLE1. This is an IBM problem.
INFORMIX - USING NON-U.S. LOCALES WITH BCD ENABLED
If your Informix server is set to a locale where the default
decimal separator is not a period (.), such as German or
French, make sure that the client DBMONEY environment
variable is set to a period (.) if you have BCD ENABLED.
ORACLE - SETTING BLOB SIZE PARAMETER
When setting the BLOB SIZE parameter in the BDE configuration
for the Oracle SQL Links driver, add one to the size to prevent
data loss. For example, to retrieve 32k of data, set BLOB SIZE
to 33 instead of 32.
SYBASE - DBIBATCHMOVES WITH BATCOPY FAILS ON NON-U.S. VERSIONS
Batch copy operations (such as using DbiBatchMove with batCopy)
fail with a general SQL error on non-U.S. versions of Sybase
version 10.2. This is a Sybase problem.
3. BEHAVIOR CHANGES
-------------------
PERFORMANCE IMPROVEMENTS ON DBIMODIFYRECORD
DbiModifyRecord no longer generates an UPDATE statement
on unchanged record buffers. This improves performance.
TRANSACTION ISOLATION LEVELS AND SOFT COMMITS IN INTERBASE
By adding 4096 to the setting of DRIVER FLAGS in the BDE
configuration, you can specify that the InterBase SQL Links
driver should use soft commits. Soft commits are a feature
of InterBase that let the driver retain the cursor when
commiting changes. Soft commits improve performance on
updates to large sets of data. When not used, the BDE must
re-fetch all the records, even for a single record change.
With soft commit the cursor is retained, and a re-fetch
isn't needed. Soft commits are never used in explicit
transactions started by BDE client applications.
DRIVER FLAGS Isolation level and commit type
------------------------------------------------
0 Read committed, hard commit
512 Repeatable read, hard commit
4096 Read committed, soft commit
4608 Repeatable read, soft commit
============================================================