Problems accessing a MySQL database using an Access linked table

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

    Problems accessing a MySQL database using an Access linked table

    Hello

    In order to perform a hetrogeneous join (I think that's what they're called)
    between MySQL and another database, I've created an Access database
    containing linked tables from each datasource.

    I create the linked tables without any problems, clicking on "save password"
    before selecting the desired tables. I can then access both tables fine from
    within the Access GUI.

    The problem starts when I then try to access this data from my ASP.NET web
    application - classic ASP works fine but .NET gives me...

    ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] ODBC--connection to
    'MyDSN' failed.

    From then on, the Access database remains locked (.LDB file in the same
    directory) and I get a similar error when I run my ASP page, which
    previously worked.

    Any suggestions would be gratefully received.
    --
    Regards
    James Bird

    Web Manager
    The Dolls House Emporium
    Tudor Models Ltd
    james.bird@doll shouse.com www.dollshouse.com
    Tel: 01773 514405 Fax: 01773 513772


    This email and any files transmitted with it are confidential and intended
    solely for the individual or entity to whom they are addressed. No liability
    is accepted for the accuracy or completeness of any information contained in
    this email.

    If you are not the intended recipient please notify the sender that you have
    received it in error, and do not use, distribute, print or copy it.



    Tags: None
    • Joe Gass
      #2
      Re: Problems accessing a MySQL database using an Access linked table

      Hi James, perhaps another approach would be to load up the 2 tables
      separately into separate datatable objects then join them with a
      datarelation - I've not tried it tho'

      "James Bird" <james.bird@dol lshouse.com> wrote in message
      news:107a1nf165 dgn08@corp.supe rnews.com...[color=blue]
      > Hello
      >
      > In order to perform a hetrogeneous join (I think that's what they're[/color]
      called)[color=blue]
      > between MySQL and another database, I've created an Access database
      > containing linked tables from each datasource.
      >
      > I create the linked tables without any problems, clicking on "save[/color]
      password"[color=blue]
      > before selecting the desired tables. I can then access both tables fine[/color]
      from[color=blue]
      > within the Access GUI.
      >
      > The problem starts when I then try to access this data from my ASP.NET web
      > application - classic ASP works fine but .NET gives me...
      >
      > ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] ODBC--connection[/color]
      to[color=blue]
      > 'MyDSN' failed.
      >
      > From then on, the Access database remains locked (.LDB file in the same
      > directory) and I get a similar error when I run my ASP page, which
      > previously worked.
      >
      > Any suggestions would be gratefully received.
      > --
      > Regards
      > James Bird
      >
      > Web Manager
      > The Dolls House Emporium
      > Tudor Models Ltd
      > james.bird@doll shouse.com www.dollshouse.com
      > Tel: 01773 514405 Fax: 01773 513772
      >
      >
      > This email and any files transmitted with it are confidential and intended
      > solely for the individual or entity to whom they are addressed. No[/color]
      liability[color=blue]
      > is accepted for the accuracy or completeness of any information contained[/color]
      in[color=blue]
      > this email.
      >
      > If you are not the intended recipient please notify the sender that you[/color]
      have[color=blue]
      > received it in error, and do not use, distribute, print or copy it.
      >
      >
      >[/color]


        Comment

        • Joe Gass
          #3
          Re: Problems accessing a MySQL database using an Access linked table

          Hi James, perhaps another approach would be to load up the 2 tables
          separately into separate datatable objects then join them with a
          datarelation - I've not tried it tho'

          "James Bird" <james.bird@dol lshouse.com> wrote in message
          news:107a1nf165 dgn08@corp.supe rnews.com...[color=blue]
          > Hello
          >
          > In order to perform a hetrogeneous join (I think that's what they're[/color]
          called)[color=blue]
          > between MySQL and another database, I've created an Access database
          > containing linked tables from each datasource.
          >
          > I create the linked tables without any problems, clicking on "save[/color]
          password"[color=blue]
          > before selecting the desired tables. I can then access both tables fine[/color]
          from[color=blue]
          > within the Access GUI.
          >
          > The problem starts when I then try to access this data from my ASP.NET web
          > application - classic ASP works fine but .NET gives me...
          >
          > ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] ODBC--connection[/color]
          to[color=blue]
          > 'MyDSN' failed.
          >
          > From then on, the Access database remains locked (.LDB file in the same
          > directory) and I get a similar error when I run my ASP page, which
          > previously worked.
          >
          > Any suggestions would be gratefully received.
          > --
          > Regards
          > James Bird
          >
          > Web Manager
          > The Dolls House Emporium
          > Tudor Models Ltd
          > james.bird@doll shouse.com www.dollshouse.com
          > Tel: 01773 514405 Fax: 01773 513772
          >
          >
          > This email and any files transmitted with it are confidential and intended
          > solely for the individual or entity to whom they are addressed. No[/color]
          liability[color=blue]
          > is accepted for the accuracy or completeness of any information contained[/color]
          in[color=blue]
          > this email.
          >
          > If you are not the intended recipient please notify the sender that you[/color]
          have[color=blue]
          > received it in error, and do not use, distribute, print or copy it.
          >
          >
          >[/color]


            Comment

            Previous template Next
            Working...