Fred,
>I'm still having some problems. Is there an error object that I can look at to see
> the exact error?
As Kamal mentioned, you can use Try and Catch to catch errors, but in this case the IDE itself will help you out and combine that with a little dumb luck (in my case) and you're all set.
Basically, the IDE showed a blue squiggly under goView and the tooltip told me it variable wasn't declared. So, I put my cursor over the SQLExecute() function, which told me what type of variable the function returned ("System.Data.DataView"). So, I knew to do
Dim goView As Data.DataView
Since I have
Imports System.Data
in my class, I could just leave off the "Data." in the DIM statement.
For oConn, there is no error if you have the following Imports statement:
Imports System.Data.OleDb
If you don't included the Imports then the DIM needs to be:
Dim oConn As OleDb.OleDbConnection
The way I figured that last one out was again using the tooltip over the SqlDisConnect(oConn) statement to see what sort of parameter SqlDisConnect() was expecting.
HTH