Is 3 here adOpenStatic?

  • Thread starter Thread starter George Hester
  • Start date Start date
The reason I asked really has nothing to do with Access. I wanted to use this named constant in a ASP page. The way to do that is:

<!-- metadata type="typelib" file="C:\Program Files\Common Files\System\ado\msado15.dll" -->

in the ASP if in fact the constant adOpenStatic is in that file. It is but I was just wondering if how they used the 3 in that article was that 3 given by adOpenStatic in msado15.dll and not from some other dll like sqloledb.dll maybe. That's why I asked here. I figured the Access Ado experts would know.
 
George Hester said:
The reason I asked really has nothing to do with Access. I wanted to
use this named constant in a ASP page. The way to do that is:

<!-- metadata type="typelib" file="C:\Program Files\Common
Files\System\ado\msado15.dll" -->

in the ASP if in fact the constant adOpenStatic is in that file. It
is but I was just wondering if how they used the 3 in that article
was that 3 given by adOpenStatic in msado15.dll and not from some
other dll like sqloledb.dll maybe. That's why I asked here. I
figured the Access Ado experts would know.
Click to expand...

I'm not an ADO expert, since I mainly use DAO, but I looked in the ADO
help file for the Recordset.Open method before writing my original
reply, and found that the "3" in the statement you quoted is in the
position of the CursorType argument, for which adOpenStatic is an
appropriate value. Hence my conclusion.
 
Thanks Dirk that helps me to confirm now that is in fact what Microsoft intended with that 3. I have never used adOpenStatic before. I need to try to figure out why they used that CursorType instead of some other.
 
Make sure that your webserver has the ADO file in the same location ... I
speak from the experience of an afternoon's worth of frustration until I
finally found that the Program Files directory was actually on E: drive ...
the person who built the server decided on non-default areas for these
items, with the hopes of making the web server more difficult for hackers
and script kiddies.

--
Scott McDaniel
CS Computer Software
www.thedatabaseplace.net

The reason I asked really has nothing to do with Access. I wanted to use
this named constant in a ASP page. The way to do that is:

<!-- metadata type="typelib" file="C:\Program Files\Common
Files\System\ado\msado15.dll" -->

in the ASP if in fact the constant adOpenStatic is in that file. It is but
I was just wondering if how they used the 3 in that article was that 3 given
by adOpenStatic in msado15.dll and not from some other dll like sqloledb.dll
maybe. That's why I asked here. I figured the Access Ado experts would
know.
 
Back
Top