Ola Tinoco-Ekdahl wrote:
Try using a native driver, http://www.google.com/search?q=MySQL+Native+%2ENET+Provider.
What sort of problems do you run into?
--ola
-----Original Message----- From: Unmoderated discussion of advanced .NET topics. [mailto:[EMAIL PROTECTED] On Behalf Of Muhammad Adel Sent: Wednesday, January 12, 2005 6:27 PM To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM Subject: [ADVANCED-DOTNET] previous experience with using MySql with .NET
I am trying to use mysql data base in an ASP.NET application, but I am having problems with queries, and data adapters. I tried to use myodbc 3.5 and myoledb 3.5, both give a different type of problems. I searched the web and I found that generally using mySQL with .NET makes lots of problems, so I just need to know if any one has used mySql database in .NET before and if he had problems with the mysql data providers. thanks
=================================== This list is hosted by DevelopMentor(r) http://www.develop.com
View archives and manage your subscription(s) at http://discuss.develop.com
=================================== This list is hosted by DevelopMentorŪ http://www.develop.com
View archives and manage your subscription(s) at http://discuss.develop.com
Thanks for your answer and thanks for all other answers. Most of the problems I am facing now are designer related problems (problems in connecting to data base through server explorer and so on).. I found that when trying to write the code manually, things are working fine - till now :-\ The project is at its start. The problems that were found on the web were various and the cause was anlayzed by a guy working at Microsoft. the reason for most of problems was the use of myODBC 3.5 which supports ASCII queries only, while .NET sends queries in Unicode. .NET can handle this and send queries in ASCII but the myODBC should report that it uses ASCII, but it doe snot. Unfortunately we cannot buy a native provider as the projects budget is very small, so I am writing the code without the aid of the designer, and I am trying to get myODBC 2.5, but it is not found on the web or mySQL's site, only version 3.51 is available.
=================================== This list is hosted by DevelopMentorŪ http://www.develop.com
View archives and manage your subscription(s) at http://discuss.develop.com
