Getting null reference when trying to run SP

hey all.

I have just d/l and installed subsonic. I have a DB all setup with stored procedures. I have generated all the subsonic code and changed my webconfig file.

Now, when I try to run a SP from my DB, I get the error:

        (NullReferenceException was unhandled by user code)

The only line I have in my webpage is:

     Dim ds As DataSet = Alpine.SPs.AlpineSpBookingGetCollection().GetDataSet()

And this SP just basically does a select * from table. There are rows on the table.

Any ideas why I would get this error? The SP works fine with my normal code..but not with the subsonic stuff Ive only just d/l'd.

Cheers.

Try creating a an instance of the SP first:

Dim sp As SubSonic.StoredProcedure

sp = Alpine.SPs.AlpineSpBookingGetCollection()

dim ds as DataSet = sp.GetDataSet()

 ok thanks ill try this when i get to work in the morning...

the tutorial for it though didnt code like this!

I still get the same error, when it runs the last line

         "dim ds as dataset = sp.getdataset()"

I have a few stored procedures in my solutions and dont have problems with them. Without seeing your SP, the standout difference is that my stored procedures all have at least one parameter. I guess it could be a bug that gets found out when you have an SP without parameters, but I would have expected to have seen it reported before now.

 You might want to have a look at this http://www.geekzone.co.nz/JamesHip/5742

 invalid link?

The link works for me,
Basically, he talks about Subsonic having a bug where it cant instatiate SPs that dont have any parameters and suggests a workaround is to add a dummy parameter.

Recent post of a solution to the issue.

http://www.jasonstiefer.com/blog/post/2008/11/SubSonic-with-Stored-Procs.aspx