DB connection goes to sleep

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › DB connection goes to sleep

Viewing 0 reply threads
  • Author
    Posts
    • #17104

      Hi,

      I am using biztalk for storing data into a DB. The mechine is 64 bit. I have created 32 bit Host, Host Instance and SQL adapter in 64 bit mechine to handle these database storing.

      When I drop files, thery r many db connection are being open and become sleep. It is not closing after job done. For example if i drop 500 files, its open many connection on db (eg 300) and they all end up as open and sleep. This causing database issue.

      I have same project in 32 bit mechine, I dont have any issue like this. It works fine in 32 bit computer.

      Y this database connection being open locks? How can I fix this?

      Siva

Viewing 0 reply threads
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.