Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in August and this forum will be retired.

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#?

asked 11 Dec '23, 20:38

miyata's gravatar image

miyata
1112
accept rate: 0%

1

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

(11 Dec '23, 21:32) Chris Keating
Replies hidden
Comment Text Removed

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.

(12 Dec '23, 01:34) miyata

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

(12 Dec '23, 08:13) Chris Keating
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • 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:

×162
×8

question asked: 11 Dec '23, 20:38

question was seen: 240 times

last updated: 12 Dec '23, 08:14