Agile Developer

Access Violation an...
 
Notifications
Clear all

Access Violation and Collation Conflict Issues

2 Posts
2 Users
0 Reactions
294 Views
Posts: 609
Topic starter
(@banupriya)
Noble Member
Joined: 2 years ago

Encountering an issue while creating an IVIEW with hard-coded Arabic content in the SQL query. After importing structures from the Oracle schema to the MS SQL schema, the form caption that contains Arabic text results in an Access Violation error upon opening. In contrast, other forms/IVIEWs without Arabic content in their captions open without any issues.

Additionally, we are unable to go online with the structures developed on the desktop due to the following error:
Error in - memrq: [Microsoft][SQL Server Native Client 11.0][SQL Server] Cannot resolve collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Arabic_CI_AS" in the concat operator for the CONVERT operation.


1 Reply
Posts: 602
Admin
(@axpertsupport)
Honorable Member
Joined: 2 years ago

The reported issue is currently being addressed by the product team. Can expect the fix as part of the upcoming release.

 


Reply
Share: