ODBC Socket


Portion of Paradox for Windows 5.0 README.TXT

ODBC Connectivity

This release of Paradox for Windows has been certified with 
Microsoft's 2.0 ODBC Driver Manager. If you have a different 
version of the ODBC Driver Manager, back up your existing 
ODBC.DLL and ODBCINST.DLL files and copy the ODBC.NEW 
and ODBCINST.NEW files from your IDAPI directory into your 
existing ODBC directory (by default this is WINDOWS\SYSTEM),
and rename them to ODBC.DLL and ODBCINST.DLL.


-For information on how to create an ODBC driver connection 
and alias, search for "ODBC Driver Connection" in the IDAPI 
Configuration Utility online Help.

-Tips For Using ODBC Socket
This version of the ODBC Socket was qualified using Q+E's 
ODBC pack version 1.2. Driver-specific problems were discovered 
using the latest Btrieve driver. If using Btrieve, it is recommended 
you use the version 1.1 driver.
  
-This version of ODBC Socket is certified for use only with Binary 
(Byte-value) collation-based servers.

  
-When using pass-through SQL, case-sensitive object names 
should be enclosed in the DBMS identifier quote character.
  
-The driver description in the ODBC.INI must match the driver
name exactly as found in ODBCINST.INI in order for the IDAPI 
Configuration Utility to add drivers to the IDAPI configuration file.
  
-ODBC does not support owner qualified indexes. When opening 
a table with an index, do not specify an owner name as part 
of the index name parameter.

-ODBC Socket Datatype Identifiers The ODBC Socket supports 
standard ODBC datatype identifiers. For a list of those 
identifiers, refer to your ODBC documentation. Each individual 
ODBC driver allows you to create a table with only some of 
those datatype identifiers. For a list of driver-supported ODBC 
datatype identifiers, refer to your specific ODBC driver

documentation.

-Intersolv/Q+E Issues: The Q+E Oracle driver does not allow 
copying an Oracle table to another Oracle table. This is a known 
problem and will be fixed in the next release of the Q+E ODBC 
driver pack.

Netware SQL: When specifying Netware SQL BLOB\Memo fields 
it is necessary to specify a size <= 32765. The default of 
32767 that is assumed by the driver is incorrect due to field 
header information.

DB2/2 (Database Manager) does not support concatenation 
operators in queries.


Btrieve: In some situations the Btrieve Record Manager causes the 
error message "Record Manager Not Loaded" to appear. 
Following this error message, exit Windows and restart. Btrieve is 
unstable after this message appears.

-When creating a query using local SQL, you must use quotation 
marks around all date, time, and timestamp
values, as shown in the following example:

SELECT "Customer.db"."Customer No" from "Customer.db"
WHERE
("Customer.db"."First Contact" = "04/03/1990")

  
-When querying fields that require quatation marks on local SQL
tables, you must reference the table name with the field 
name. Otherwise, Paradox returns a "Capability not supported" 
error message. Field names that require quotation marks include 
keywords and names with blank spaces or special characters 
such as @, %, and /.

sql general