Connection.Open Slow in Compiled Code

I've come across a really obscure issue in my VB6/ADO/SQLExpress 2005 app.

In brief, I have several objects/classes in a COM dll that are populated via factory methods that get data from the database into a recordset object and then use this to fill the properties of the objects.

This is very standard stuff and works fine except for one particular factory method. When this method calls out to my Connect utility method which actually connects to the database, the ADO Connection.Open method is taking around a second to return. All other calls via this utility method are almost instantaneous.

Even more weird, this only occurs in completely compiled code. If I call the (compiled) data access dll from my UI app in the IDE, the call works fine. If I call the data access dll in the IDE from the compiled UI app, the call works fine. However, if BOTH are compiled I get the 1 second delay, but ONLY when the connect utility method is called by one particular factory method, not by any of the others. The utility method takes no parameters, BTW, so it should make no difference whatsoever what or who is calling it.

Any ideas? This is really affecting the performance of my app.

TIA

Rob

--
"I met a Welsh-Czech interpreter once, but I don't think that was his full-time job"
Random Blog Comment May 12, 2007 06:53 PM

.

Loading