I use SQL Server 2005 express and desing the DB in server explorer in VS2008. Due to various reasons I have disabled user instances. Now every time I use server explorer I need to modify the connection and turn user instances off. Is there a way to configure VS to always connect with user instance = false? ...
I'm getting an error in Visual Studio 2008 anytime I try to create a data connection in the Server Explorer: "Unable to add data connection. The IVsDataConnectionDialog could not be initialized" Also, the existing data connections are disabled and their icon is a red-slash-circle. So far, the only advice I've found is here: http://soci...
I hate the standard Query window that comes up when you select new query on a data connection in server explorer, I'd much rather have a T-SQL Editor come up. Is this possible? Maybe not replace that functionality but a shortcut key or something that would bring up a T-SQL editor? ...
I am creating a connection to an SAP system and want to manually modify the connectionString. Is it possible to do this? Where does Visual Studio 2003 store connections created using server explorer ...
I must have uninstalled something recently because the Data Connections no longer work. When I try to expand the Tables node, I get this: Microsoft Visual Studio Could not load file or assembly 'Microsoft.SqlServer.Management.Sdk.Sfc, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The...
Hello, I would like to create a table in a SQLite database using the Server Explorer in VS2008. I am able to do other operations on the database but when it comes to creating a table using the query builder I get Not Supported messages. is there another way other than writing code just for the sole purpose of creating the table? CREATE...
I have a developer that is having trouble connecting to a SQL Server instance by entering the server name (local)\HIS_SERVER_INSTANCE into Visual Studio->Server Explorer. If he replaces (local) with his machine name, it connects fine. I have had similar issues before but they seemed to fix themselves. Does anyone know a fix for this? ...
I'm working on a .Net application that needs to read from an Oracle 10g database behind Siebel. In VS 2010 Server Explorer, I've created a connection using the OracleClient type connector with a reference to the Oracle TNS service name as the "server name." The "Test Connection" button shows that the connection is successful. However,...
In Visual Studio 2008, I have database connections in the Server Explorer window that point to SQL Server databases installed locally on my PC. When I delete one of the connections in goes, but next time I start Visual Studio is is back again. Does anyone know how to remove them properly? It isn't a big deal, but it is a bit annoying....
Hi, as mentioned in title. Another details: file is in on my hard drive in App_Data directory I have Microsoft SQL Server 2005 on my localhost installed (full, not Express edition) When I try to connect to file using Server explorer Microsoft SQL Server Database File I get an error: network-related or instance-specific error occ...
Hi to all ! Basicly, I think the title of the post here says it all. I am working with Visual Studio 2010 Ultimate 10.0.30319.1 RTMRel. EDIT: I am running Windows 7 x64. Everytime I open a solution it tries to connect to all databases present in Server Explorer. My problem is that some of them are not always available over internet so...