February 6, 2003 at 2:34 pm
I have a single user app. that I want to reduce potential problems involving complex sql queries. It has been reccommended that I append this string to end of connection string
"OLE DB Services=-2;Use Procedure for Prepare=0" & ";"
Here is the explanation:
"Parameter "Use Procedure for Prepare=0;" disables automatically wrapping executed queries into preparing stored procs as sp_prepare, sp_execute. With this param your queries will be send to sql-server as they have been written by you. Without this param the most of queries will be wrapped into those system stored procs (for caching) before execution and some problems may raise.
Parameter "OLE DB Services=-2;" disables connection pooling and help to avoid some problems with incorrect purging of used resources when a connection is returning from the pool. Connection pooling is useful for intensive server applications as WEB-server but one is absolutely useless in single applications and may cause some problems."
any comments on this?
any other reccommended parameters?
Brian Lockwood
LockwoodTech Software
Brian Lockwood
President
ApexSQL - SQL Developer Essentials
February 6, 2003 at 4:58 pm
Dont see where connection pooling will matter to you one way or the other.
Andy
February 7, 2003 at 8:13 am
yes Andy, I realize I don't need it.
But the idea is that if something ISN'T needed and the reference/library can be ingored totally, and if there is a possibility that it could cause problems in some cases, then there is an advantage to EXPLICITLY ignore it.
What I have found over the years is that a lot of the additional overhead, whether needed or not, includes additional failure points.
getting a stripped down connection that will just sling unadulterated sql at the server is the goal.
Brian Lockwood
LockwoodTech Software
Brian Lockwood
President
ApexSQL - SQL Developer Essentials
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply