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