I am getting this ODBC error in webplus applicatio

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

I am getting this ODBC error in webplus applicatio

Author

Topic

mavericky
Posting Yak Master

117 Posts

Posted - 2011-09-19 : 09:38:15

Hi,
Can anyone help me?
I get this error:
Error(s) Encountered While Processing Your Request
Web+ Error Message:
Error Code = 10023: ODBC statement execution error. Occurred in WebDbQuery around line(33) in the specified script file

Explanation:
Web+ can not correctly execute the ODBC statement.. [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'usp_APPL_GetColorPrice'.

Troubleshooting Information
Verify that the syntax of your SQL statement is correct.

Thanks in anticipation.

Mavericky

mfemenel
Professor Frink

1421 Posts

Posted - 2011-09-19 : 11:23:43

verify the proc name is correct in your query and spelling matches exactly with the database. Also verify the schema in which the proc exists. You may need to call it with the schema name, like: schemaname.procname

Mike
"oh, that monkey is going to pay"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources