Cannot see SQL Server instance

  • Thread starter Thread starter Dan Aldean
  • Start date Start date
D

Dan Aldean

Hi,

I have an old application that was running OK. After I had to reformat my HD
I installed .NET 2001 and SQL Server 2000.
The old application does not work with the DB anymore. As now Security for
SQL Server i sonly Windows based I changed the ConnectionString of the
connection object accordingly. It shows data in the datagrid but when I
tried to update or insert a new record a message pops up:
An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred
in system.data.dll
Additional information: System error.

If I try to place a connection object on the form, the dialog windows
doesn't see the databases on localhost instance of the database with only
USE WINDOWS NT Integrated Security option checked. But if I try the Server
Explorer Tool and drag the table on the form everything is OK

Thanks
 
Hi,

Dan Aldean said:
Hi,

I have an old application that was running OK. After I had to reformat my
HD I installed .NET 2001 and SQL Server 2000.
Click to expand...

..net 2001 ?
The old application does not work with the DB anymore. As now Security for
SQL Server i sonly Windows based I changed the ConnectionString of the
connection object accordingly. It shows data in the datagrid but when I
tried to update or insert a new record a message pops up:
An unhandled exception of type 'System.Data.SqlClient.SqlException'
occurred in system.data.dll
Additional information: System error.
Click to expand...

Can you post your connection string, apparentely you have problem with it.
 
Thanks Ignatio for the reply.
It is .NET 1.0.

The connection string is:
data source=YOUR-136F2019MF\LOCALHOST;initial catalog=MyDatabase;integrated
security=SSPI;persist security info=True;workstation
id=YOUR-136F2019MF;packet size=4096
 
Back
Top