C# .Net SQL Server Connections

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

chodge - 26 Mar 2008 18:40 GMT

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?

Reply to this Message

Ignacio Machin ( .NET/ C# MVP ) - 26 Mar 2008 18:52 GMT

> 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
[quoted text clipped - 4 lines]
> 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?

Reply to this Message

vo1d - 26 Mar 2008 20:52 GMT

hi chodge,
is your operation synchronous or asynchronous?

Reply to this Message

sloan - 27 Mar 2008 00:25 GMT

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.

>I have created an app in VS 2005 C# using .Net connecting to a corporate
>SQL
[quoted text clipped - 9 lines]
> operations
> have actually completed?

Reply to this Message

C# .Net SQL Server Connections

Free Magazines