Mega Code Archive

 

Categories / Delphi / ADO Database

 

Sybase 11 5 server causes problems for sql explorer

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.