I'm trying to use a MySQL database as a linked server in Microsoft SQL 2000. I used MySQL ODBC 3.51 driver and have successfully setup a linked server. I can get the following to work in TSQL

select * from openquery(portal,"select * from nuke_users")

however I can't use the more simple select statement of

select * from portal.pn.dbo.nuke_users
and
select * from portal.pn.dbo.nuke_users

I've tried a number of variarions of the above and none seem to work. I suspect my problem is somewhere in my four part name. Is anyone successfully use a MySQL database as a linked server w/o useing openquery.