Thanks for replying. Even if this works, this sounds like the recipe for a future administrative nightmare. EG, someone changes the password on the MYSQL machine, changes it on the...

Hello

Have a look at this article, which may provide a possible solution.

http://www.sqldts.com/default.aspx?212

Try this link, or copy and paste the original and add &forumid=5 to the end

http://www.sqlservercentral.com/forums/shwmessage.aspx?messageid=110031&forumid=5