Question and Answer Database
FAQ3823B.txt — Sybase 11.5 server causes problems for SQL Explorer
Category :Database (Sybase)
Platform :Win95/NT
Product :C++Builder1.0, C++Builder3.x, Delphi2.x, Delphi3.x, Delphi4.x
Question:
When connecting to a Sybase 11.5 server the following
problems occur in SQL Explorer:
1. Type is shown as SYBASE: Unknown Version:
Mapping error: Bad template: SQL Server/([0-9]+).
2. Only Columns, Indices and Triggers and shown below
tables in the tree.
3. Selecting the text tab of table which has a numeric
field results in the error dialog
"Property Precision does not exist".
Answer:
You can solve this problem by editing the DBX.DBI file
in your bin directory. Find the line the reads:
SYBASE:IdentityRE=SQL Server/([0-9]+).
change it to:
SYBASE:IdentityRE=[SQL Server][Adaptive Server Enterprise]/([0-9]+).
This will resolve the problem.
Note that this problem does not occur in Delphi 5 or later, or C++ Builder 5 or later because the DBX.DBI file has been updated to include this fix.
Last Modified: 01-MAR-00