Cannot see SQL Server instance

[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

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

"Dan Aldean" <do*******@rogers.comwrote in message
news:Ox**************@TK2MSFTNGP02.phx.gbl...

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.

..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.

Can you post your connection string, apparentely you have problem with it.
--
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

[Dan Aldean]

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

"Ignacio Machin ( .NET/ C# MVP )" <ignacio.machin AT dot.state.fl.uswrote
in message news:e$*************@TK2MSFTNGP03.phx.gbl...

Hi,

"Dan Aldean" <do*******@rogers.comwrote in message
news:Ox**************@TK2MSFTNGP02.phx.gbl...

>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.

.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.

Can you post your connection string, apparentely you have problem with it.
--
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation