Batch Queries with OLEDB

[H. Williams]

I'm trying to use a batch SQL statement with an OleDbDataReader and the
NextResult method.

I tried: "SELECT Pages FROM Documents ; SELECT Date FROM Orders;"
However, I get the error: "Characters found after end of SQL statement. "
If I try removing the semicolon I get "Syntax Error in Query Expression."

My database is a Microsoft Access 2000 mdb file and the code is running in
ASP.NET.

What am I doing wrong?

 

[Jim Hughes]

Date is a reserved word, use a different column name

or change the query to SELECT [Date] FROM Orders

 

[H. Williams]

Changing Date does NOT make any difference.
Does the ADO.NET not support batch queries with Microsoft Access?

Date is a reserved word, use a different column name

or change the query to SELECT [Date] FROM Orders

I'm trying to use a batch SQL statement with an OleDbDataReader and the
NextResult method.

I tried: "SELECT Pages FROM Documents ; SELECT Date FROM Orders;"
However, I get the error: "Characters found after end of SQL statement.
"
If I try removing the semicolon I get "Syntax Error in Query Expression."

My database is a Microsoft Access 2000 mdb file and the code is running
in ASP.NET.

What am I doing wrong?

 

[H. Williams]

Nevermind, Microsoft's ADO.NET reference states that Microsoft SQL server
supports batch queries, but Oracle and Microsoft Access databases do NOT.

Changing Date does NOT make any difference.
Does the ADO.NET not support batch queries with Microsoft Access?

Date is a reserved word, use a different column name

or change the query to SELECT [Date] FROM Orders

I'm trying to use a batch SQL statement with an OleDbDataReader and the
NextResult method.

I tried: "SELECT Pages FROM Documents ; SELECT Date FROM Orders;"
However, I get the error: "Characters found after end of SQL statement.
"
If I try removing the semicolon I get "Syntax Error in Query
Expression."

My database is a Microsoft Access 2000 mdb file and the code is running
in ASP.NET.

What am I doing wrong?