Have Geek Brain

Using MySql Stored Procedures for the .NET Access Access Layer

I am using .NET 2.0 and / or 3.5. What's strange is that every time I add a query, whether via a TableAdapter or a simple query on a dataset using a MySQL stored procedure (be it select, update, insert, delete), the wizard doesn't finish (the dialog suddenly disappears, I'll be back in designer and the request is not added to the tableadapter or dataset form). Is there any special formatting required for MySQL stored procedures, or a workaround for MySQL stored procedures to work?

I am using MySQL 5.1.33 portable XAMPP 1.7.1 PHP 5.2.9 Apache 2.2.11 phpMyAdmin 3.1.3.1

+1


a source to share


1 answer


The same thing happened to me. The fix for me was this: one of my parameters for the stored procedure was "filter". I changed it to "p_filter" and the problem went away. The problem I'm still running into is in the last screen of the filter I get:

you have an error in your sql syntax; check the manual corresponding to the mysql server version for the correct syntax to use next to "NULL" on line 1



I have provided a stored procedure that takes no parameter, and I have no problem creating the TableAdapter using the dataset wizard.

0


a source






More articles:


All Articles