josgood
asked on
VS2003 ODBC SQLDatasources doesn't show SQL Server Express 2005
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
MSSQL$VSdotNET
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?
Thank you.
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
MSSQL$VSdotNET
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?
Thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you, thank you, thank you! That is exactly the solution!
I wasn't aware of that additional step.
Joe