Skip to main content
P
PhillipBathUK
Participant
December 16, 2010
Question

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

  • December 16, 2010
  • 1 reply
  • 1767 views

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.

This topic has been closed for replies.

1 reply

ultrasuite
ultrasuite
Inspiring
December 16, 2010

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?

P
PhillipBathUKAuthor
Participant
December 17, 2010

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
David_Powers
Inspiring
December 17, 2010

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.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices