Add New Data Source for My SQL doesn't work

Add New Data Source for My SQL doesn't work

• Alice Kupcik

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

• Seeking VSTO

  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
  
  

• tonyb291

  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)

  
  
  

• danielches

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

• X_Kerrigan

  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.
  
  

• LukeMouthbreather

  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
  
  

• Usha Pini

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

   

  
  

• Mike Danes

  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.
  
  

• Pankaj Lakhina

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

• Jason Stowe

  I am using Visual Studio 2005 Express Edition BETA 2.
  
  

• Kenny Kerr

  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)
  
  

• Tom Couvret

  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
  
  

• Allen Alper

  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
  
  
  
  
  
  
  

• Larry Bynum - msft

  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
  
  
• Add New Data Source for My SQL doesn't work