Hi, I'm using sql 2005 express on windows 7. I am log in as a member of the Administrators group on my local dev pc. I need to create a MySql link server in my SSMS. I am following the instruction here, http://www.ideaexcursion.com/2009/02/25/howto-setup-sql-server-linked-server-to-mysql/
. Everything is working out fine until I reach "Configure Linked Server Provider". There is no propertiesy option when I right click on the MSDASQL under Link Server. there is only 2 items on this context menu, Reports and Refresh. Why and how can I get this properties? thank you.