jwcolby
jwcolby at colbyconsulting.com
Tue Jul 24 12:35:56 CDT 2007
I am trying to execute queries that build databases, build tables etc. When I executed the ExecuteNonQuery method with a query that built a database and the database already exists, I got an error returned of -2147217900. When I tried to execute a sql statement with a general error I got the same error returned. How do I get meaningful error codes back from ExecuteNonQuery? Try mobjCmd.ExecuteNonQuery() Catch ex As OleDbException Select Case ex.ErrorCode Case -2147217900 'database already exists so ignore the error Case Else MessageBox.Show(ex.Message) Return -3 End Select End Try John W. Colby Colby Consulting www.ColbyConsulting.com