Data Sources Error - Could not find stored procedure - why?

[PhillipBathUK]

I am using CS5, Windows 7 Professional and SQL Server Express 2008.  I have migrated from Dreamweaver MX2004, Windows XP Professional and SQL EXpress 2005 so i have been familiar with working with stored procedures and calling them as a Command in Dreamweaver.  However, i now have a problem with my new setup. When i create a stored procedure in SQL Express that has a Select statement and i then create a command in Dreamweaver and tick the box 'Return recordset named' I can click on the 'Test' button and the procedure returns the expected recordset.  However when i try and put the result in a web page by clicking on the Bindings panel and expand the command i get a box that pops up and says 'Cound not find stored procedure ...'

I have tried different connection strings without success and as far as i can see all other dynamic actions work as expected - e.g creating recordsets and returning results with repeat regions.  Even a stored procedure that executes for example an update on the database works.

Any help would be much appreciated.

[ultrasuite]

There can be many different reasons for this eror message.  When you drag a field from the Bindings tab into your document what code does it insert?

[PhillipBathUK]

Thanks, I don't get to insert any code by dragging as it is when i click on the  '+' to the left of the command in the Bindings Panel i get the pop up box message so i don't get to see the fields to drag ....but if i double click the command it opens and functions as expected - i.e. i can click the Test button and the expected recordset result is returned.

Your reply prompted me to try  hand code the field in the page and fortunately that works fine. So the problem appears to be the WYSWYG side of CS5

[David_Powers]

I have moved this thread to the Dreamweaver Application Development forum, which is more appropriate for server-side issues.

I don't use ASP, but I have a strong recollection that changes made to the code in Dreamweaver 8 broke something connected with using ASP commands. Many people reported it as a bug, but it was never fixed. You might find the answer by searching this forum. After clicking Search Forum at the top right of the screen, click More Options to restrict your search to the Dreamweaver Application Development forum.

[PhillipBathUK]

Thanks - will follow it up in the suggested forum

[ultrasuite]

If you are satisfied with hand coding then it's fine.  Otherwise, could you post an image of the "pop-up box" (I am guessing you mean, dialog box) that you see when you click on +.  It's not out of the question that one of DW config files got corrupted.

J.S.
http://www.ultrasuite.com/
http://twitter.com/dwUltraSuite

[PhillipBathUK]

I have tried deleting the .dat file and the whole configuration folder. On first encountering this problem i thought i was going to be really stuck but as it works Its no big deal hand coding the fields.

This is the dialogue box:

[TheDarkNupe]

Hello All

I have found a fix for this problem...

First let me say that after reading through tons of web forums it does appear as if this problem started show up in Dreaweaver CS3. Being as it is still around, I think that is safe to say that Adobe has no plans to fix it.   At some point they were even thinking of pulling ASP classic out of Dreamweaver.  I am glad that they didn’t go that far.

Any way here is your answer.

If you need to call a stored procedure and return records, simply create a recordset in Dreamweaver and use the Advanced button.  In side the SQL box just put exec [NameOfStoredProc] [Parameter1] [Paremeter2And so on].

See the example that I have here

To pass your parameters in just use the parameters box.  You can find a ton of information on the advanced tab of recordsets online. So I don’t have to go any deeper.

If you look at the code that gets generated, it is exactly the same as what you would use if you chose the command option in Dreamweaver.

Hope this helps!!!!

[David_Powers]

TheDarkNupe wrote:

At some point they were even thinking of pulling ASP classic out of Dreamweaver.  I am glad that they didn’t go that far.

It hasn't been pulled yet, but it will be soon. Not only Classic ASP, but all server behaviors (PHP & ColdFusion) will be removed from the next version of Dreamweaver. They will still be available to install as an extension, but the message is clear: Adobe no longer recommends their use.