Re: An astonishingly slow DB opening

This just a last info to oracle, and a more explicit question to win2k development, taking aboard a vb developer group.

I have tracked down the problem to the user under which the component in COM+ runs. The package was supposed to run under a local user belonging to the 'Users' group. Changing this to the interactive user or explicitly a domain administrator (which were incidentally the same) makes the very slow first connection disappear (see bottom).

To add insult to injury, logging into the win2k box via term.client as the local user and running the DB connect test app shows a fast connecting time. Hmmm...
This is quite weird behaviour, especially since the same setup shows no sign of problems on a different win2k machine (albeit one running under SP1). Our guess is currently that a subtle change in access rights has occurred to the 'users' group in win2k from SP1 to SP2, but then again the fast application under local user hints at a component issue.

Anybody can comment on this?

Cheers

F Quednau

/* My old POST:
Hello there people,
I am confused and I don't even know to which group to post. I have a win2k SP2 connecting through ADO 2.6 SP1 and Oracle Client 8.1.7 to an Oracle Database 8.1.6

From a VB component in Comp. Services (does not support transaction) I connect through ORAOLEDB.Oracle and it takes me currently almost half a minute (!) to connect first time. After pooling kicks in, the stuff is as I got used to again.
The same connection built into a VB App takes about 2 seconds on the same machine, the sort of number I got used to throughout other setups.

Anyone knows how this sort of behaviour can occur? And while I am here, does the Oracle MTS Service have any relevance in the win2k world of com+ ?

Here the connect thing, indeed unchanged within the component and the application
--> time here

  Set DBCon = New ADODB.Connection
  With DBCon
    .Provider = "OraOLEDB.Oracle"
    .Open "alias", "user", "pwd"
  End With
--> time here. COM + half a minute, application 2 seconds for first
connect. AARGH!
*/ Received on Tue Jul 24 2001 - 07:33:20 CDT