Stored Proc - quickest recordset?

[jason]

What is the simplest way to open up a stored query in Access - I'v got this
far but I need to open: qry_Listings
set cnn = Server.CreateObject("ADODB.Connection")
strCon = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" &
Server.MapPath("../database/listings.mdb") '//This one is for Access
2000/2002
cnn.Open strCon

[jason]

Thanks - but throws up an error:

Error Type:
Microsoft VBScript runtime (0x800A01A8)
Object required: 'Provider=Microsoft.J'
/catamaranco/listings/index.asp, line 8

for >>>

set cnn = Server.CreateObject("ADODB.Connection")
strCon = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" &
Server.MapPath("../database/listings.mdb") '//This one is for Access
2000/2002
set rs = strCon.execute("EXEC qry_Listings")

"Aaron Bertrand - MVP" <aa***@TRASHaspfaq.com> wrote in message
news:OR**************@TK2MSFTNGP12.phx.gbl... set rs = strCon.execute("EXEC qry_Listings")

http://www.aspfaq.com/2424#db

"jason" <ja***@catamaranco.com> wrote in message
news:OU**************@tk2msftngp13.phx.gbl...

What is the simplest way to open up a stored query in Access - I'v got

this

far but I need to open: qry_Listings
set cnn = Server.CreateObject("ADODB.Connection")
strCon = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" &
Server.MapPath("../database/listings.mdb") '//This one is for Access
2000/2002
cnn.Open strCon

[Aaron Bertrand - MVP]

> set rs = strCon.execute("EXEC qry_Listings")

Sorry, should be cnn.execute (and it should come *AFTER* cnn.Open strConn).

To avoid confusion, you might use a standard name for the object, and not
bother putting the string into a variable (you don't gain much from that
anyway, since it's only used once).

set conn = createobject("ADODB.Connection")
conn.open "Provider= ..."
set rs = conn.execute("EXEC qry_Listings")
....

[Bob Barrows]

jason wrote:

What is the simplest way to open up a stored query in Access - I'v
got this far but I need to open: qry_Listings
set cnn = Server.CreateObject("ADODB.Connection")
strCon = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" &
Server.MapPath("../database/listings.mdb") '//This one is for Access
2000/2002
cnn.Open strCon

This works as well:

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

[jason]

Thanks.

"Aaron Bertrand - MVP" <aa***@TRASHaspfaq.com> wrote in message
news:uQ**************@TK2MSFTNGP09.phx.gbl...

set rs = strCon.execute("EXEC qry_Listings")
Sorry, should be cnn.execute (and it should come *AFTER* cnn.Open

strConn).
To avoid confusion, you might use a standard name for the object, and not
bother putting the string into a variable (you don't gain much from that
anyway, since it's only used once).

set conn = createobject("ADODB.Connection")
conn.open "Provider= ..."
set rs = conn.execute("EXEC qry_Listings")
...