Here's the scenario

I need to be able to connect to mySQL from MSSQL2000.

Then create several store proc in MSSQL2000 to select, insert and update data in mySQL.

The problem is...

I've tried but it return the following error

Server: Msg 7399, Level 16, State 1, Line 1

OLE DB provider 'MySqlProv' reported an error. The provider did not support an interface.

I'm using...

Thanks Antares686

I could select rows using openquery.

Any idea how can I 'Insert' or 'Update'

I only manage to update using

Select * from Openquery (Localhost,'Insert into

values...

New findings

I manage to create Link Servers via SQL Enterprise Manager.

Created 'LOCALHOST' with provider 'MySQL.OLEDB Provider'

I could view the tables but could not select the records.

When I tried to Select...