How to use odbc.net and MySQL database

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Ook
    #1

    How to use odbc.net and MySQL database

    I'm missing something here. I've installed odbc.net. I've installed the
    latest dotnet SDK. I'm following the walkthrough in the msdn to create an
    asp.net c# app. I get to the point where I put the sqlDataAdapter on the
    component1.cs, but I'm not sure how to configure it. Selecting the MS OLE DB
    Provider for ODBC Drivers, and selecting my MySQL DSN passes the "Test
    Connection" test, but if I try to save it I get "The connection you have
    created does not work with the current adapter". The same DSN works fine,
    it's not the DSN, it's what I'm trying to do in C# that isn't working.

    What am I missing? I'm not quite sure how to use odbc.net to connect to the
    MySQL DSN.


    Tags: None
    • MP
      #2
      Re: How to use odbc.net and MySQL database

      I'm not sure but beter try with:

      -> odbcDataAdapter

      NOT sqlDataAdapter

      MP
      "Ook" <usenet@nospam@ emberts.com> wrote in message
      news:O$46AipXDH A.2392@TK2MSFTN GP10.phx.gbl...[color=blue]
      > I'm missing something here. I've installed odbc.net. I've installed the
      > latest dotnet SDK. I'm following the walkthrough in the msdn to create an
      > asp.net c# app. I get to the point where I put the sqlDataAdapter on the
      > component1.cs, but I'm not sure how to configure it. Selecting the MS OLE[/color]
      DB[color=blue]
      > Provider for ODBC Drivers, and selecting my MySQL DSN passes the "Test
      > Connection" test, but if I try to save it I get "The connection you have
      > created does not work with the current adapter". The same DSN works fine,
      > it's not the DSN, it's what I'm trying to do in C# that isn't working.
      >
      > What am I missing? I'm not quite sure how to use odbc.net to connect to[/color]
      the[color=blue]
      > MySQL DSN.
      >
      >[/color]


        Comment

        • Ook
          #3
          Re: How to use odbc.net and MySQL database

          There are no odbcDataAdapter s - either that, or I don't know where to find
          it. My choices seem to be limited to OleDb... or sqlDat.... How do I use an
          odbcDataAdapter ?


          "MP" <m.pulgar@codet el.net.do> wrote in message
          news:O4BjxArXDH A.1280@tk2msftn gp13.phx.gbl...[color=blue]
          > I'm not sure but beter try with:
          >
          > -> odbcDataAdapter
          >
          > NOT sqlDataAdapter
          >
          > MP
          > "Ook" <usenet@nospam@ emberts.com> wrote in message
          > news:O$46AipXDH A.2392@TK2MSFTN GP10.phx.gbl...[color=green]
          > > I'm missing something here. I've installed odbc.net. I've installed the
          > > latest dotnet SDK. I'm following the walkthrough in the msdn to create[/color][/color]
          an[color=blue][color=green]
          > > asp.net c# app. I get to the point where I put the sqlDataAdapter on the
          > > component1.cs, but I'm not sure how to configure it. Selecting the MS[/color][/color]
          OLE[color=blue]
          > DB[color=green]
          > > Provider for ODBC Drivers, and selecting my MySQL DSN passes the "Test
          > > Connection" test, but if I try to save it I get "The connection you have
          > > created does not work with the current adapter". The same DSN works[/color][/color]
          fine,[color=blue][color=green]
          > > it's not the DSN, it's what I'm trying to do in C# that isn't working.
          > >
          > > What am I missing? I'm not quite sure how to use odbc.net to connect to[/color]
          > the[color=green]
          > > MySQL DSN.
          > >
          > >[/color]
          >
          >[/color]


            Comment

            • Peter Wu
              #4
              Re: How to use odbc.net and MySQL database

              >>>>> "Ook" == Ook <usenet@nospam@ emberts.com> writes:

              Ook> I'm missing something here. I've installed odbc.net. I've installed the
              Ook> latest dotnet SDK. I'm following the walkthrough in the msdn to create an
              Ook> asp.net c# app. I get to the point where I put the sqlDataAdapter on the
              ^^^^^^^^^^^^^^
              This is for
              MSSQL Only.

              Ook> component1.cs, but I'm not sure how to configure it. Selecting the MS OLE DB
              Ook> Provider for ODBC Drivers, and selecting my MySQL DSN passes the "Test
              Ook> Connection" test, but if I try to save it I get "The connection you have
              Ook> created does not work with the current adapter". The same DSN works fine,
              Ook> it's not the DSN, it's what I'm trying to do in C# that isn't working.

              Ook> What am I missing? I'm not quite sure how to use odbc.net to connect to the
              Ook> MySQL DSN.

              Use OleDbConnection and OleDbDataAdapte r.

              --
              Peter Wu
              Powered by Microsoft Windows XP [Version 5.1.2600]

                Comment

                • Ook
                  #5
                  Re: How to use odbc.net and MySQL database

                  Time to take a setp backwards - are there any beginner guides for the dotnet
                  absolutely clueless? Not only am I not able to make this work, I'm not even
                  sure what to try.


                  "Ook" <usenet@nospam@ emberts.com> wrote in message
                  news:udOo6mtXDH A.2572@TK2MSFTN GP09.phx.gbl...[color=blue]
                  > There are no odbcDataAdapter s - either that, or I don't know where to find
                  > it. My choices seem to be limited to OleDb... or sqlDat.... How do I use[/color]
                  an[color=blue]
                  > odbcDataAdapter ?
                  >
                  >
                  > "MP" <m.pulgar@codet el.net.do> wrote in message
                  > news:O4BjxArXDH A.1280@tk2msftn gp13.phx.gbl...[color=green]
                  > > I'm not sure but beter try with:
                  > >
                  > > -> odbcDataAdapter
                  > >
                  > > NOT sqlDataAdapter
                  > >
                  > > MP
                  > > "Ook" <usenet@nospam@ emberts.com> wrote in message
                  > > news:O$46AipXDH A.2392@TK2MSFTN GP10.phx.gbl...[color=darkred]
                  > > > I'm missing something here. I've installed odbc.net. I've installed[/color][/color][/color]
                  the[color=blue][color=green][color=darkred]
                  > > > latest dotnet SDK. I'm following the walkthrough in the msdn to create[/color][/color]
                  > an[color=green][color=darkred]
                  > > > asp.net c# app. I get to the point where I put the sqlDataAdapter on[/color][/color][/color]
                  the[color=blue][color=green][color=darkred]
                  > > > component1.cs, but I'm not sure how to configure it. Selecting the MS[/color][/color]
                  > OLE[color=green]
                  > > DB[color=darkred]
                  > > > Provider for ODBC Drivers, and selecting my MySQL DSN passes the "Test
                  > > > Connection" test, but if I try to save it I get "The connection you[/color][/color][/color]
                  have[color=blue][color=green][color=darkred]
                  > > > created does not work with the current adapter". The same DSN works[/color][/color]
                  > fine,[color=green][color=darkred]
                  > > > it's not the DSN, it's what I'm trying to do in C# that isn't working.
                  > > >
                  > > > What am I missing? I'm not quite sure how to use odbc.net to connect[/color][/color][/color]
                  to[color=blue][color=green]
                  > > the[color=darkred]
                  > > > MySQL DSN.
                  > > >
                  > > >[/color]
                  > >
                  > >[/color]
                  >
                  >[/color]


                    Comment

                    Previous template Next
                    Working...