Skip to Content
0
Former Member
Sep 22, 2016 at 03:46 PM

ADO error with "surrogate processing or pemissive unicode values"

483 Views

We've upgraded from 32bit Sybase 15 ADO drivers to 64bit Sybase 16 ADO drivers


and we're now seeing the occasional (a few times a day) from C# code.


"Could not retrieve current enable surrogate processing or pemissive unicode values from server"


ie

Sybase.Data.AseClient.AseException: Could not retrieve current enable surrogate processing or pemissive unicode values from server. at Sybase.Data.AseClient1.AseConnection.Open() at Sybase.Data.AseClient.AseConnection.Open() at UBSDelta.Database.Access.DbConnectionImpl.Open() at UBSDelta.Database.SqlExecutor.Open(IDbConnection connection) at



Mostly the code works so not sure why we're getting occasional messages ?

I can understand what the "enable surrogate processing" setting does but no idea why we're getting it ?


I assume its trying to execute the command held in spt_mda,


"select value2 from master.dbo.syscurconfigs where config = (select config from master.dbo.sysconfigures where name='enable surrogate processing' and parent != 19 and config != 19)"

I can run this ok.

Anyone seen this before ?

Could it be a race condition ?