Running queries against Linked Server and MyODBC
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.
Subject
Written By
Posted
Running queries against Linked Server and MyODBC
April 01, 2005 11:39AM
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.