InterBase version support, Dialect 3 features
---------------------------------------------

Delphi 7 supports InterBase 6.5. The client version and
server version must be the same.

Currently, the driver does not support the ARRAY type.

To use the new InterBase 6.5 Dialect 3 features in BDE,
add an entry to your Windows registry under

HKEY_LOCAL_MACHINE\SOFTWARE\Borland\Database Engine
\Settings\Drivers\Intrbase\Db Open\SQLDIALECT

and set the String Value to "3".
When an InterBase alias is created, the new entry will
be available in the .CFG file.

To use InterBase 5.6, SQLDIALECT can be set to "1"
(existing IB aliases which do not have the SQLDIALECT
entry default to SQLDIALECT=1 or to the registry
setting when the SQLDIALECT entry is added to the
registry).


InterBase 6.5 implementation note
---------------------------------

If you are using a WebSnap application with InterBase
6.5, a local database connection is not recommended.
Instead, use a client/server connection specified by a
protocol-specific prefix to the path to the database.

Examples:

Local connection (not recommended):
C:\PathTo\Database\DBName.gdb

TCP/IP connection on Windows:
saturn:C:\PathTo\Database\DBName.gdb

TCP/IP connection on UNIX:
jupiter:/usr/PathTo/Database/DBName.gdb

NetBEUI connection:
\\venus\C:\PathTo\Database\DBName.gdb

IPX/SPX connection:
mars@vol2:\PathTo\Database\DBName.gdb

If the WebSnap application is on the same machine as
the server, you can use localhost:

localhost:C:\PathTo\Database\DBName.gdb


INTERBASE driver behavioral difference:
---------------------------------------

NUMERIC data type mapping.


The dbExpress driver for INTERBASE now maps NUMERIC
data types to fldBCD instead of fldINT16, fldINT32,
fldFLOAT.


dbExpress
---------

TSQLDataSet now has DefaultRowsetSize = 20 (Oracle
only). To use a different RowSetSize, add the
RowSetSize property manually (e.g., "RowsetSize = 200")
into dbxconnections.ini, for existing connections, or
into dbxdrivers.ini to have the RowSetSize property
included in new connections. RowsetSize can also be
modified in code, as shown here:

"SQLConnection1.Params.Values['RowsetSize'] :=
'200'"