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

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

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

    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,

    Add comment
    10|10000 characters needed characters exceeded