2.0 DataSet Connection Timeout only on first load?

[Christopher H. Laco]

I'm in a strange situation. I have a dataset that uses it own connection
string from MySettings. All is well. This thing works in .NET just dandy.

If I reference this dataset from another project, and load that project
under IIS6/ASP/2003 using COM, it fails with the folowing error on the
FIRST request only:

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at System.Data.Sql Client.SqlInter nalConnection.O nError(SqlExcep tion exception, Boolean breakConnection )
at System.Data.Sql Client.TdsParse r.ThrowExceptio nAndWarning(Tds ParserStateObje ct stateObj)
at System.Data.Sql Client.TdsParse rStateObject.Re adSniError(TdsP arserStateObjec t stateObj, UInt32 error)
at System.Data.Sql Client.TdsParse rStateObject.Re adSni(DbAsyncRe sult asyncResult, TdsParserStateO bject stateObj)
at System.Data.Sql Client.TdsParse rStateObject.Re adPacket(Int32 bytesExpected)
at System.Data.Sql Client.TdsParse r.ConsumePreLog inHandshake(Boo lean encrypt, Boolean trustServerCert , Boolean& marsCapable)
at System.Data.Sql Client.TdsParse r.Connect(Boole an& useFailoverPart ner, Boolean& failoverDemandD one, String host, String failoverPartner , String protocol, SqlInternalConn ectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert , Boolean integratedSecur ity, SqlConnection owningObject, Boolean aliasLookup)
at System.Data.Sql Client.SqlInter nalConnectionTd s.OpenLoginEnli st(SqlConnectio n owningObject, SqlConnectionSt ring connectionOptio ns, String newPassword, Boolean redirectedUserI nstance)
at System.Data.Sql Client.SqlInter nalConnectionTd s..ctor(DbConne ctionPoolIdenti ty identity, SqlConnectionSt ring connectionOptio ns, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserI nstance)
at System.Data.Sql Client.SqlConne ctionFactory.Cr eateConnection( DbConnectionOpt ions options, Object poolGroupProvid erInfo, DbConnectionPoo l pool, DbConnection owningConnectio n)
at System.Data.Pro viderBase.DbCon nectionFactory. CreatePooledCon nection(DbConne ction owningConnectio n, DbConnectionPoo l pool, DbConnectionOpt ions options)
at System.Data.Pro viderBase.DbCon nectionPool.Cre ateObject(DbCon nection owningObject)
at System.Data.Pro viderBase.DbCon nectionPool.Use rCreateRequest( DbConnection owningObject)
at System.Data.Pro viderBase.DbCon nectionPool.Get Connection(DbCo nnection owningObject)
at System.Data.Pro viderBase.DbCon nectionFactory. GetConnection(D bConnection owningConnectio n)
at System.Data.Pro viderBase.DbCon nectionClosed.O penConnection(D bConnection outerConnection , DbConnectionFac tory connectionFacto ry)
at System.Data.Sql Client.SqlConne ction.Open()
at System.Data.Com mon.DbDataAdapt er.FillInternal (DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Com mon.DbDataAdapt er.Fill(DataTab le[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Com mon.DbDataAdapt er.Fill(DataTab le dataTable)
at SRE.MySummitTab leAdapters.User sTableAdapter.G etUserById(Guid Id)
at SRE.MembershipP roviders.HPMemb ershipProvider. GetUser(String username, Boolean userIsOnline)

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

All subsequent request to this dataset works just fine, so the sql
server IS there, and connecting just dandy.

In this instance above, all the data is doing is returning a single row
using a custom query on the table adapter. The part that throw an
exception the first time is this sequence:
Dim usersAdapter As New MyStuffTableAda pters.UsersTabl eAdapter
Dim users As MyStuff.UsersDa taTable = usersAdapter.Ge tUserById(userI d)
Even if I set the connection manually:
Dim usersAdapter As New MySummitTableAd apters.UsersTab leAdapter
usersAdapter.Co nnection = New Data.SqlClient. SqlConnection(C onfigurationMan ager.Connection Strings("MyStuf f").ConnectionS tring)
Dim users As MySummit.UsersD ataTable = usersAdapter.Ge tUserById(userI d)
it still throws the above timeout error on the first request only.
To make matters ever more strange:
Dim usersAdapter As New MyStuffTableAda pters.UsersTabl eAdapter
Debug.WriteLine (usersAdapter.C onnection.Conne ctionString)
Dim users As MyStuff.UsersDa taTable = usersAdapter.Ge tUserById(userI d)

The second line there prints the correct connection string, the one used
everywhere else... the same one that works for all request but the
first... so the value IS getting loaded... Of course, as soon as we call
the GetUserById method, we get the connection timeout above.. on the
first request.

Just to reinforce matters, on the first request after unloading all
sites fails with the connection timeout errors above, but an SQL
Profiler trace shows not connection attempt is made at all. For the
second and subsqeuent requests, the dataset queries work just fine, and
the SQL profile trace shows their activity.

At this point, I'm stumped. I don't know what is going on, or how to
prevent the data from crapping out on the first request.

Any ideas?

-=Chris