I've just upgraded to 20080109 release, and refresh my project, it cannot retrieve parameters information of all stored procedures in my database (SQL2005), all the existed parameters are removed after refreshing.

Please check the following relevant thread: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=12229

Walaa wrote:

Please check the following relevant thread: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=12229

That's the 01092008 build.

I'll check it out.

(edit) it works on sqlserver 2000 and 2005 Very odd. I can't reproduce it. When you refresh, the driver does mention the version 2.5.01042008 in the right bottom corner of the connection information dialog?

Do you get any errors logged in the Application Output window ?

Yes, it's v2.5.01042008. No errors in output window. I've over 200 sp in my database, only a few of them can retrieve their parameters.

I rollback to 12162007 build, the driver version is v2.5.08162007, it can retrieves parameters of all my sp.

Barry wrote:

Yes, it's v2.5.01042008. No errors in output window. I've over 200 sp in my database, only a few of them can retrieve their parameters.

I rollback to 12162007 build, the driver version is v2.5.08162007, it can retrieves parameters of all my sp.

Are these procs in different schemas? e.g. the procs which are retrievable, are these in a separate schema? Did you select the procs manually in the designer?

They are in the same schema, all are under "dbo". What do you mean of selecting the procs manually?

I've some procs in my project which were added by right clicking "Action Stored Procedure Calls", "Add Stored Procedure Calls". They are already existed in project before I upgraded to 01092008 build.

Barry wrote:

They are in the same schema, all are under "dbo". What do you mean of selecting the procs manually?

You can enable a preference which allows you to select the procs from a list which ones to retrieve from the db.

I'll re-check with a schema with dbo procs on sqlserver 2005. (edit) works fine...

I've some procs in my project which were added by right clicking "Action Stored Procedure Calls", "Add Stored Procedure Calls". They are already existed in project before I upgraded to 01092008 build.

Those procs were retrieved correctly, the rest not in the project weren't retrieved correctly?

The code hasn't been changed a lot, it's now just doing the retrieval in batches instead of in 1 batch. The actual logic which retrieves the parameters is the same...

(edit) I'll re-review the code.

I couldn't reproduce it. So I moved an old CMS schema with 241 stored procs to sqlserver 2005 from sqlserver 2000 and then I could reproduce it: retrieval procs have the parameters, action procs apparently don't. (as far as I can see it). (the same schema worked fine on 2000, hence I couldn't reproduce it earlier)

Will check it out now.

I've checked the preference, the option ManualSelectSProcsFromSchema is disabled.

I rollback to 12162007 build, and add all procs (retrieval and action) to project, then upgrade to new build and refresh. The same result as before, and some action procs still can retrieve their parameters, but most of them cannot.

I found it. I'll attach the new build to this post. You can use it in the designer build you have now. Still odd that it did work on sqlserver 2000 though, it was an indexing issue in the list of procs.

The new driver works fine, it can retrieves the parameters now, thanks!!!

Barry wrote:

The new driver works fine, it can retrieves the parameters now, thanks!!!

Thanks Barry.