Excel Connection to SQL 2007 can't find stored procedure message

  • Thread starter SaveTheMonarchButterflies
  • Start date
S

SaveTheMonarchButterflies

Have I posted this in the correct group?

I have a stored procedure (named MyProcedure in this example )that runs, a
connection in Excel that is set up according to the help files. When I click
the refresh button I get this message:

[Microsoft] ODBC SQLServerDriver [SQL Server] could not find stored
procedure 'MyProcedure'

When I click OK, it goes ahead and runs finds and runs the stored procedure
, and returns the correct data. I'd like to have my users avoid this message
if possible. Can anyone suggest why I'm getting it and how to avoid it?
Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL Stored Procedure 1
Data return from SQL Stored procedure... 0
How to store a connection with parameters into a workbook 0
Run a SQL Stored Procedure from VBA 0
SQL Server Stored Procedure timeout 3
how to code a button to export results of stored procedure to excel file 0
Excel / Sql Server / Pivot Tables 2
Access can't find stored procedure after scripting on sql server 2

Top