Add New Data Source for My SQL doesn't work

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.

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!!!

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

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:

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...

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

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