MySQL Forums
Forum List  »  Microsoft SQL Server

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?

Options: ReplyQuote

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.