Skip navigation
NJPhillips
Currently Being Moderated

[Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'dbo.sp_SPNAMEHERE'.

Apr 15, 2011 10:29 AM

OK, something seemed to have changed with my system because this error is NEW. It might be related to my system upgrade from Vista to Win7, but just guessing here.

 

I run a database on a corporate MS Sql Server (2005) and an ASP application that connects via ODBC. The real world application works fine, however when I attempt to access Stored Procedures from Dreamweaver (on my development machine)  I am getting the following error:

 

[Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'dbo.sp_SPNAMEHERE'.

 

This only seems to happen on Stored procedures that RETURN a recordset.

 

system:

Win7

Dreamweaver CS4

Code: VBScript/Classic ASP

SQL Server 2005

Connecting via ODBC: MM_MY_STRING = "Driver={SQL Server};Server=wscxxxxxxxxx;Database=dbsystem;Uid=username;Pwd=XXXXXX XXXXXX"

 

Stored procedures that do not return a recordset are not an issue.... this has put my development work at a standstill!!

 

Thanks in advance!

 
Replies
  • Currently Being Moderated
    Apr 28, 2011 4:31 PM   in reply to NJPhillips

    I am  having this exact same issue. Did you ever get a response?

     
    |
    Mark as:
  • Currently Being Moderated
    Apr 4, 2013 10:16 AM   in reply to NJPhillips

    We need to see all of the code in order to help. What version of DW?

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points