Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Connection to SQL 2007 can't find stored procedure message
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data return from SQL Stored procedure... | Excel Discussion (Misc queries) | |||
hyperlink, macro, stored procedure? | Excel Worksheet Functions | |||
How can Oracle DB Stored procedure be called in MS Excel? | Excel Discussion (Misc queries) | |||
Extract data from Stored procedure | Excel Discussion (Misc queries) | |||
execute stored procedure from excel | Excel Worksheet Functions |