none
ADO.net connection corruption RRS feed

  • Question

  • We have an vb.net WebService that is having problems when put under a heavy load.

    it works like this.

    Clients submit data for a inventory transaction as XML data.

    I create a new sqlConnection(pooling =false)

    I create and start SqlTransaction

    I call a lower level dll passing in the sqlConnection/SqlTransation created in the WebService.

    If the lower level process works I commit the transaction and close the connection then dispose of both.

    if the lower level process fails I roll back and close the connection then dispose both.

    All works fine until mutilpe clients start sending in data for a trx

    When 2 or more trx try to execute at the same time we get all kinds of errors from several differnt points in the webService and lower level object.  Here are a couple examples;

    "Timeout expired.

    The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached."

    "The SqlCommand is currently busy Open, Fetching. "

    "The ConnectionString property has not been initialized. "

    "General network error"

    "'select srvname from sysservers where isremote = 0' query FAILED"

     

    If they get an error and resubmit the trx will work fine.

    We have been working on this for long time.  Any advice?

     

    Thanks,

    John

    Friday, July 13, 2007 6:36 PM