Hi,
Is there any way of getting the current ServerSession ID?
I would like to get the client session from SQL, something like this:
SELECT * FROM  Configuration.ServerSessions WHERE ID = CURRENT_SESSION_ID
From there I would like to get the Client public IP etc...



Also, The ODBC Connector is that a separate product? And where can I download it?

Thank you!

Hi Hoken

It would be really useful to have a Current_SessionID variable. I do not think such a thing exists, others might correct me.

There is a useful system table "LogEvents" which contains SessionIDs, and lists some other data, and contains a "Process" and "User" column which you may be able to return locally.

SELECT SessionID
FROM LogEvents

WHERE Process LIKE '%<add machine name here>%'

or

WHERE User = '<add user name>'

--

In terms of adding the ODBC support, I pay for the EDB VCL licence. On the "Downloads" page of the EDB website I see an entry for "EDB-DAC-CS - ElevateDB DAC Client-Server", clicking on this gives access to buying / updating. Once you have paid you can download the executable which installs EDB ODBC connectivity.

It is not immediately obvious from the EDB website how to directly buy this product though any other link I can see.

On 4/17/2018 7:45 AM, Adam Brett wrote:
>
> It is not immediately obvious from the EDB website how to directly buy this product though any other link I can see.
>

ODBC is under the "visual studio" or "other developers" section of EDB
product pages (includes ODBC and .net data provider)

https://www.elevatesoft.com/products?category=edb&type=visualstudio

or

https://www.elevatesoft.com/products?category=edb&type=other


It's a full engine and not just a connector.

Raul

I will check out the LogEvents table!

I won't be needing the ODBC connector for anything serious,
I was just looking for a way to connect a SQL Query tool to help me generate SQL Queries visually

Thank you!

Hoken,

<< Is there any way of getting the current ServerSession ID?
I would like to get the client session from SQL, something like this:
SELECT * FROM  Configuration.ServerSessions WHERE ID = CURRENT_SESSION_ID
From there I would like to get the Client public IP etc... >>

I could have sworn that I added this also, but apparently not:

https://www.elevatesoft.com/manual?action=topics&id=edb2sql&section=string_functions

I will see if I can get that in there for 2.28.

<< Also, The ODBC Connector is that a separate product? And where can I download it? >>

In addition to the other answers here: for existing EDB customers, there's a CROSS cross-product special offer that you can use when purchasing the EDB DAC products in order to get a 30% discount off of the list price.

Tim Young
Elevate Software
www.elevatesoft.com