Hi All,
I'm using ASP.NET to connect to MySql via the .NET connector ver 1.0.7. It seems to use the .NET connector with stored procedures, you require READ privileges on the mysql.proc table.
Now I read through the forums and someone said we should use the ODBC connector saying it's more stable, etc.
Well I tried that and the ODBC connector *does not* support stored procedures. So I'm stuck. Has anybody solved this problem? I assume someone must have tried using SP's (stored procs) from .NET?

Waiting patiently...

Could you provide a small and simple code example on how to connect to an mysql database using the .NET connector ver 1.0.7?

Thanks,
Gypsy

Keep in mind that with MySQL's current implementation of "Stored Procedures" you won't see any performance gain because they're never compiled. And the support for Sprocs is half baked, kludgey, and inconsistent at best. My advice (from experience w/ MySQL Sprocs) is steer clear... if you need features like sprocs you should be using something else.

Hello,

Once I had hostmysite create a specific DSN for me, I was able to connect using ASP.NET 2.0 techniques.

I'm doing really basic stuff with the tables, simple inserts, updates and deletes. Nothing too fancy so I won't need stored procedures.

Thanks,
Gypsy