I am on Chapter 7: Implementing Group Queries. I completed steps 1-8 (pages 162-167. However, when I run the app I get the following message: Object Variable or With Block Variable not Set. I ran the same code from the download and I did not get the error. I compared the two sets of code and could not see a difference. I know that the error occurs after running DALBase FillDataSet procedure. It runs the InitializeCommand, InitializeDataAdapter, DataAdapter.Fill(oDataSet, TableName)then the Finally section: command.dispose, command = nothing, dataadapter.dispose and dataadapter = nothing. Then the system goes right to the Exception Error in the LoadGroups procedure. What am I doing wrong?

I can't think of anything right off hand that might be causing the problem. Set a breakpoint on the line of code that fills the dataset and when it returns query the dataset to ensure that it has rows of data in it.

Thearon

I did as you suggested. I set up a Watch window on DataAdapter.Fill(oData,TableName). The result it returned was 1 (which was good as I had one record in the table). Then when I went to the next command Command.Dispose(), the value on the DataAdapter.Fill changed to:Run-time exception thrown : System.InvalidOperationException
 - Fill: SelectCommand.Connection property has not been initialized.
Now what do I do?

What you're saying isn't making much sense to me. However, set a break point on the first line of code in the OpenConnection procedure in the DALBase class to ensure that code is getting executed.

The other suggestion that I have for you is to use some tool to compare the DALBase class from your project to the one you downloaded to see if you can find the differences between them.

Thearon

Ok, I stepped through the code starting at LoadGroups(). I noticed that when I ran the book code the connection opened during the Sub New procedure, once the variable "connection" was set. When I run my code the connection doesn't open during Sub New. When I look at the details of the variable connection in the watch window, the only property difference was the ServerVersion. Yours has an entry for 4.something and my had an entry of
[u]ServerVersion <error: an exception of type: {System.InvalidOperationException} occurred> String</u>
... and the connection never opens. I am going to call the procedure OpenConnection and see what happens. What think ye?

Are you connecting to SQL Server or Oracle? Post you connection string here (with xxx as the password) so I can have a look at it.

Thearon