VS2003 ODBC SQLDatasources doesn't show SQL Server Express 2005
Posted on 2006-11-18
I'm using VS2003, writing in C++. I have SQL Server Express 2005 and SQL Server Management Studio Express installed. SQL Server Management Studio express can connect to MyMachine\SQLEXPRESS using windows authentication. I have C# code using (local)\SQLEXPRESS on this machine.
In C++, when I call SQLDataSources (SQL_FETCH_FIRST, SQL_FETCH_LAST) to enumerate the servers available on my machine, I see
Visual FoxPro Tables
Visual FoxPro Database
Xtreme Sample Database
Xtreme Sample Database 2003
Xtreme Sample Database 2005
As near as I can tell, the ODBC driver for SQL Server Express 2005 is installed -- I've installed the Microsoft SQL Server Native Client (sqlncli.msi) and it claims to have installed successfully.
Yet I can't enumerate it.
What am I missing?