SQL Anywhere Error -143: Column '@@pagesize' not found

Toad Data Point
1

Hello,
Does someone know the reason of this error when I try to connect to a Sybase DB?
Thanks in advance.
Regards.

2

Hello melc,

This happens when you try to connect to SQL Anywhere or IQ using the ASE connection provider. What type and version of Sybase server are you trying to connect to?

3

In TDA 3.0 you can connect to Sybase IQ and SQL Anywhere. We have added these connection types. If you get a chance please download our beta and try them out.

http://tda.inside.quest.com/beta.jspa

If you need to stick with Sybase IQ or SQL Anywhere in TDA 2.7, try creating an ODBC connection. (Use ODBC type)

Debbie

4

Hi Debbie,
You are right. It works with TDA 3.0.
Moreover, I did not succeed to find any ODBC 3.0 compliant driver.
Thanks for your message.
Regards

5

Sybase does not typically allow you to download drivers unless you have purchased the software.

However, in the last couple of months the SQL Anywhere team made the client available to the public and can be downloaded from here: http://www.sybase.com/detail?id=1087327

The SQL Anywhere drivers are backwards compatible with all versions of SQL Anywhere and IQ.

6

Hello all,

I have Sybase IQ 12.7 drivers install package, in case anybody needs them, I’ll be glad to share.

Best regards,
Oscar