We are attempting to access MySQL data from MS SQL Server 2000
Using OLE DB Provider for MySQL under Windows 2000.

We are attempting to open the datasource as follows:
Using the SQL Server OLE provider for ODBC - provider string "MySQLProv"


i.e. in query analyser
select * from opendatasource('MySQLProv','Data Source=<DSN name>;User ID=root').<database>.dbo.<table>

We get the response:
Server: Msg 7313, Level 16, State 1, Line 1
Invalid schema or catalog specified for provider 'MySQLProv'.

We have tried to access this table with and without catalog referencing.
Does anyone have a simple example that allow us to do this?

Any help would be much appreciated.