Is it possible to retrieve the line number from an OleDbException caused by calling ExecuteNonQuery()?
We are calling ExecuteNonQuery on all files in a certain folder for version scripting and if there is a syntax error an exception is raised. I have been scanning MSDN for a way to get the line number but haven't been able to find an开发者_开发问答ything yet. There is a 'SqlException' class which does contain the line number but the shared base class 'DbException' does not contain this member.
Use the SqlConnection
, SqlCommand
classes rather than OleDbConnection
, OleDbCommand
classes when accessing SQL Server.
精彩评论