Error when opening stored procedure

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
LarryEvilsizer
Posts: 4
Joined: Fri 24 Feb 2006 00:13

Error when opening stored procedure

Post by LarryEvilsizer » Mon 13 Mar 2006 20:50

Hi,

I'm trying to test my stored procedures. I have connected to my database with a TMyConnection component. I add a TStoredProc component linked to my TMyConnection component and have selected a stored procedure from the StoredProcName list selection. When I set active to TRUE, I get an error:
#42000PROCEDURE does not exist.

I'm assuming I'm doing something wrong, but haven't a clue what it is. Any help would be greatly appreciated.

Thanks,
Larry

Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Tue 14 Mar 2006 12:36

Unfortunately we couldn't reproduce the problem.
Please send us (mydac*crlab*com) script to create stored procedure you try to execute. Also supply us following information:
- Exact version of Delphi, C++ Builder or Kylix
- Exact version of MyDAC. You can see it in About sheet of TMyConnection Editor
- Exact version of MySQL server and MySQL client. You can see it in Info sheet of TMyConnection Editor

Post Reply