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