CODEWITHSUNDEEP
sql-servervisual-studio-2010odbc
TomDestry
TomDestry

Reputation: 3399

Unable to select a system DSN when adding a data connection to Server Explorer

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

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.

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.

Upvotes: 1

Views: 5664

Answers (1)

SPE109
SPE109

Reputation: 2951

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

Upvotes: 6

Related Questions