Re: Problems accessing a MySQL database using an Access linked table

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Joe Gass (joe_at_dontspamme.com)
Date: 04/08/04 

Date: Thu, 8 Apr 2004 12:25:34 +0100

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@dollshouse.com> wrote in message
news:107a1nf165dgn08@corp.supernews.com...
> 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@dollshouse.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.
>
>
>

Relevant Pages

  • Re: Blank Forms
    ... Printing a form can be done by opening the form and pressing the print ... set the Data Entry Property to True. ... Is your Access database too slow? ... "James W." ...
    (microsoft.public.access.queries)
  • Re: custom type into access?
    ... > Hi James, ... >> I would like to add a custom object to my access database - if I ... >> create a byte array, can i serialize this object to an access database? ... > uses MEMO data type for storing BLOBs). ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Building an array from a csv txt file
    ... Thanks, got them to dump it to an access database instead, I WIN.....I ... "James D. Marshall" wrote in message ... > Help, went brain dead here, need to build a multi dem array from a csv txt ...
    (microsoft.public.dotnet.general)
  • Linearising Access Data
    ... but it has been puzzling me and I would have thought ... I been sent a large access database containing a table of the form: ... James ... Prev by Date: ...
    (microsoft.public.access.conversion)
  • Re: Attachment Problem
    ... James ... >> blocking access to it... ...
    (microsoft.public.outlook.general)