Thursday, February 16, 2012

Cant connect to SQL Server

I've installed successfuly (?) both Sql Server 2000 and VS.NET 2002 many times, but now I'm not being able to connect to Sql Server from VS.NET by any means (i.e. Server Explorer, SqlDataAdpters, etc.).

Enterprise Manager and Query Analyzer work perfectly.

The error messages I'm getting are the following:

1.
devenv.exe - Unable to Locate Component
This application has failed to start because MSVCR71.dll was not found. Re-installing
the application may fix this problem.

2.
Server Explorer
Unable to add data connection.
Some program files are not properly registered on your machine. Rereun the setup program.

After getting this, I've tried to re install everything, even the OS from scratch, but cannot get a successful connection at all. I've tried everything.

Someone please tell me he or she has worked this out...

Thanks will be very much appreciated.Can you locate msvcr71.dll under the v1.1 install directory? If yes can you try adding the path to the install folder to the "PATH" variable and try opening devenv again. If you don't find the assembly you should probably try and repair vs.net.

Hope that helps
Kashif

No comments:

Post a Comment