Add New Data Source for My SQL doesn't work

I have tried also installing and using the ODBC driver version 3.51 and the My SQL driver 3.1.8. None of these work.

What do I have to do to add a new MY SQL data source

Michael

Answer this question

Add New Data Source for My SQL doesn't work

AAraujo
Hello Michael,

Can you provide any more information

Perhaps the actual error that you are seeing, and what action is causing the error.

Do you see your database in Server/Database Explorer window
JackTruneh
The .NET Framework and Visual Studio does not have native support for this data store (MySQL).

That's why you need the driver from MySQL (MySQL connector)
Dhawal Mehta
I was told by two different Microsoft employees that Visual Studio 2005 Express Edition was the right version of Visual Studio 2005 for me to use for all of my needs including access to ODBC and MySQL data. They emailed me a link with a comparison of all of the different variations and features of the different versions of Visual Studio 2005.

I am trying to remember now, but I think it included a chart with bullets or check marks and comments on each version as to which functionality was provided and while none of them actually said that ODBC or MySQL access is supported, but ... NONE of them said that the ODBC or MySQL access was not supported.

Until just now when David Sceppa the ADO.NET program manager said that the capability for accessing Access and SQL Server data is not capable of accessing data from any other source.

No other person or information provided to me at any point in this process over the last 4 months despite my asking and trying desperately to find out how to get it working ... what a waste of the last 4 months of my time.

I can not do even the most basic thing ALL of the data is in a MySQL database and tables!!

How do I get the correct tool for my work

How do I get my work (code) from the tool I am using to the correct tool

What should I be doing at this point

Michael

KooKiz

spotty wrote:
Are you sure its the enterprise edition of 2005 and not the Express edition (Beta 2) I'm sure that no Enterprise Edition has been released to the public and I'm told with the Express Edition (Beta 2)

There are other Beta 2 versions available to MSDN subscribers..he may have one of those editions.

dondragon2
Are you sure its the enterprise edition of 2005 and not the Express edition (Beta 2)

I'm sure that no Enterprise Edition has been released to the public and I'm told with the Express Edition (Beta 2) it will it limited to connectivity with SQL Server Express and Access.

"The data designers in the Express editions of Visual Studio only allow you to connect to SQL Server Express and Access (Jet) databases. You can still use the various .NET Data Providers at run-time.

David Sceppa
ADO.NET Program Manager
Microsoft "

"Remote data access features are reserved for VS Standard and above editions. The intent of the Express Editions is to design and use local data only. Visual Web Developer allows read-only access to several remote databases as a special case. This allows a Web developer to publish their site to a hoster, and continue to do testing or small iterative changes.

You can connect to remote databases and sql 2000 in code, but you won't get the enhanced design-time features this way.

PaulYuk_MS "

Seems like the to get full support for other database providers you'll have to wait for the release of the standard edition or above. Remember we are talking about the free beta here...
gregg100
I provided you with all of the information required.

I tried to use visual studio 2005 enterprise edition - visual basic and then I installed the ODBC driver 3.5.1 and then I removed it and then I installed MySQL driver 3.1.8.

No matter what I did I could never add a new data source.

This is the third time I have explained this to you.

No matter how I try to explain it to you don't seem to understand you constantly tell me install the drivers that you already know time after time after time that I have already tried and it doesn't work.

Please get someone to help who understands the language, who understands the question and understands what needs to be done to resolve this.

PLEASE PLEASE PLEASE ... DO NOT ... ask me any more questions or tell me to do what you know I have already done.

Michael
Shireesha
I am using Visual Studio 2005 Express Edition BETA 2.
Nisith Paul
Please re-read the first message that I sent!!

I have already tried first installing the ODBC driver version 3.51 and then after removing it then installing the MY SQL driver 3.18 and neither worked with Visual Studio Enterprise Edition Beta 2.

I am confused by your answer it means little to nothing to me.
ZipGenius
I am EXTREMELY confused why do you keep telling me to do what I have already done.

Perhaps my mistake is using English.

Perhaps you could have your supervisor re-read the ENGLISH postings and explain to you what they mean!!!
ProgrammingQuestion
Sir,

I have apologized if my frustration came through on being given the incorrect information over and over again.

I must also point out that I had just joined the forum and did not realize at first that it was a public forum on the Internet I thought that that it was a private Microsoft forum and I did not realize that I was getting input from different people and of course I had the impression that the same person was repeatedly giving me incorrect information and having me explain the same things all of that adding to the frustration.

At no point had any of that been explained to me as I was set up. So, I was working from a false impression of what everything is. Over time I have gotten a better understanding through experience.

I have apologized to everyone many times over.

I am just trying to get the problems resolved. Which still hasn't happened yet.

Thank you for kind, thoughtful and understanding words.

Michael
valefar
Michael,
If you are trying to add the datasource through the 'Server Explorer' then you must setup a DSN connection (user/system or machine) to utilize the driver, or get a .net 'Provider' to utilize the driver...here a few to check into:

Core Labs
EInfoDesigns
Seven Objects

If you are trying to add the datasource progmatically see the following for the proper connection string:

ODBC 3.51 Local database:

"DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=myDatabase;USER=myUsername;PASSWORD=myPassword;OPTION=3;"
(Patience and Attitude go a long way in these forums)
Roger G
Maybe I didn't explain well, even if you install the drivers, VS won't have integrated support for MySQL, you need to add a reference to the library in your project and use it "manually".
Ben Miller MSFT
Michael, I've had the same problem as you. Fortunately I managed to sort it out.
The steps:
1.     Set up your ODBC DSN in: Control Panel -> Administrative Tools -> Data Sources
        (Use the MySQL ODBC driver). Make sure it's a System DSN. I think you can leave the
        initital database/catalogue name blank (the automatic request doesn't seem to work                 anyway).
2.      In Visual Studio, click on the Server Explorer tab (same window as the Toolbox). Click         on the 'Add Conncection' icon. Click the 'Use Connection String' radio button and fill in             the DSN details manually (dsn=<dsn>; database=<database> etc (using the existing DSN
       connection strings doesn't work for me).

That should make the data source available. You can then create typed datasets and all that. You can also change the database used in the code.
Hope this helps...
JOsh
Celine
Listen buddy,
maybe if you were a bit more polite, or even less rude and got off your high horse, people would be more inclined to answer your questions...
Add New Data Source for My SQL doesn't work

Answer this question