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
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]

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]

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.

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")
...