检查是否安装了 SQL Server 客户端 [英] Check if SQL Server Client Is Installed

查看:63
本文介绍了检查是否安装了 SQL Server 客户端的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

如何检查是否安装了 SQL Server 客户端驱动程序?以及是否也可以确定版本?

How can one check to see if the SQL Server Client driver is installed? And is it also possible to determine the version?

推荐答案

Go to->Run->cmd->type regedit.exe 就看到了 ODBC 文件夹下的注册表:>

Go to->Run->cmd->type regedit.exe and you see the registry under the ODBC folder:

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\
    ODBC Drivers\SQL Server

我还发现 关于这个问题的完整答案,(基于MySQL,但基本上是一样的).

I also find a complete answer about this issue, (based on MySQL, but basically is the same thing).

稍后根据你的评论你已经安装了2005版的SQL Server:

Edit later: according to your comment you have installed the 2005 version of SQL Server:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\
Microsoft SQL Native Client\CurrentVersion

无论如何,我也向您展示了如何查看 2008 版本以了解两个版本之间的差异.

Anyway I also show you how you can see the 2008 version to see the differences between the two versions.

对于 SQL Server 2008/R2:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\
Microsoft SQL Server\SQLNCLI10\CurrentVersion

对于 SQL Server 2012:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\
Microsoft SQL Server\SQLNCLI11\CurrentVersion 

这篇关于检查是否安装了 SQL Server 客户端的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆