new to asp and ado from dao and vb, can't open mdb/recordset

[Bob Barrows]

It's got nothing to do with your connection string. An asp pabe knows
nothing about the ADO constants (adOpenDynamic, etc.)
unless you tell it about them. One way is via the adovbs.inc file which you
can "include" in your page via a #include statement. A better way is
discussed here: [url]http://www.aspfaq.com/show.asp?id=2112[/url].

You should also take a look at these articles because I can practically
guarantee that you will run into this problem next:
[url]http://www.aspfaq.com/show.asp?id=2062[/url] - updatable cursor
[url]http://www.aspfaq.com/show.asp?id=2009[/url] - 80004005 errors

HTH,
Bob Barrows

bbxrider wrote:

> trying to open an existing access2000 .mdb existing table with asp
> am using this code
>
> <script language="vbscript" runat="server">
> const adOpenDynamic =2
> const adLockOptimistic =3
> const adCmdTable =2
> private rs
> private firstname, lastname
> dim strDbConnection
> strDbConnection = "provider=microsoft.jet.oledb.4.0;" & _
> "data source=e:\inetput\wwwroot\webasp\volunteer.mdb"
> set rs = createobject("adodb.recordset") (THIS IS LINE 21)
> rs.open "volunteerPrimary", strDbConnect, adOpenDynamic,
> adLockOptimistic, adCmdTable
>
> get this error on the returned web page
> Error Type:
> ADODB.Recordset (0x800A0BB9)
> Arguments are of the wrong type, are out of acceptable range, or are
> in conflict with one another.
> /webasp/phsVolunteerData.asp, line 21
>
> can't find any other error info in the server logs, actually not sure
> if am looking at the right log there are so many, i've checked the
> logs for the server and the virtual website
>
> anybody know why this won't open
>
> where do i find which provider string to use??? i know its access,
> but where is the property that lets me know i'm using say
> 'jet.oledb.4.0' or if mysql that provider string
>
> appreciate any help and also suggestions for the better ado manuals,
> i'm sure theres plently out there

[Mosley]

Ahhharrr set rs = createobject("adodb.recordset")

you are making the object on the clinet computer

you need

set rs = server.createobject("adodb.recordset")


"bbxrider" <bbxrider1@comcast.net> wrote in message
news:%23eH42DBRDHA.3768@tk2msftngp13.phx.gbl...

> trying to open an existing access2000 .mdb existing table with asp
> am using this code
>
> <script language="vbscript" runat="server">
> const adOpenDynamic =2
> const adLockOptimistic =3
> const adCmdTable =2
> private rs
> private firstname, lastname
> dim strDbConnection
> strDbConnection = "provider=microsoft.jet.oledb.4.0;" & _
> "data source=e:\inetput\wwwroot\webasp\volunteer.mdb"
> set rs = createobject("adodb.recordset") (THIS IS LINE 21)
> rs.open "volunteerPrimary", strDbConnect, adOpenDynamic, adLockOptimistic,
> adCmdTable
>
> get this error on the returned web page
> Error Type:
> ADODB.Recordset (0x800A0BB9)
> Arguments are of the wrong type, are out of acceptable range, or are in
> conflict with one another.
> /webasp/phsVolunteerData.asp, line 21
>
> can't find any other error info in the server logs, actually not sure if

am

> looking at the right log there are so many, i've checked the logs for the
> server and the virtual website
>
> anybody know why this won't open
>
> where do i find which provider string to use??? i know its access, but
> where is the property that lets me know i'm using say 'jet.oledb.4.0' or

if

> mysql that provider string
>
> appreciate any help and also suggestions for the better ado manuals, i'm
> sure theres plently out there
>
>
>