| Groups | Blog | Home |
visual studio .net ide : VS2005 Crashes when running Database Script.
I have an ASP.NET 2 solution that contains a website, some other DLL projects
and a database project. The database project contains a number of sql scripts to generate the stored procedures that are used by the website on the SqlServer 2000 database. If I open a script, right-click and select RUN the script runs ok and generates the stored procedure on the default database. However, if I select the RunOn command to run the script on one of the other database referenced in the project then Visual Studio crashes. The error report contains the following information... AppName: devenv.exe AppVer: 8.0.50727.42 AppStamp:4333e699 ModName: vdt80p.dll ModVer: 8.0.50727.42 ModStamp:4333eba8 fDebug: 0 Offset: 0004cae9 Regards,
Gary,
The problem can be reproduced on BOTH of my development machines by right-clicking on any sql script from the solution explorer and selecting run-on. I do not get as far as selecting any of the two valid databases referenced in my project. To run the scripts on both database I have to first run it on the default database and then change the default database and run it again. Regards, Dave. [quoted text, click to view] ""Gary Chang[MSFT]"" wrote:
> Hi Dave, > > Thank you posting! > > >If I open a script, right-click and select RUN the script > >runs ok and generates the stored procedure on the > >default database. However, if I select the RunOn > >command to run the script on one of the other database > >referenced in the project then Visual Studio crashes. > > Based on y understanding, your script runs well on the default database of > your database project, but if it runs in one of the other database > referenced in the project, the VS2005 IDE just crashes. > > If so, does the problem only happen to that specific database of that > project? How about any other non-default referenced database? > > If the problem only occurs to that specific database, have you tried to run > that script outside the VS2005 IDE, such as SQL 2005's Management Studio or > via the SQLCMD? Is it OK? > > These information will help us to research your issue, so I appreciate your > time in checking them. Let me know the results at your earliest > convenience. If you have any questions or concerns, please let me know. I > am standing by to help you > > > Thanks! > > Best regards, > > Gary Chang > Microsoft Online Community Support > ================================================== > Get notification to my posts through email? Please refer to > http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif > ications. > > Note: The MSDN Managed Newsgroup support offering is for non-urgent issues > where an initial response from the community or a Microsoft Support > Engineer within 1 business day is acceptable. Please note that each follow > up response may take approximately 2 business days as the support > professional working with you may need further investigation to reach the > most efficient resolution. The offering is not appropriate for situations > that require urgent, real-time or phone-based interactions or complex > project analysis and dump analysis issues. Issues of this nature are best > handled working with a dedicated Microsoft Support Engineer by contacting > Microsoft Customer Support Services (CSS) at > http://msdn.microsoft.com/subscriptions/support/default.aspx. > ================================================== > This posting is provided "AS IS" with no warranties, and confers no rights. > >
Gary,
No, I'm using VS2005. I'll perform a database test and let you know result. Dave. [quoted text, click to view] ""Gary Chang[MSFT]"" wrote:
> Hi Dave, > > Thank for the response! > > It seems you are using the VS2003 to develop that database project, am I > right? > > I have performed some simple tests on my VS2003 database project, it works > well on my side. There is no problem to run my test SQL script on a > non-default referenced database. > > So I suggest you can test another simple database project in your solution > to repro the problem (using some simple test script and some other > databases). If the test database project works OK, then there may be > something corrupted in the database project in question. You may need to > regenerate that database project for a test. > > > Thanks for your understanding! > > Best regards, > > Gary Chang > Microsoft Online Community Support > ================================================== > Get notification to my posts through email? Please refer to > http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif > ications. > ================================================== > This posting is provided "AS IS" with no warranties, and confers no rights. >
Using VS2005 I've created a minimal solution.
1) created new ASP.NET project using local IIS. 2) Added new database project to the solution. 3) Added a default database. 4) Created a minimal SQL script. 5) Run the script by right-click and selecting RUN - this was OK. 6) Attempted to run the script by right-clicking and selecting RUN ON. At this point VS2005 crashes. Dave. [quoted text, click to view] ""Gary Chang[MSFT]"" wrote:
> Hi Dave, > > Thank for the response! > > It seems you are using the VS2003 to develop that database project, am I > right? > > I have performed some simple tests on my VS2003 database project, it works > well on my side. There is no problem to run my test SQL script on a > non-default referenced database. > > So I suggest you can test another simple database project in your solution > to repro the problem (using some simple test script and some other > databases). If the test database project works OK, then there may be > something corrupted in the database project in question. You may need to > regenerate that database project for a test. > > > Thanks for your understanding! > > Best regards, > > Gary Chang > Microsoft Online Community Support > ================================================== > Get notification to my posts through email? Please refer to > http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif > ications. > ================================================== > This posting is provided "AS IS" with no warranties, and confers no rights. >
Hi Dave,
Thank you posting! [quoted text, click to view] >If I open a script, right-click and select RUN the script >runs ok and generates the stored procedure on the >default database. However, if I select the RunOn >command to run the script on one of the other database >referenced in the project then Visual Studio crashes. Based on y understanding, your script runs well on the default database of your database project, but if it runs in one of the other database referenced in the project, the VS2005 IDE just crashes. If so, does the problem only happen to that specific database of that project? How about any other non-default referenced database? If the problem only occurs to that specific database, have you tried to run that script outside the VS2005 IDE, such as SQL 2005's Management Studio or via the SQLCMD? Is it OK? These information will help us to research your issue, so I appreciate your time in checking them. Let me know the results at your earliest convenience. If you have any questions or concerns, please let me know. I am standing by to help you Thanks! Best regards, Gary Chang Microsoft Online Community Support ================================================== Get notification to my posts through email? Please refer to http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif ications. Note: The MSDN Managed Newsgroup support offering is for non-urgent issues where an initial response from the community or a Microsoft Support Engineer within 1 business day is acceptable. Please note that each follow up response may take approximately 2 business days as the support professional working with you may need further investigation to reach the most efficient resolution. The offering is not appropriate for situations that require urgent, real-time or phone-based interactions or complex project analysis and dump analysis issues. Issues of this nature are best handled working with a dedicated Microsoft Support Engineer by contacting Microsoft Customer Support Services (CSS) at http://msdn.microsoft.com/subscriptions/support/default.aspx. ================================================== This posting is provided "AS IS" with no warranties, and confers no rights.
Hi Dave,
Thank for the response! It seems you are using the VS2003 to develop that database project, am I right? I have performed some simple tests on my VS2003 database project, it works well on my side. There is no problem to run my test SQL script on a non-default referenced database. So I suggest you can test another simple database project in your solution to repro the problem (using some simple test script and some other databases). If the test database project works OK, then there may be something corrupted in the database project in question. You may need to regenerate that database project for a test. Thanks for your understanding! Best regards, Gary Chang Microsoft Online Community Support ================================================== Get notification to my posts through email? Please refer to http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif ications. ================================================== This posting is provided "AS IS" with no warranties, and confers no rights.
Gary,
Yes, the Run_On failed before I had the option to select either the default or any other databases. My database project was the default SqlServer project. On this machine I have SqlServer 2000 installed which was set up as the default database for this project. I also have an MSDE database installed on this machine (not using for this work) plus I can see quite a few other networked databases of various flavours. My IDE version is Microsoft Visual Studio 2005 Version 8.0.50727.42 (RTM.050727-4200) Microsoft .NET Framework Version 2.0.50727 Installed Edition: Enterprise Microsoft Visual Basic 2005 Microsoft Visual Basic 2005 Microsoft Visual C# 2005 Microsoft Visual C# 2005 Microsoft Visual C++ 2005 Microsoft Visual C++ 2005 Microsoft Visual J# 2005 Microsoft Visual J# 2005 Microsoft Visual Studio Tools for Office Microsoft Visual Studio Tools for the Microsoft Office System Microsoft Visual Web Developer 2005 Microsoft Visual Web Developer 2005 Visual Studio 2005 Team Edition for Developers Microsoft Visual Studio 2005 Team Edition for Software Developers Crystal Reports AAC60-G0CSA4B-V7000AY Crystal Reports for Visual Studio 2005 Regards, Dave. [quoted text, click to view] ""Gary Chang[MSFT]"" wrote:
> Hi dave, > > Thanks for the detailed response! > > It seems the "Run On" operation failed even on a default database, is it? > > Would you please tell me which the version of your VS2005 product? > > We have some problems to repro the issue on our side, we test the database > project with the Visual Studio 2005 Team System, but we are unable to find > the "Run" and "Run As" option in the test script's context menu. > > Our test database project is created from a default SQL Server Project, is > there any difference with your project? > > Thanks! > > Best regards, > > Gary Chang > Microsoft Online Community Support > ================================================== > Get notification to my posts through email? Please refer to > http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif > ications. > ================================================== > This posting is provided "AS IS" with no warranties, and confers no rights. > >
Hi dave,
Thanks for the detailed response! It seems the "Run On" operation failed even on a default database, is it? Would you please tell me which the version of your VS2005 product? We have some problems to repro the issue on our side, we test the database project with the Visual Studio 2005 Team System, but we are unable to find the "Run" and "Run As" option in the test script's context menu. Our test database project is created from a default SQL Server Project, is there any difference with your project? Thanks! Best regards, Gary Chang Microsoft Online Community Support ================================================== Get notification to my posts through email? Please refer to http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif ications. ================================================== This posting is provided "AS IS" with no warranties, and confers no rights.
Hi Dave,
Thanks for the detailed information! [quoted text, click to view] >Installed Edition: Enterprise >... >Visual Studio 2005 Team Edition for Developers >Microsoft Visual Studio 2005 Team Edition for Software Developers Would you please tell me which the VS2005 edition you use now? Thanks! Best regards, Gary Chang Microsoft Online Community Support ================================================== Get notification to my posts through email? Please refer to http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif ications. ================================================== This posting is provided "AS IS" with no warranties, and confers no rights.
Gary,
If you bring up the script's context menu by right-clicking in the editor window you only get the RUN command. If you right-click in the Solution Explorer tree then you get both the RUN and RUN-ON commands. Dave. [quoted text, click to view] ""Gary Chang[MSFT]"" wrote:
> Hi dave, > > Thanks for the detailed response! > > It seems the "Run On" operation failed even on a default database, is it? > > Would you please tell me which the version of your VS2005 product? > > We have some problems to repro the issue on our side, we test the database > project with the Visual Studio 2005 Team System, but we are unable to find > the "Run" and "Run As" option in the test script's context menu. > > Our test database project is created from a default SQL Server Project, is > there any difference with your project? > > Thanks! > > Best regards, > > Gary Chang > Microsoft Online Community Support > ================================================== > Get notification to my posts through email? Please refer to > http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif > ications. > ================================================== > This posting is provided "AS IS" with no warranties, and confers no rights. > >
Hi,
It's Team Edition for Software Developers. Regards, Dave. [quoted text, click to view] ""Gary Chang[MSFT]"" wrote:
> Hi Dave, > > Thanks for the detailed information! > > >Installed Edition: Enterprise > >... > >Visual Studio 2005 Team Edition for Developers > >Microsoft Visual Studio 2005 Team Edition for Software Developers > > Would you please tell me which the VS2005 edition you use now? > > Thanks! > > Best regards, > > Gary Chang > Microsoft Online Community Support > ================================================== > Get notification to my posts through email? Please refer to > http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif > ications. > ================================================== > This posting is provided "AS IS" with no warranties, and confers no rights. > >
Hi
It is "Microsoft Visual Studio Team Edition for Software Developers" Dave. [quoted text, click to view] ""Gary Chang[MSFT]"" wrote:
> Hi Dave, > > Thanks for the detailed information! > > >Installed Edition: Enterprise > >... > >Visual Studio 2005 Team Edition for Developers > >Microsoft Visual Studio 2005 Team Edition for Software Developers > > Would you please tell me which the VS2005 edition you use now? > > Thanks! > > Best regards, > > Gary Chang > Microsoft Online Community Support > ================================================== > Get notification to my posts through email? Please refer to > http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif > ications. > ================================================== > This posting is provided "AS IS" with no warranties, and confers no rights. > >
Hi Dave,
We have performed some test on our local VSTD 2005, do not find the "Run" and "Run On" command in a genuine VS2005 database project. But If upgrade a VS2003' database project to VS2005 and open it VS 2005, then those commands appears and the "Run On" command works well on our machines. I use the SQL Server 2005 with my tests. Since you have mentioned both of your machines have the same problem, is it possible the problem related to the SQL Server? I suggest you try some other types' databases for a test, such as the SQL Server 2005 or Access database. Thanks! Best regards, Gary Chang Microsoft Online Community Support ================================================== Get notification to my posts through email? Please refer to http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif ications. ================================================== This posting is provided "AS IS" with no warranties, and confers no rights.
That's great, Dave!
I am glad to know you have already resolved the problem. Based on your resolution, it seems you database connection's configurarion had beed corrupted, and the VS2005 cache that problematic configuration and cannot to update due to some reason. The VS2005 user specific configuration and settings are cached in the ..\Documents and Settings\username\Application Data\Microsoft\Visual Studio\ folder. So if you delete that folder, it will force the VS2005 to generate a new one which has the current updated database connection's configuration. But I am afraid there is no option inside VS2005 to achieve this. It seems to be a product issue and I will report it to our corresponding product team for review. Thanks for sharing this valuable workaround with us. Have a nice day! Best regards, Gary Chang Microsoft Online Community Support ================================================== Get notification to my posts through email? Please refer to http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif ications. ================================================== This posting is provided "AS IS" with no warranties, and confers no rights.
Gary,
All of my projects originate from VS2005 as I have never installed or used VS2003. When adding a database project I am prompted to select a database from a list. I noticed that in the list there are some references to databases that don't exist anymore. I'VE NOW PURGED THIS LIST AND THIS HAS FIXED THE PROBLEM. Selecting the RunOn command now brings up the list of available databases. The way I purged the list was to delete the folder ......\Application Data\Microsoft\VisualStudio Is there a better way of purging this list? Anyway, thank you for your help. Regards, Dave.
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |