MySQL Stored Procedure from ASP page
bbcompent1 | Posted 11:32am 25. February 2010 Server Time |
Hey folks, I'm having a devil of a time trying to figure out if my syntax is right or not. In a given ASP page, I have it calling the database to execute a SP. My code is as follows:
<!-- #include file="conn.asp" -->
<%
SQLStmt = "call parsedata();"
conn.execute(SQLStmt)
%>
If I point at the wrong DB, it lets me know by showing this:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 5.1 Driver][mysqld-5.0.51a-5]PROCEDURE eg_prototype.parsedata does not exist
/datapost.asp, line 4
What gives??? |
|
|
