![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 5 of 5 total |
![]() |
Tue, Apr 17 2018 7:16 AM | Permanent Link |
Hoken | 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! |
Tue, Apr 17 2018 7:45 AM | Permanent Link |
Adam Brett Orixa Systems | 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. |
Tue, Apr 17 2018 8:59 AM | Permanent Link |
Raul ![]() | 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 |
Tue, Apr 17 2018 10:04 AM | Permanent Link |
Hoken | 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! |
Wed, Apr 18 2018 2:02 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | 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§ion=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 |
This web page was last updated on Wednesday, August 14, 2024 at 07:31 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |