I'm trying to set up a link to MySQL through Microsoft SQL.

I set up a ODBC DSN using MyODBC and I told Microsoft SQL to link through an
ODBC Datasource. Everything seems to work except I can't query anything.

This is a statement I try.

SELECT * FROM [MySQL].mysql.db

This is the error message I get

Invalid object name 'MySQL.mysql.db'.


Has anyone done a similar thing and/or have ideas.

Aaron Weiker
Programmer
CISP - Changing Internet Speed & Performance

Phone: 419.724.5351                     [EMAIL PROTECTED]
Pager: 419.218.0013                     http://www.cisp.cc
Cell:    419.304.0323                   web search:
http://www.allthesites.com 

Reply via email to