Access Query with multiple params via ASP using ADO 
Author Message
 Access Query with multiple params via ASP using ADO

I have an Access query which takes 3 parameters.

User_ID
Start_Date
End_Date

This query works fine in Access, and prompts me for each
of the three values, then returns the recordset.

When trying to run the query from an ASP, I keep getting
errors with my ADO parameter object. "Parameter object is
improperly defined. Inconsistent or incomplete information
was provided." Every book that I have shows a different
way to create the Parameter object, some SQL Server
specific, and none use more than one parameter.

Does anyone have any examples of doing something like this?

I am trying to run the Query like a SQL stored proc (in
the data tier). I know how to make this work by moving the
SQL statement directly into my ASP, but I wanted to try
something new.

Thanks,

Ken



Mon, 29 Dec 2003 05:25:50 GMT  
 Access Query with multiple params via ASP using ADO
Nevermind. I figured this out. I was just being dumb. Typo
in my Parameter object was one of many problems I was
having. Need more caffeine. :-)

Ken

Quote:
>-----Original Message-----
>I have an Access query which takes 3 parameters.

>User_ID
>Start_Date
>End_Date

>This query works fine in Access, and prompts me for each
>of the three values, then returns the recordset.

>When trying to run the query from an ASP, I keep getting
>errors with my ADO parameter object. "Parameter object is
>improperly defined. Inconsistent or incomplete
information
>was provided." Every book that I have shows a different
>way to create the Parameter object, some SQL Server
>specific, and none use more than one parameter.

>Does anyone have any examples of doing something like
this?

>I am trying to run the Query like a SQL stored proc (in
>the data tier). I know how to make this work by moving
the
>SQL statement directly into my ASP, but I wanted to try
>something new.

>Thanks,

>Ken
>.



Mon, 29 Dec 2003 09:30:07 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. ADO vs DAO for Access Queries via ASP

2. ADO vs DAO for Access Queries via ASP

3. Wild Card queries on ACCESS using ADO in ASP

4. using access queries via ado or odbc

5. using access queries via ado or odbc

6. Connecting to Access via ASP - ADO/ODBC

7. Accessing MSysObjects via ASP and ADO

8. Passing a parameter to access via ADO and ASP

9. Passing Parameter to Query using ASP/ADO

10. Calling query using VBA function via ASP


 
Powered by phpBB® Forum Software © phpBB Group