June 24, 2022 at 11:27 am
hello,
I want to monitor the odbc connections.
In table sys.dm_exec_sessions I find all actually opened ODBC-Connections. But where I find the parameters of the ODBC-Connect-string?
For example:
An Access-Applications connects with the following parameters:
"ODBC;
Driver=SQL SERVER;
Server= BlaBla;
Database=ABC;
UserID=Hans;
Trusted_Connection=yes;
Description=Wertet Summen aus;
APP=Test.accdb"
I am looking for this parameters. Have anyone an idea, where I can find them?
Best wishes
Martina
June 24, 2022 at 1:21 pm
Check my little article to get you started:
"Logon monitoring in SQL Server and Azure Managed Instances - Adopting Extended Events"
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
June 24, 2022 at 1:46 pm
In windows, you'd use ODBC Data Sources or ODBC Administrator (32 bit or 64 bit).
System ODBC data sources are stored in HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC. INI .
User ODBC data sources are stored in HKEY_CURRENT_USER\Software\ODBC\ODBC
File DSN data sources should be stored in a text file with a .DSN extension in Program Files\Common Files\Odbc\Data Sources folder.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply