469,951 Members | 2,494 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,951 developers. It's quick & easy.

Error accessing MS Access table linked to MySQL

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
ja********@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.

Jul 19 '05 #1
3 2274
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" <ja********@dollshouse.com> wrote in message
news:10*************@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
ja********@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.

Jul 19 '05 #2
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" <ja********@dollshouse.com> wrote in message
news:10*************@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
ja********@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.

Jul 19 '05 #3
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" <ja********@dollshouse.com> wrote in message
news:10*************@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
ja********@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.

Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Morten Gulbrandsen | last post: by
10 posts views Thread by Mike | last post: by
reply views Thread by Smriti Dev | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.