Why "create server" statement syntax failed when I copy sample from guide?

[Former Member]

Dear All,

   I'm new to SAP IQ, now I have a problem -- in the guide "RFE-Statement", we can see the "create server" should be like --

CREATE SERVER ase_prod

CLASS 'asejdbc'

USING 'banana:3025'

   Now I have an ASE server running on 10.62.47.172:8000. So I use dbisql to run --

create server ase_test class 'asejdbc' using '10.62.47.172:8000'

   But it keeps failing with error --

Could not execute statement.

Syntax error near 'asejdbc'

SQLCODE=-131, ODBC 3 State="42000"

Line 1, column 1

   I really don't know what makes this error. Would anyone kind help? Thanks in advance.

Regards

Eisen

[tayeb_hadjou · Accepted solution]

Hi Eisen,

Class 'asejdbc' is no longer supported. Use 'aseodbc' instead.

A doc CR758683 has been logged to remove reference to 'asejdbc' from IQ manuals.

See also

JDBC-Based Server Classes - What's New in SAP IQ 16.0 - SAP Library

KBAs:

1984848 - ASEJDBC is still given as examples in IQ!

1872093 - How to setup the remote ASE access from Sybase IQ 16 using ASEODBC class manually?

Regards,

[Former Member · Accepted solution]

Thank you very much...