May 13, 2014 at 12:12 am
Hi,
I have an Excel VBA ( developed by someone else ) that establishing a connection to SQL Server using ConnectionObject and Recordset, is it possible to know what SQL statement the Excel VBA sending and from SQL Profiler, what SQL statement that has been received ?
I tried debug mode, step through the code in Excel VBA and noticed that the SQLStatement for the Recordset are just
"TAG:R, some value, some value, some value"
Those "some value" are input parameter from front end.
I checked the connection object string, and I can see which database being selected. I checked SQL Server database, I can't find any corresponding table name, view, store procedure named this way.
Basically, I tried most of the options in the SQL Profiler but not able to pin point exactly what type of Event / Columns I should be looking at. So I can start to troubleshoot again.
If you can offer some advice, it will be great. Thanks ...
May 13, 2014 at 12:25 am
Check out this article:
Use SQL Server Profiler to trace database calls from third party applications[/url]
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 13, 2014 at 12:50 am
Thanks Koen. I tested it but can't find anything related to the TAG:R in the profiler.
Another verification on Excel, no worksheet named TAG. Let me dig out some Excel VBA recordset documentation related to this.
Pretty strange ... as I thought the SQL syntax should be straight forward and can be viewed.
May 13, 2014 at 12:53 am
You should be able to view the SQL statement in profiler. Or at least find a stored procedure.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply