C# .Net SQL Server Connections

[chodge]

I have created an app in VS 2005 C# using .Net connecting to a corporate SQL
2000 Server. When connecting at the main office all is well. When connecting
from one of our remote locations the connection is slow (T1). This results in
inacurate data being displayed after GetData and Fill operations. My
assumption is that the app believes the operations are complete before they
really are and then executes the code following the GetData and Fill
statements. Is there a way to trigger code execution after these operations
have actually completed?

 

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

I have created an app in VS 2005 C# using .Net connecting to a corporate SQL
2000 Server. When connecting at the main office all is well. When connecting
from one of our remote locations the connection is slow (T1). This resultsin
inacurate data being displayed after GetData and Fill operations. My
assumption is that the app believes the operations are complete before they
really are and then executes the code following the GetData and Fill
statements. Is there a way to trigger code execution after these operations
have actually completed?

Hi,

That's weird, you should get an error if anything happens during
transmission.
What kind of inacuracy are you taking about?

 

[vo1d]

hi chodge,
is your operation synchronous or asynchronous?

 

[sloan]

Experiment with using tcp/ip vs named pipes for vice versa.

http://support.microsoft.com/kb/238949

Google
dbmssocn
as well.

You need to put it IN the connection string.

dbmssocn is the tcp/ip one. Which would be my first try.

...

You can also supply a hard IP address.
http://www.connectionstrings.com/?carrier=sqlserver
Connect via an IP address
find the above example.