Thanks. You were right. I had a different version of libmySQL.dll in winnt\system32 from all the others. About eInfoDesigns dbProvider I found two weird things: 1- unlike all the others providers MySqlDataAdapter constructor doesn't accept parameters; 2- when
inserting a backslash(\) it doesn't escape it (it's not a default but it would help :-) ) (is there any convenient about using libmySQL.dll besides DLL h*ll? )
Another thing, as I've tried both providers, I've encountered a lot of really weird things from them. Anyway, they are just minors and can be easily solved or figured out. I'm developing a Job Search engine that will finally be powered by .NET and MySQL. Guess
I'll just ask my employer to buy me licensed copies of these providers. We can't afford Microsoft SQL Server 2000. It's a fortune.
Has any one used this Driver and could tell how it compares to the ODBC providers listed on this thread? http://sourceforge.net/projects/mysqldrivercs/ Thanks.
Any native .net data provider is going to be faster than using ODBC.. becacuse there is direct database interaction. (how well it's implemented, is always another story). I've never seen the provider you're talking about... I'm going to take a peek though.
Derek
Can you guys please review the provider listed 2 posts above and give me feedback on it in this post: 133627. I'd like to add MySql support to my components, but I am unsure which provider to use (I have to include the provider in the control for it to work).
Thanks!
I've been testing all the providers I've been able to get my hands on over the past few months. I'll be more than happy to report on what I've found. I should have time to compile something by the end of the week. Derek :)
Robert, just my $0.02 worth.... SWSoft OleDB engine - OK but not supported anymore (and I have problems with the COUNT() function in ASP.Net but not under ASP) MySQLDriverCS engine - OK but I see a major memory leak (approx 200k per database query/update/etc)
but COUNT() works so I have to just restart the web service every few hours instead :-( ODBC.Net - never tried since I'm using MySQL and don't need a generic way of talking to the database Hope this helps (?)
fetcher
Member
635 Points
127 Posts
Re: The best MySql provider for .NET I've seen so far
Jan 13, 2003 09:13 PM|LINK
torvix2000
Member
150 Points
30 Posts
Re: The best MySql provider for .NET I've seen so far
Jan 14, 2003 02:10 AM|LINK
gigadev
Member
5 Points
1 Post
Re: The best MySql provider for .NET I've seen so far
Jan 27, 2003 09:27 PM|LINK
dgabriel
Member
75 Points
15 Posts
Re: The best MySql provider for .NET I've seen so far
Jan 28, 2003 01:18 AM|LINK
interscape
Member
460 Points
96 Posts
Re: The best MySql provider for .NET I've seen so far
Jan 28, 2003 04:37 PM|LINK
dgabriel
Member
75 Points
15 Posts
Re: The best MySql provider for .NET I've seen so far
Jan 28, 2003 07:40 PM|LINK
interscape
Member
460 Points
96 Posts
Re: The best MySql provider for .NET I've seen so far
Jan 28, 2003 08:25 PM|LINK
interscape
Member
460 Points
96 Posts
Re: The best MySql provider for .NET I've seen so far
Feb 03, 2003 10:14 PM|LINK
dgabriel
Member
75 Points
15 Posts
Re: The best MySql provider for .NET I've seen so far
Feb 04, 2003 01:20 AM|LINK
bumbling foo...
Member
210 Points
42 Posts
Re: The best MySql provider for .NET I've seen so far
Feb 06, 2003 10:59 PM|LINK