ok I ran this as per your advise..

select * from MySQL...src_customers

and got this error ...

OLE DB provider "MSDASQL" for linked server "MySQL" returned message "Unspecified error".

OLE DB provider "MSDASQL" for linked server "MySQL" returned message "[MySQL][ODBC 5.1 Driver][mysqld-5.0.77]No database selected".

Msg 7311, Level 16, State 2, Line 1

Cannot obtain the schema rowset "DBSCHEMA_TABLES" for OLE DB provider "MSDASQL" for linked server "MySQL". The provider supports the interface, but returns a failure code when it is used.

please advise if its possible to run create table and insert into statements from SQL Server to the linked MYSql server database ???

its urgent..thanks