I may not help, but what the heck...
1) when you say "access this data" do you mean accessed the linked table
through odbc?
if so, do you access the mysql linked table(only) or can you access the
"other" database(only) with success?
Can you create an excel spreadsheet, link it with odbc with access, and then
try to access that from .net?
is the mysql odbc connector an older version? I would also check mysql odbc
versions for any .net "unlikeabilities"
hth
bobb
"James Bird" <james.bird@dollshouse.com> wrote in message
news:1078a77t2qllf69@corp.supernews.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@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[/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]
