kevin.c.carter@stripped wrote:
>
> Anybody know how to configure mysql or MS Access ODBC to look at an MS SQL
> Database? We have 1 mysql database, 1 MS Access database and 1 MS SQL
> database that need to talk to each other...
Take a look at http://beta.easysoft.com/ They have a database
engine which you put in front of several DBs to make them
look as if it were one. You can even do cross DB queries with
it... don't remember the name, but I'm sure you'll find it
on their site.
If you only need data exchange between the three DBs, you could
use mxODBC (see my Python Pages) and Python to get the job done.
--
Marc-Andre Lemburg
______________________________________________________________________
Y2000: 134 days left
Business: http://www.lemburg.com/
Python Pages: http://www.lemburg.com/python/
