Whole Tomato Software Forums
Whole Tomato Software Forums
Main Site | Profile | Register | Active Topics | Members | Search | FAQ
User name:
Password:
Save Password
Forgot your password?

 All Forums
 Visual Assist
 Technical Support
 Bug report: editing MSSQL sproc
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Alexo
Ketchup Master

Canada
81 Posts

Posted - Nov 23 2007 :  10:38:41 AM  Show Profile  Reply with Quote
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.

sean
Whole Tomato Software

USA
2817 Posts

Posted - Nov 23 2007 :  11:57:48 AM  Show Profile  Reply with Quote
thanks for the report
case=9609
this will be fixed in the next maintenance build
Go to Top of Page

support
Whole Tomato Software

5566 Posts

Posted - Dec 05 2007 :  6:37:48 PM  Show Profile  Reply with Quote
Case=9609 is fixed in Build 1623.
Go to Top of Page

cperthen
New Member

3 Posts

Posted - Jan 10 2009 :  11:09:37 PM  Show Profile  Reply with Quote
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]

Edited by - cperthen on Jan 10 2009 11:10:21 PM
Go to Top of Page

sean
Whole Tomato Software

USA
2817 Posts

Posted - Jan 13 2009 :  01:20:53 AM  Show Profile  Reply with Quote
I'm not able to reproduce the problem using the steps posted in the first message. Can you please post more details?
Go to Top of Page

cperthen
New Member

3 Posts

Posted - Jan 28 2009 :  12:03:33 PM  Show Profile  Reply with Quote
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?

Go to Top of Page

sean
Whole Tomato Software

USA
2817 Posts

Posted - Jan 28 2009 :  1:36:46 PM  Show Profile  Reply with Quote
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?
Go to Top of Page

cperthen
New Member

3 Posts

Posted - Feb 03 2009 :  7:49:05 PM  Show Profile  Reply with Quote
Hi,

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

Cheers
Christian
Go to Top of Page

sean
Whole Tomato Software

USA
2817 Posts

Posted - Feb 03 2009 :  8:05:52 PM  Show Profile  Reply with Quote
Can you please give us step by step details to repro the problem?
Go to Top of Page

Truper
Starting Member

USA
1 Posts

Posted - May 07 2009 :  10:53:24 AM  Show Profile  Reply with Quote
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
Go to Top of Page

feline
Whole Tomato Software

United Kingdom
18947 Posts

Posted - May 08 2009 :  7:00:46 PM  Show Profile  Reply with Quote
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.

zen is the art of being at one with the two'ness
Go to Top of Page

sean
Whole Tomato Software

USA
2817 Posts

Posted - Jun 12 2009 :  8:51:44 PM  Show Profile  Reply with Quote
case=9609 is fixed in build 1727
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
© 2023 Whole Tomato Software, LLC Go To Top Of Page
Snitz Forums 2000