Time out Expired in SQL7 with .NET 2

[rmhewa]

I have one of my c# applications coded using .net framework 1.1, which works fine. Recently I installed Visual Studio 2005 - Professional edition on the same machine (Arter formating and reinstalling Windows 2000 with SP4) and now the above application takes a long time to open the connection to SQL Server 7. My connection string is as follows "user id=sa;password=;initial catalog=FINISHED_GOODS_STOCK;data source=naturubmain;Connect Timeout=30" Once I try to open the connection it gave me 'Time out expired' error. I set the 'Connect Time out' to 0 just to find how long does it take to open the connection. It took above 1 minute and opend the connection. Pls help me. Withot fixing this I will not be able to enjoy the new features of VS2005

[Frank Kerrigan]

It looks like your not getting a connection to your SQL server. YOu also might want to try and add an Instance name to your connection string. "user id=sa;password=;initial catalog=FINISHED_GOODS_STOCK;data source=naturubmain\DEFAULT;Connect Timeout=30" Try and create a test connection windows ODBC tool.

[rmhewa]

Thanks for your advice. Later I found the problem was with the name resolving of our network. I replaced the server name with the IP address of the server in the connection string and now its working fine. :)