Skip to Content
avatar image
Former Member

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

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 --


CLASS 'asejdbc'

USING 'banana:3025'

Now I have an ASE server running on So I use dbisql to run --

create server ase_test class 'asejdbc' using ''

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.



Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    May 08, 2016 at 09:28 AM

    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


    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?


    Add comment
    10|10000 characters needed characters exceeded