objRS.Open parameters

[Grahammer]

Are the values of adOpenForwardOnly and adLockOptimistic assigned
automatically on the server or should I be preloading these with their
numeric equivilents? Where can I find a list of these equivilents. (Lots of
hits on Google, but not for what I'm looking for)

objRS.Open "SELECT * FROM tblDenied", objConn,adOpenForwardOnly
,adLockOptimistic

Thanks!

[Ken Schaefer]

Actually, it doesn't need to be in the Application_OnStart() event handler.
You can put it anywhere in your global.asa file.

Cheers
Ken


"Grahammer" <postmaster@127.0.0.1> wrote in message
news:elvSg7JaDHA.2932@tk2msftngp13.phx.gbl...
: As usual... You never find the answer until 10 seconds after asking the
: question...
:
: ...add the following line in the Application_OnStart event handler of the
: GLOBAL.ASA file:
: <!-- METADATA TYPE="TypeLib" FILE="C:\Program Files\Common
: Files\system\ado\msado15.dll" -->
:
: Please, let me know if I'm wrong (or there's a better way)
:
: Thanks!
:
:
: "Grahammer" <postmaster@127.0.0.1> wrote in message
: news:uMqj95JaDHA.2620@TK2MSFTNGP09.phx.gbl...
: > Are the values of adOpenForwardOnly and adLockOptimistic assigned
: > automatically on the server or should I be preloading these with their
: > numeric equivilents? Where can I find a list of these equivilents. (Lots
: of
: > hits on Google, but not for what I'm looking for)
: >
: > objRS.Open "SELECT * FROM tblDenied", objConn,adOpenForwardOnly
: > ,adLockOptimistic
: >
: > Thanks!
: >
: >
:
: