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
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
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
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