Re: Connect To Foreign Tables

2007-10-08 Thread James Card
On Sat, 06 Oct 2007 00:25:04 -0700, Werner Van Belle <[EMAIL PROTECTED]> wrote: Hello, On Friday 05 October 2007 01:11:35 James Card wrote: The application I'm working on uses MySQL 5.0.41 and we also need to retrieve some data from a SQL-Server database in another department. SQL-Server

Re: Connect To Foreign Tables

2007-10-06 Thread Rob Wultsch
Have you guys thought about trying to use a Federated table? http://dev.mysql.com/doc/refman/5.0/en/federated-storage-engine.html Probably not exactly the solution you want, but maybe useful. On 10/6/07, Werner Van Belle <[EMAIL PROTECTED]> wrote: > > Hello, > > On Friday 05 October 2007 01:11:35

Re: Connect To Foreign Tables

2007-10-06 Thread Werner Van Belle
Hello, On Friday 05 October 2007 01:11:35 James Card wrote: > The application I'm working on uses MySQL 5.0.41 and we also need to > retrieve some data from a SQL-Server database in another department. > SQL-Server has a feature (that I haven't tested) that allows it to make an > ODBC connection

Connect To Foreign Tables

2007-10-04 Thread James Card
The application I'm working on uses MySQL 5.0.41 and we also need to retrieve some data from a SQL-Server database in another department. SQL-Server has a feature (that I haven't tested) that allows it to make an ODBC connection to a foreign database and treat its tables as if they were loc