Skip to Content
0

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

Dec 15, 2016 at 05:29 PM

163

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Mark A Parsons Dec 16, 2016 at 10:12 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Prashant Yewale Dec 22, 2016 at 10:51 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded