Hi All,
I have to be something wrong because I can't seem to find anybody else in the world who has this problem.
Here's My setup:
My PC - Windows 7, Visual Studio 2010 and .Net 4, MySQL 5.5, MySQL .Net Connector v6.4.4. I'm writing this app using VB.Net.
Everything here is current, including service packs, etc AFAIK.
Here's my dilemma:
I have an ActiveX control (that is required) that cannot be compiled and executed in .Net 4 framework using VS2010. However, it WILL run perfectly if I compile my program using the .Net 3.5 framework.
Simple enough. It took me hours and hours to figure that out.
The problem now? For some reason when I compile VS2010 for the .Net 3.5 framework, I can't import ANY MySQL DLL references into my app to use it. If I go to browse to where the DLLs are located to add them - I get an error message that says these DLLs belong to .Net 4.
Of course, if I compile using .net 4 - all the MySQL DLLs are there for me to reference. But now my REQUIRED ActiveX control won't work.
I'm still scratching my head because I never thought I'd have a problem compiling MySQL/Connector and it not working in .Net 3.5.
If I open up Server Explorer - I can connect to the database, to use Server Explorer to see the tables, modify tables, search, etc. It's just that I can't use IMPORTS to programmatically add my namespaces, etc.
Does anybody have any suggestions? I have to be missing a step or else I need to install different versions of MySQL or MySQL Connector/Net.
Submit an article or tip