June 20, 2008 at 8:27 am
Hi,
is it possible to view (in a transaction log) transactions made through an ODBC connection? Here's an example"
An MS Access user links to database tables in SQL 2000 using an ODBC connection.
Is it possible to view or see this activity by viewing the transaction log?
Thank you!
June 20, 2008 at 9:22 am
Check which protocol the ODBC connection uses.. in their DSN.
Double click on their DSN and goto the screen that has the "Client Configuration" button/link click on it to see what protocol is configured..
then in Master.dbo.sysprocesses see the net_library column for NETBOIS with named pipes as their connection source...
Or try to Tun a profiler trace with filter on their hostname or loginname...
Let me know if you understand what i mean...
Maninder
www.dbanation.com
June 20, 2008 at 9:56 am
The connection protocol is TCP/IP. When looking in the sysprocesses table (in Master db), I don't see NETBIOS listed. The two options shown in the net_library column are TCP/IP and LPC. I see some of our (database) applications listed (in program name column), along with:
MS SQLEM - Data Tools
SQLAgent - Alert Engine
SQLAgent - Generic Refresher
MS SQLEM
(you wrote:)
Check which protocol the ODBC connection uses.. in their DSN.
Double click on their DSN and goto the screen that has the "Client Configuration" button/link click on it to see what protocol is configured..
then in Master.dbo.sysprocesses see the net_library column for NETBOIS with named pipes as their connection source...
Or try to Tun a profiler trace with filter on their hostname or loginname...
-------------------------------------------
June 25, 2008 at 7:39 am
Any more thoughts on this guys? Not sure I know how to do this.
I tried the trace...
June 25, 2008 at 8:22 am
check this out:
ODBC Connection Pooling Counters in Performance Monitor and ADO
http://support.microsoft.com/kb/q245543/
Maninder
www.dbanation.com
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply