Thread: .NET Question

  1. #1
    Registered User
    Join Date
    Feb 2003
    Posts
    184

    .NET Question

    Hello everyone,

    Got a question of course. This question is more focused on Visual Studio .NET. Although, I am trying to use C#. I am trying to work with a MYSQL database with .NET and am having some problems using the data tools provided. There is a SQLDataAdapter and a OLEDBDataAdapter. I cannot use SQLDataAdapter because it is for Microsoft SQL Server. When I try to use the OLEDBDataAdapter wizard and use the following settings:

    ->NewConnection
    ->Under Provider Tab
    ->OLEDB for ODBC Drivers
    ->Click Next
    ->I then select the DSN representing the MYSQL Database and click Test Connection. It makes a connection fine, but when I click OK, it tells me "The connection you have created does not work with the current adapter."

    Does the Data Tools provided with .NET not work with MYSQL????
    How would I get MYSQL to work with C#, other than using the ODBC API directly???????

    Thanks,
    Kendal

  2. #2
    &TH of undefined behavior Fordy's Avatar
    Join Date
    Aug 2001
    Posts
    5,793
    I believe MySQL offers some oledb tools - here

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. .NET Windows Application Question
    By obaid in forum C# Programming
    Replies: 1
    Last Post: 04-29-2008, 10:32 PM
  2. migrate from .Net 2.0 to .Net 3.0
    By George2 in forum C# Programming
    Replies: 3
    Last Post: 07-25-2007, 04:07 AM
  3. MSVC++ .NET 2005 Express Question
    By cboard_member in forum Windows Programming
    Replies: 1
    Last Post: 12-08-2005, 08:04 AM
  4. extremely basic .net question
    By Ripper1 in forum C++ Programming
    Replies: 7
    Last Post: 05-25-2003, 03:56 PM
  5. VS .NET & XP Pro Question
    By hk_mp5kpdw in forum A Brief History of Cprogramming.com
    Replies: 4
    Last Post: 01-08-2003, 01:07 PM