Toad World® Forums

Sybase Database Error

When opening a table in a SYBASE ASE database, I get the message "Domain error during explicit conversion of INT value ‘0’ to a BIT field
Has someone an idee how I can solve this problem?

sybase database error.gif

Hello willy.placlet_296,

Can I ask what version of ASE you are using? Also does this happen with all tables or just certain ones?

Thanks.

Hello MichaelG,

The version of Sybase Ase is 11.5.1 ( seems to be rather old). This happens for all the tables.

Kind regards,

Willy

Hello willy.placlet_296,

Yes, unfortunately that version of ASE is quite old and no longer supported. Currently we support versions 12.5 and above.

You can modify all the SQL that Toad uses in the UI by going to Tools->Options - Database->SQL Dictionary. However, since I do not have access to an 11.5 server I am not sure which item is causing the issue.

Please let me know if that helps or if you have any other questions.

Thanks.

Hello MichaelG,

Thanks,

Willy