Differences between SqlConnection and OleDbConnection

  • Thread starter Thread starter Anthony Williams
  • Start date Start date
A

Anthony Williams

Good morning,

Our hosting provider has made some changes through the night, and has
inadvertantly caused many of our ASP.NET applications to simply stop working
when it comes to connecting to a database using a SqlConnection.

Problem is, classic ASP apps aren't affected, and neither are ASP.NET apps
where OleDbConnection is used instead of SqlConnection. Wonderful.

We've found out that they've made some changes to their network
configuration, subnets etc... (all above my head really) and I'm just
wondering if there are any differences between OleDbConnections and
SqlConnections that would be affected by these types of change.

Any insight would be grand!

Cheers,
Anthony
 
Johan,

The exception being thrown is:
System.Data.SqlClient.SqlException: Timeout Expired

It appears we've already got our answer though: the problems are being
caused by the fact that the people at our hosting company, whilst doing
routine maintenance, neglected to put the SQL Server back up inside a
firewalled network environment.

D'oh!

The result? The SQL Server machine was infected with the Nachi virus, and
the resulting network garbage traffic that was spewed out was causing
problems with SQL connections.

Our server is still being affected, as are others that are hosted by our
provider, and we're now up to 36 hours of unplanned downtime. Luckily our
backup machine is holding out quite well, so all's not lost.

Thanks again for the reply
Anth
 
Back
Top