Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

No propertiesy option when I right click on the MSDASQL under Link Server

Posted on 2011-03-07
4
Medium Priority
?
355 Views
Last Modified: 2012-05-11
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.
0
Comment
Question by:lapucca
  • 2
  • 2
4 Comments
 
LVL 9

Expert Comment

by:Philippe Damerval
ID: 35061760
this may result from a corrupted installation of SSMS / SQL server.
What version of SQL server  are you using, and if 2005, is it SP3?

Philippe
0
 

Author Comment

by:lapucca
ID: 35061939
Hi, I'm using windows 7 and sql 2005 express and I think it's sp4.  I think I use this for installation, SQLServer2005SP4-KB2463332-x64-ENU.exe.  Can you tell from the indormation below what version and if it's 32 bit or 64 bit?  The installed folders are C:\Program Files\Microsoft SQL Server which only has 2 folders under it, folder "80" and "90".   However, this other folder here seems to have all the files, C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL.
I thought under (x86) means it's 32bit application.  I'm pretty confused now about what exactly do I have.  

Microsoft SQL Server Management Studio                                    9.00.5000.00
Microsoft Analysis Services Client Tools                                    2005.090.5000.00
Microsoft Data Access Components (MDAC)                                    6.1.7600.16385 (win7_rtm.090713-1255)
Microsoft MSXML                                    3.0 5.0 6.0
Microsoft Internet Explorer                                    8.0.7600.16385
Microsoft .NET Framework                                    2.0.50727.4952
Operating System                                    6.1.7600

Running Select @@version would give me the following
Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)   Feb  9 2007 22:47:07   Copyright (c) 1988-2005 Microsoft Corporation  Express Edition on Windows NT 6.1 (Build 7600: )
0
 
LVL 9

Accepted Solution

by:
Philippe Damerval earned 2000 total points
ID: 35062085
0
 

Author Closing Comment

by:lapucca
ID: 35103145
Yeah, I have to install 2005 standard edition to get that feature.  thank you.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Recursive SQL is one of the most fascinating and powerful and yet dangerous feature offered in many modern databases today using a Common Table Expression (CTE) first introduced in the ANSI SQL 99 standard. The first implementations of CTE began ap…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

972 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question