How can we help you today?

Start a new topic
Discussions DbVisualizer Forums Support

Is there a way to identify where the error occurs in a query?

[This topic is migrated from our old forums. The original author name has been removed]

Hi, I would like to know if there is setting that needs to be enabled in order to easily identify where the error occurs in a T-SQL statement. Comparing with MSSMS query tool, it tells you the line number where the error occurs. I wonder if DBVis tool has that capability built-in. I am running on version 8.0.3. Thank you. Log from DBVis: [Error Code: 207, SQL State: 42S22] Invalid column name 'orderevent_intit'. Log from MSSMS: Msg 207, Level 16, State 1, Line 13 Invalid column name 'orderevent_intit'.
1 Comment
[This reply is migrated from our old forums.]

Re: Is there a way to identify where the error occurs in a query?
Hi, The information provided by the JDBC related to the actual position of an error is missing in most JDBC drivers including the ones for SQL Server. The reason you see the information in other tools is probably because these are using non Java APIs to communicate with the database server. Regards Roger
Comments to this discussion are now closed!
More topics in Support
See all 1297 topics