AppHung in SQL Server (SQLEXPRESS)

Good morning, the below is the error I keep getting each time I try to create/connect to a database using Visual Studio 2005. I upgraded from VS 2003 Professional to VS 2005 Professional. My OS is XP. Programming language is C#.

szAppName : devenv.exe szAppVer : 8.0.50727.42 szModName : hungapp

szModVer : 0.0.0.0 offset : 00000000

[374 byte] By [bthumber] at [2008-2-28]
# 1

per the support engineer...

From the post, it seems that the Visual Studio 2005 IDE environment hangs (devenv.exe is Visual Studio 2005 IDE application name). What did you do at that time? Could you provide more details on this issue such as the detailed steps and code to reproduce the problem? As I understand, Visual Studio 2005 and SQL Server 2005 Express are installed on the same Windows XP computer, right?

-brenda (ISV Buddy Team)

MSISVBuddyTeam at 2007-9-8 > top of Msdn Tech,Microsoft ISV Community Center Forums,ISV Open Discussions...
# 2

Good morning

Thanks for responding, the apphang occurred when I tried to connect to a database using VS 2005.

Brent

bthumber at 2007-9-8 > top of Msdn Tech,Microsoft ISV Community Center Forums,ISV Open Discussions...
# 3

Hi Brent,

The engineer needs more details to continue his research on your issue.

The exact reproduction steps will help us with correct direction we should go further.

Are Visual Studio 2005 and SQL Server 2005 Express are installed on the same Windows XP computer?

How do you connect to the database in Visual Studio 2005?

Do you use Server Explorer or C# code?

Please post your repro steps and I'll make sure that the engineer get's the information.

thanks,

-brenda (ISV Buddy Team)
MSISVBuddyTeam at 2007-9-8 > top of Msdn Tech,Microsoft ISV Community Center Forums,ISV Open Discussions...
# 4

Thank you for looking into this for me. Visual Studio and Sql Server 2005 Express are installed on the same Windows XP computer. I was connecting to the database in Visual Studio 2005. At the time I was using the Server Explorer to connection to a database.

Brent

bthumber at 2007-9-8 > top of Msdn Tech,Microsoft ISV Community Center Forums,ISV Open Discussions...
# 5

Hi Brent,

Here's the latest from the support engineer:

As we confirmed, Visual Studio 2005 IDE crashes when you use Server Explorer to connect to SQL Server database.

Usually when I encounter such problem, I would perform the following steps.

Please help me collect the following information exactly. Missing one would deter our troubleshooting progress.

1. Use sqlcmd utility or Management Studio to connect the SQL Server database. Make sure it works fine.

2. If the problem still occurs, try to repair or reinstall Visual Studio 2005.

3. Make sure that Windows XP is applied with latest service pack.

4. Boot into Windows XP Safe Mode. Check if the problem occurs.

5. Does the problem occur randomly or always repro?

NOTE: In addition, usually formatting the system and reinstalling from scratch are the quickest method to resolve the problem. If possible, I would backup the system and reinstall the system and application.

Please let us know if you're able to resolve the issue with these steps and if not give us the results for each step so that the engineer can troubleshoot this further.

-brenda (ISV Buddy Team)

MSISVBuddyTeam at 2007-9-8 > top of Msdn Tech,Microsoft ISV Community Center Forums,ISV Open Discussions...
# 6
Hi,
I am also facing the same problem during installation of VS 6. I had VS 6 . I uninstalled it and
tried to install the VC 2005 express edition. But due to some problem like XP older version of service pack I couldn't install it.

So I again tried to reinstall the VS 6. During the 'Searching for installed component' I am getting this error message.

szAppName : ACMSETUP.EXE szAppVer : 3.1.0.8043 szModName : hungapp
szModVer : 0.0.0.0 offset : 00000000

Please help me. What shell I do

-MKR

developer at 2007-9-8 > top of Msdn Tech,Microsoft ISV Community Center Forums,ISV Open Discussions...