|
I have a question about SQLCA in Ultra Lite17. When I refer to Ultra Lite's HELP, I see the phrase SQLCA, but I don't know how to implement it in C#. Referenced URL: https://dcx.sap.com/index.html#sqla170/ja/html/3bd645d06c5f10149435f7046055716b.html https://help.sap.com/docs/SAP_SQL_Anywhere/98ad9ec940e2465695685d98e308dff5/3bd645d06c5f10149435f7046055716b.html?locale=en-US The above address only describes how to implement it in C++. Could you please let me know if there is a way to implement it in C#? |
Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.
Follow this question
By Email:Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
- *italic* or _italic_
- **bold** or __bold__
- link:[text](http://url.com/ "title")
- image?
- numbered list: 1. Foo 2. Bar
- to add a line break simply add two spaces to where you would like the new line to be.
- basic HTML tags are also supported
Question tags:
question asked: 11 Dec '23, 20:38
question was seen: 195 times
last updated: 12 Dec '23, 08:14
SQLCA is an embedded SQL structure. It would not generally be used in a C# application - and if so, it would need to be implemented in unmanaged code.
You can think of ULConnection as loosely related to SQLCA. If you application requires multithreaded access to the database, each thread should have a separate ULConnection instance (connection). An error will be reported if more than one thread tries to concurrently access the database from the same connection.
UltraLite Embedded SQL
Connection Setup for an UltraLite Database
Thank you for your quick response. I will consider implementing it with unmanaged code. If you have any implementation examples or sample code using unmanaged code, I would appreciate it if you could let me know.
Adding unmanaged code is likely an unnecessary complexity since there is little, if anything, that can only be achieved in embedded SQL. Perhaps we can provide guidance on implementation in UL.NET.
If you need to use embedded SQL that you are calling from .NET, refer to:
Consuming Unmanaged DLL Functions