What does VB Error mean

[ifntech]

The statement below errors out, says exception was not caught by the user. Any ideas what it could be?
Thanks.
...
Finally
' If the connection object is valid then close the connection
If conn IsNot Nothing Then
conn.Close()
End If

End Try
...

 

[ifntech]

...
Catch SqlEx As SqlException

...
This statement was before the expression. It might help.

 

[TipGiver]

The logic should be : (in order no to have redurdant code)

' dim here a connection
try
' create here a new instance of the connection
' open connection
' do your stuff
' close the connection
catch ex as {specific exception type}
' handle it
catch ex as exception
' handle it
finally
' this code will be executed whether or not there was exception
' dispose the connectionn (if method exists!)
' set the connect to nothing
end try

 

[ifntech]

Thanks. Another tip that I get from compiler about the same error in the file where it errors out that statement, is that the "usp_filename has no parameters and arguments". The usp_filename is related to the file that errors, but I cannot seem to find the relationship. Are there any tips you can give me on what could be the cause of error?

 

[jbenson001]

You are trying to call a stored procedure that expects parameters. You will have to find out what the paramaters are and the datatypes of each