I've installed MyODBC-3.51.06 and succsesfully created 2 odbc sources to the MySQL database with the ODBC data source administrator. One is a User DSN, the other a system DSN (Q1: what's the difference?) The test in that applet perfoms positively.
Running a dataimport of the tables using the import data option in enterprise manager does work as well.
Now for the part that gives me trouble. I would like to create a linked server using enterprise manager of SQL server 2000 (SQL 8.00.194) but I'm totaly stuck there. So Q2: how to get this set up?
First of all, apply SP3 to your SQL service. Second, select MS OLE DB Provider for ODBC Drivers. In Product name put MSDASQL, in Data Source put the name of your System DSN (the difference is that User DSN will be available only for the user that created it), in Provider String put the connection string, etc.