Delphi32.com -- FAQ - Sybase 11.5 server causes problems for SQL Explorer

Sybase 11.5 server causes problems for SQL Explorer

When connecting to a Sybase .5 server the following problems occur in SQL Explorer: . 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".

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.

<< Previous Faq

Complete List

Next Faq >>