向Server Explorer添加数据连接时无法选择系统DSN [英] Unable to select a system DSN when adding a data connection to Server Explorer

问题描述

在Visual Studio 2010中，尝试使用服务器资源管理器添加数据连接.

In Visual Studio 2010, attempting to use the Server Explorer to add a data connection.

从更改数据源屏幕中，选择 Microsoft ODBC数据源，这会将我移动到添加连接屏幕.但是，使用用户或系统数据源名称:的下拉列表仅包含我的用户DSN.我的系统DSN未显示.

From the Change Data Source screen I select Microsoft ODBC Data Source which moves me to the Add Connection screen. However, the dropdown for Use user or system data source name: only contains my user DSNs. My system DSNs are not shown.

我正在Windows 7(64位)上运行，并以管理员身份运行Visual Studio.缺少的系统DSN使用SQL Server Native Client 10.0，但是使用相同驱动程序的等效用户DSN出现在列表中.

I'm running on Windows 7, 64 bit and ran Visual Studio as administrator. The missing system DSNs use the SQL Server Native Client 10.0, but an equivalent user DSN using the same driver appears in the list.

推荐答案

您说您使用的是64位计算机，Visual Studio以前仅为32位，因此只能看到32位DSN.您可以尝试运行ODBC管理器的32位版本，并在其中创建/检查您的DSN.该路径通常类似于C:\ Windows \ SysWOW64 \ odbcad32.exe

You say you are on a 64bit machine, Visual Studio used to be 32 bit only and thus would only see 32 bit DSN's. You could try running the 32 bit version of the ODBC manager and creating/checking your DSN exists in there. The path is usally something like C:\Windows\SysWOW64\odbcad32.exe

这篇关于向Server Explorer添加数据连接时无法选择系统DSN的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！