[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-odbc
Subject:    Problem connecting from ASP to MDB with MyODBC links
From:       "=?ISO-8859-1?Q?Jos=E9_Miguel_Serrano?=" <jmserrano () ain ! es>
Date:       2006-01-11 12:33:25
Message-ID: 43C4FB15.1010808 () ain ! es
[Download RAW message or body]


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



[prev in list] [next in list] [prev in thread] [next in thread]