Problem connecting from ASP to MDB with MyODBC links

--------------080909050109050706050602
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit


Hi all:

I have spent lot of time with this problem, and I have Googled, but I
haven't found real solution. You are the last hopeness.

I am editing a program with ASP that connect with an MDB database:
Example (aaa.mdb). This database has some tables linked by MyODBC:
Example DSN=ggg. ggg connect fine to MySQL. Notes and tries:

* I need mix tables from Access and MySQL. The best way is to link
by MyODBC in Access file, because the program has been developed,
and only change the tables.
* If I open aaa.mdb by Access, the linked tables open fine.
* If I open by ASP Access format tables from 'aaa.mdb' all goes fine.
* If I open by ASP MySQL tables by DSN 'ggg' all goes fine.
*

* BUT if I try open a MySQL table connecting by OLEDB or DSN to
Access file 'aaa.mdb', then IIS report an error explaining that
can't connect to 'ggg'.

I have tried a lot with IIS changing the security access (don't worry,
is an VMware machine), but nothing has improved.

I need help with this. Perhaps IIS is not able to manage 'transitive'
DSN's........?

Thanks in advance,

Josemi


--------------080909050109050706050602--