Last post Sep 16, 2009 11:02 PM by SateeshN
Sep 12, 2009 09:16 AM|SateeshN|LINK
Please tell me the steps to establish connection between SQL Server 2005 and Visual Studio 2005.
The Server Explorer is not showing "Microsoft SQL Server" in Data Source List. How can i connect?
Thanks in Advance,
Senior Software Engineer,
Medha Solutions Pvt. Ltd.
Connection between SQL Server and Visual Studio
Sep 12, 2009 10:09 AM|ssstars|LINK
What is showing?
Are you seeing:
If you are not seeing this you can right click on "server" and add your computer (server).
2. Data Connections
Comuter Name/SQL Server
If you are not seeing this... then you can right click on Data Connections and add a new connection.
Let me know if this help... if it does, please remember to mark as answer.
Sep 12, 2009 02:30 PM|SateeshN|LINK
Yes, i am able to see those options, but in the next step i am getting problem to connect with SQL Server database.
i.e. there is no Data Provider for "Microsoft SQL Server" in Choose Data Source dialog. Here ".NET Framework Data Provider for SQL Server" is missing.
How can i get that option? I think i installed SQL Server 2005 first, after i installed VS 2005.
Sep 12, 2009 05:54 PM|ssstars|LINK
First, I'd like to suggest that you download and install Microsoft Data Access Components (MDAC) 2.8 SP1.
You can find it here:
Hope that works... if it does not, I am not sure how you can resolve this.
I have other ideas... but, its a lot of work and no gurantees.
Sep 16, 2009 11:02 PM|SateeshN|LINK
Thanks for your support, the problem is solved.
Actually there is no servers are showing automatically in Server Name drop down, i given server name manually. Then it is working.
And MDAC_TYPE.EXE is not installing, showing a fatal error that "The setup does not support installing on this operating system".
Thanks & Regards,