Share connection


Author
Message
Chan
Chan
Advanced StrataFrame User (965 reputation)Advanced StrataFrame User (965 reputation)Advanced StrataFrame User (965 reputation)Advanced StrataFrame User (965 reputation)Advanced StrataFrame User (965 reputation)Advanced StrataFrame User (965 reputation)Advanced StrataFrame User (965 reputation)Advanced StrataFrame User (965 reputation)Advanced StrataFrame User (965 reputation)
Group: Forum Members
Posts: 533, Visits: 2K
Hi,

Is it possible to share connection for all / certain BOs to connect to DB?



Thank you
Reply
Greg McGuffey
Greg McGuffey
Strategic Support Team Member (4.8K reputation)
Group: Forum Members
Posts: 2K, Visits: 6.6K
I'm assuming your talking about connection pooling and not just sharing a data source. ADO does this automatically. The connections do time out at around 5 min (this varies apparently quite a bit) if unused. They also close when you close the application. This means that calling Close() on an open method doesn't actually close the connection. The connection remains open within the connection pool. This is turned on by default, so you'd have to figure out how to turn it off if you didn't want it. Try googling ADO connection pool for the details.
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search