For Programmers: Free Programming Magazines  


Home > Archive > C# > March 2004 > Connecting to SQL Server Visually









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Connecting to SQL Server Visually
Fresh Air Rider

2004-03-28, 11:32 pm

I have Visual C# Standard

If I use the Visual Tools to create a connection to SQL Server, I get
the following error :-

"Unable to connect to database
It is only possible to connect to SQL Server Desktop
Engine databases and Microsoft Access databases with this
version of Visual Studio"

This is obviously Microsoft's way of forcing users to purchase more
software from them.

I understand from reading the Microsoft.Public.DotNet usergroups that
this may be overcome by purchasing Visual Studio .Net Pro or higher.

To add to the confusion
http://msdn.microsoft.com/vstudio/h...y/choosing.aspx states the
following :-

Visual Database Tools
Design stored procedures, indexes, tables, triggers, user-defined
functions, and other database elements visually.
In Visual Studio .NET Professional, these design capabilities are
limited to the SQL Server Desktop Engine.

Can anyone please confirm that if I purchase Visual Studio .Net Pro I
will be able to visually create connections to SQL Server ?

I have successfully created connections to MS SQL Server in code but
am concerned that I may need to take on an existing project which
already contains these "Visual DB Connections" and my Visual C#
Standard will not be able to handle them.

Many thanks in advance
John
Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com