Whole Tomato Software Forums
Whole Tomato Software Forums
Main Site | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 Visual Assist
 Technical Support
 Bug report: editing MSSQL sproc

You must be registered to post a reply.
Click here to register.

Screensize:
UserName:
Password:
Format: BoldItalicizeUnderlineStrikethrough Align leftCenterAlign right Insert horizontal ruleUpload and insert imageInsert hyperlinkInsert email addressInsert codeInsert quoted textInsert listInsert Emoji
   
Message:

Forum code is on.
Html is off.

 
Check to subscribe to this topic.
   

T O P I C    R E V I E W
Alexo Posted - Nov 23 2007 : 10:38:41 AM
In VS2005, open the "Server Explorer" Window.
Under "Data Connections", connect to a local MSSQL database.
Right click on a stored procedure and select "Open".

Two error dialogs are presented:
quote:
---------------------------
Visual Assist X
---------------------------
The file 'mssql:://MyMachine/MyDB/dbo/Stored Procedure/dbo/SprocName' has been deleted!

Be sure to save the contents of the editor before closing the window.

and
quote:
---------------------------
Visual Assist X
---------------------------
The file 'mssql:' has been deleted!

Be sure to save the contents of the editor before closing the window.


Reproduced in:
VA_X.dll file version 10.4.1618.0 built 2007.11.15
DevEnv.exe version 8.0.50727.762
msenv.dll version 8.0.50727.762
Font: Consolas 13(Pixels)
Comctl32.dll version 6.0.2900.2982
Windows XP 5.1 Build 2600 Service Pack 2
2 processors


Also occurred in earlier builds.
11   L A T E S T    R E P L I E S    (Newest First)
sean Posted - Jun 12 2009 : 8:51:44 PM
case=9609 is fixed in build 1727
feline Posted - May 08 2009 : 7:00:46 PM
I am seeing the same effect here. Thank you for the clear description.

case=9609

It took a while to find out how to connect to a local SQL Server 2005 Express, but very easy to reproduce once I was past that problem.
Truper Posted - May 07 2009 : 10:53:24 AM
I have this problem as well. I simply load a project in VS 2008 and try to edit a stored procedure from the server explorer in Visual Studio and I get the error. I believe it can be any object in server explorer and not just a stored procedure. It appears that the error only occurs once and reappears when I restart Visual Studio.

Error Message:
First Dialog titled Visual Assist X states:
The file 'mssql::////////////server\\sqlserver2005////dbname////dbo///Stored Procedure///dbo////storedprocedurename' has been deleted! Be sure to save the contents of the editor before closing the window.

The second dialog titled Visual Assist X states:
The file 'mssql:' has been deleted! Be sure to save the contents of the editor before closing the window.

The second dialog is actually displayed first and is behind the first dialog that has to be acknowledged before returning to the second dialog.

SQL Server 2005.
VAX build 10.5.1715.0.
Microsoft Visual Studio 2008
Version 9.0.30729.1 SP
Microsoft .NET Framework
Version 3.5 SP1

Installed Edition: Professional

Microsoft Visual Basic 2008 91605-270-9381284-60487
Microsoft Visual Basic 2008

Microsoft Visual C# 2008 91605-270-9381284-60487
Microsoft Visual C# 2008

Microsoft Visual C++ 2008 91605-270-9381284-60487
Microsoft Visual C++ 2008

Microsoft Visual Studio 2008 Tools for Office 91605-270-9381284-60487
Microsoft Visual Studio 2008 Tools for Office

Microsoft Visual Web Developer 2008 91605-270-9381284-60487
Microsoft Visual Web Developer 2008
sean Posted - Feb 03 2009 : 8:05:52 PM
Can you please give us step by step details to repro the problem?
cperthen Posted - Feb 03 2009 : 7:49:05 PM
Hi,

I have reinstalled build 1647 and it resolved the issue with the error dialogs and delete of SQL server objects.

Cheers
Christian
sean Posted - Jan 28 2009 : 1:36:46 PM
You wrote "This issue has reappeared in build 1711!"

What version of VA were you using prior to 1711?

If you reinstall that version, does the problem go away?
cperthen Posted - Jan 28 2009 : 12:03:33 PM
Hi again,

I have reinstalled Visual Assist X several times and the problem is still there, basically I have to have it disabled all the time.

Microsoft Visual Studio 2005
Version 8.0.50727.762 (SP.050727-7600)
Microsoft .NET Framework
Version 2.0.50727 SP1

Installed Edition: Professional

Microsoft Visual Basic 2005 90613-246-0000007-41443
Microsoft Visual Basic 2005

Microsoft Visual C# 2005 90613-246-0000007-41443
Microsoft Visual C# 2005

Microsoft Visual C++ 2005 90613-246-0000007-41443
Microsoft Visual C++ 2005

Microsoft Visual J# 2005 90613-246-0000007-41443
Microsoft Visual J# 2005

Microsoft Visual Web Developer 2005 90613-246-0000007-41443
Microsoft Visual Web Developer 2005

Microsoft Web Application Projects 2005 90613-246-0000007-41443
Microsoft Web Application Projects 2005
Version 8.0.50727.762

Crystal Reports AAC60-G0CSA4B-V7000AY
Crystal Reports for Visual Studio 2005


Dundas Chart for ASP.NET 5.5
Dundas Chart for ASP.NET Enterprise Edition v5.5

Dundas Map for ASP.NET (VS2005) 1.0
Dundas Map for ASP.NET (VS2005)

Microsoft Visual Studio 2005 Professional Edition - ENU Service Pack 1 (KB918525)
This service pack is for Microsoft Visual Studio 2005 Professional Edition - ENU. \\n
If you later install a more recent service pack, this service pack will be uninstalled automatically. \\n
For more information, visit http://support.microsoft.com/kb/918525

Microsoft Visual Studio 2005 Professional Edition - ENU Service Pack 1 (KB926601)
This service pack is for Microsoft Visual Studio 2005 Professional Edition - ENU.
If you later install a more recent service pack, this service pack will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/926601

Security Update for Microsoft Visual Studio 2005 Professional Edition - ENU (KB937061)
This Security Update is for Microsoft Visual Studio 2005 Professional Edition - ENU.
If you later install a more recent service pack, this Security Update will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/937061

Security Update for Microsoft Visual Studio 2005 Professional Edition - ENU (KB947738)
This Security Update is for Microsoft Visual Studio 2005 Professional Edition - ENU.
If you later install a more recent service pack, this Security Update will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/947738

Visual Assist X
For more information about Visual Assist X, see the Whole Tomato Software website at http://www.WholeTomato.com. Copyright (c) 1997-2008 Whole Tomato Software, Inc.

SQL Prompt 3.8
For more information about SQL Prompt, see the Red Gate website at
http://www.red-gate.com
For customer support, call 1-866-733-4283.
Copyright -? 2006G??2008 Red Gate Software Ltd


quote:
Originally posted by sean

I'm not able to reproduce the problem using the steps posted in the first message. Can you please post more details?

sean Posted - Jan 13 2009 : 01:20:53 AM
I'm not able to reproduce the problem using the steps posted in the first message. Can you please post more details?
cperthen Posted - Jan 10 2009 : 11:09:37 PM
This issue has reappeared in build 1711!

VA_X.dll file version 10.5.1711.0 built 2008.12.11
Licensed to:
DevEnv.exe version 8.0.50727.762
msenv.dll version 8.0.50727.762
Font: Arial 11(Pixels)
Comctl32.dll version 6.0.2900.5512
Windows XP 5.1 Build 2600 Service Pack 3
2 processors

Platform: Win32
Stable Includes:
C:\\Program Files\\Microsoft Visual Studio 8\\VC\\include;
C:\\Program Files\\Microsoft Visual Studio 8\\VC\\atlmfc\\include;
C:\\Program Files\\Microsoft Visual Studio 8\\VC\\PlatformSDK\\include;
C:\\Program Files\\Microsoft.NET\\SDK\\v2.0\\include;

Other Includes:

Stable Source Directories:
C:\\Program Files\\Microsoft Visual Studio 8\\VC\\atlmfc\\src\\mfc;
C:\\Program Files\\Microsoft Visual Studio 8\\VC\\atlmfc\\src\\mfcm;
C:\\Program Files\\Microsoft Visual Studio 8\\VC\\atlmfc\\src\\atl;
C:\\Program Files\\Microsoft Visual Studio 8\\VC\\crt\\src;[/size=4]
support Posted - Dec 05 2007 : 6:37:48 PM
Case=9609 is fixed in Build 1623.
sean Posted - Nov 23 2007 : 11:57:48 AM
thanks for the report
case=9609
this will be fixed in the next maintenance build

© 2023 Whole Tomato Software, LLC Go To Top Of Page
Snitz Forums 2000