Visual Studio 2008 - Need to "Connect to Server" every time.

Provides intelligent code completion for SQL Server editors.

Moderators: David Atkinson, Anu Deshpande, Luke Jefferson

Visual Studio 2008 - Need to "Connect to Server" every time.

Postby GeraldP » Tue Jul 01, 2014 11:48 am

I am not sure what changed, but as of recently I am having a very annoying problem with the SQL Prompt (version 4.0.3) integration in Visual Studio 2008.

SQL Prompt used to pick up the database form the solution/db project somehow. As of recently I need to rerun "Connect to server" every time I open a new window for editing a SQL file.

How does SQL Prompt decide on which connection form the DB project to use? Is there any way I can tell it to use a particular connection for the entire DB project or even the entire solution?
GeraldP
 
Posts: 2
Joined: Tue Jul 01, 2014 11:41 am

Postby Brian Donahue » Thu Jul 03, 2014 10:24 am

The way I understand it, every SQL edit window in a VS database project has a connection associated with it. So when you open the window, Visual Studio is providing the connection information to that Window object and SQL Prompt is using that connection information.

SQL Prompt, by the virtue of the way it works, requires an active connection in a session so it can check for new columns. So you will probably be prompted to connect to that server is you are working disconnected.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby GeraldP » Mon Jul 14, 2014 11:20 pm

I uninstalled 4.0.3 and dug around our software vaults and found the original installer we had for (4.0.2.53). After installing that everything was working again the way it used to. Not sure if it was the uninstall and re-install process that fixed it, or if it only works with the older version.
GeraldP
 
Posts: 2
Joined: Tue Jul 01, 2014 11:41 am

Postby Brian Donahue » Wed Jul 16, 2014 8:20 am

Hi could not find any record of this problem in the bug database except one where it was happening exclusively in VS2012. That was fixed in version 6.0.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Prompt Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests