Linking to MySQL

From: donron (donron_at_discussions.microsoft.com)
Date: 01/24/05 

Date: Mon, 24 Jan 2005 07:59:04 -0800

I can address Linked Oracle Tables with no catalog name but I CANNOT address
MySQL tables with no Schema Name

MySQL_LinkName.CatalogName.SchemaName.TableName

For Oracle I use with no problem:
SELECT * FROM HBA..HBA.CHARGES

But For MySQL I have tried it all

SELECT * FROM SPMINLINESHAPEGAUGE.SHAPEGAGE..RESULTS

This is the error I keep getting:

Server: Msg 7313, Level 16, State 1, Line 1
Invalid schema or catalog specified for provider 'MSDASQL'.
OLE DB error trace [Non-interface error: Invalid schema or catalog
specified for the provider.].

Will anyone help me out here?
Am I using the correct syntax?

Thanks 

-- 
don

Relevant Pages

  • Re: Linked Servers: Invalid schema
    ... i'm having the same problem with linking mysql. ... Invalid use of schema and/or catalog for OLE DB provider 'MSDASQL'. ... i can see all the tables in the linked mysql server, ...
    (microsoft.public.sqlserver.odbc)
  • Re: delete sql syntax for linked notes table
    ... Invalid use of schema and/or catalog for OLE DB provider 'MSDASQL'. ...
    (comp.databases.ms-sqlserver)
  • Re: Add Informix linked server
    ... I think you can change the linked server name with sp_setnetname. ... > Invalid use of schema and/or catalog for OLE DB provider 'MSDASQL'. ...
    (microsoft.public.sqlserver.connect)
  • Re: How to create my own VB backup program for a remote MySQL DB
    ... MySQL has an OLEDB driver, ... Both data and schema are stored in the output file. ... the recordset to an open connection, call UpdateBatch and ADO and the server ... > I understand that the basic principles to create a TCP/IP backup program ...
    (microsoft.public.vb.database)
  • Re: Designing a CD Database - How to Start?
    ... > Any suggestions for designing a CD database? ... > need to have some sort of catalog of "the collection". ... My advice is to keep your schema as simple as possible. ... Here's the database in sqlite3 binary format: ...
    (rec.music.classical.recordings)
Quantcast