Skip to Content
avatar image
Former Member

" Incorrect syntax near ';' " - Sybase.AdoNet2.AseClient 2.157.1360.0

Hello Team,

Recently our organization has upgraded our sybase infrastructure from version 15.5 to 15.7.

In our application we are using Sybase Ado.Net to connect to sybsae db.

With Sybase.AdoNet2.AseClient 2.155.1000.0 multiple sql statements separated with ';' were working fine.

Ex. insert test_table (SourceSystem, SourceSystemRef, ModifiedBy) values ('AAA-XYZ', '123456/680152', 'prashant'); select CAST(@@identity as bigint)

But with Sybase.AdoNet2.AseClient 2.157.1360.0 when we try to execute same statements we get the error as " Incorrect syntax near ';' ".

Please let us know the solution for this. Also please note that for some reason we can't modify our code to remove ';'.

Thanks Prashant

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 16, 2016 at 10:12 PM

    You may want to expand your potential audience by editing your original post and adding some additional tags, eg:

    + SAP Adaptive Server Enterprise

    + Sybase Software Developer Kit

    + Sybase SDK

    --------------

    If you haven't already done so ... I'd also suggest reviewing the latest documentation for the Sybase SDK to see if there's an explanation for what appears to be a change in the Ado.Net behavior.

    NOTE: I'd provide a link to the SDK documentation but (at the moment) I'm unable to find anything pertaining to Sybase SDK with SAP's POS search capabilities ...

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 22, 2016 at 10:51 AM

    Update :

    SAP was able to reproduce it. They created CR for this issue. The last time this worked was in SDK 15.7 ESD#2.

    Add comment
    10|10000 characters needed characters exceeded