Skip navigation links

MySQL Forums :: Microsoft SQL Server :: Running queries against Linked Server and MyODBC


Advanced Search

Running queries against Linked Server and MyODBC
Posted by: Albert Kurland ()
Date: April 01, 2005 11:39AM

Hello, I'm trying to run queries against bugzilla database (mySQL)

Here's my setup:

1. Installed MyODBC-3.51.11-1-win.msi driver on Windows 2K

2. Created a system ODBC DSN using this driver to a specific server and database.

3. In SQL Server 2K Enterprise Manager, created a linked server using Microsoft OLE DB Provider for ODBC Drivers and specified the DSN in the Data Source.

4. I can view tables from MySQL database in Enterprise Manager.

Problem: when I tried running a query like this:

SELECT * FROM bugzilla..bugs.components

I get an error:
Invalid use of schema and/or catalog for OLE DB provider 'MSDASQL'. A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog and/or schema.
OLE DB error trace [Non-interface error].

Does anyone know what I'm doing wrong?
Thanks.

Options: ReplyQuote


Subject Written By Posted
Running queries against Linked Server and MyODBC Albert Kurland 04/01/2005 11:39AM
Re: Running queries against Linked Server and MyODBC Sean Nolan 04/01/2005 12:51PM
Re: Running queries against Linked Server and MyODBC Albert Kurland 04/04/2005 10:15AM
Re: Running queries against Linked Server and MyODBC Sean Nolan 04/04/2005 09:39PM
Is there a way to update MySql Table through linked server yeek li 04/30/2008 11:37AM
Re: Running queries against Linked Server and MyODBC Wawan Supriadi 04/07/2005 03:10AM
Re: Running queries against Linked Server and MyODBC Barry Steele 05/05/2005 01:26AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.