Problems accessing a MySQL database using an Access linked table

From: James Bird (james.bird_at_dollshouse.com)
Date: 04/08/04 

Date: Thu, 8 Apr 2004 09:01:58 +0100

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

  • Problems accessing a MySQL database via an Access linked table
    ... I've created an Access database ... application - classic ASP works fine but .NET gives me... ... Web Manager ... If you are not the intended recipient please notify the sender that you have ...
    (microsoft.public.access.externaldata)
  • Re: Beginner asp tutorial required + dreamweaver or FP
    ... Access Database: Not the best idea. ... Download SQL Server Developer Edition and begin their, ... the time learning something it might as well be that. ... Also unless you are required to learn classic ASP, ...
    (microsoft.public.inetserver.asp.db)
  • Re: Beginner asp tutorial required + dreamweaver or FP
    ... Access Database: Not the best idea. ... Download SQL Server Developer Edition and begin their, ... the time learning something it might as well be that. ... Also unless you are required to learn classic ASP, ...
    (microsoft.public.inetserver.asp.general)
  • Access conversion to SQL
    ... I have an application that currently connects to an Access database, ... customers are asking for a MySql and MsSql server back end database. ... MySql handles True and False values through the bit field without any ... It also gives me the problem of setting controls true/false value by ...
    (microsoft.public.access.conversion)
  • Interesting ODBC problem
    ... I have just converted a guestbook to use an Access database rather than ... MySQL via odbc and have come across an unusual problem. ...
    (comp.lang.php)