How does SQL Anywhere create the name connection parameter?

[former_SQLA_member1694893]

I know you can set the connection parameter (CON=...) and SQLAnywhere will show it in connection_property('name'). But if you don't set it at connection time, SQLAnywhere shows something like SQL_DBC_16544f00.

Is it safe to say that SQLAnywhere creates a complete random and unique name for each connection? Even in two different databases?

I would like to know how SQLA creates this random name. Best

[johnsmirnios]

It is just a hex representation of a pointer to an object allocated for the connection inside dblib. It is not guaranteed to be very random. In fact, two identical apps are very likely to get the same connection name. No two connections that are open at the same time and established from a single process will have the same connection name; however, the name can be reused if the app disconnects and reconnects.

[former_SQLA_member1694893]

John

Based on your answer No two connections that are open at the same time and established from a single process will have the same connection name, can two connections in the same database have identical connection names?

[johnsmirnios]

Yes, they can have the same connection names. Two connections from different apps can have the same name at the same time and, as noted in my first response, for two identical client apps it is even likely that they will have the same name.

[MarkCulp]

To clarify, it is the SA client library that generates the name for the connection (if one is not specified) and therefore it is possible for two client applications to generate the same name.