community.borland.com

Article #18823: Sybase 11.5 server causes problems for SQL Explorer

 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 Precsion 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.

3/26/99 11:51:58 AM
 

Last Modified: 01-SEP-99