How to Execute an Object Query in MS Access using C#?

Question

I have an Object Query in MS Access named "getLicense" that will execute the following:

SELECT * FROM tblLicense;

In my C# WinForm Application, I'm trying to execute the "getLicense" Object Query in MS Access through these codes:

/***This does not work***/
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.CommandText = "getLicense";
myReader = myCommand.ExecuteReader();
myReader.Read();
/************************/

/****This is working*****/
myCommand.CommandType = CommandType.Text;
myCommand.CommandText = "SELECT * FROM tblLicense";
myReader = myCommand.ExecuteReader();
myReader.Read();
/************************/

I want to manage my Queries in MS Access DB through Object Queries and not in the hard coded query in C# that's why I'm trying to use the CommandType.StoredProcedure.

Here is the exception

ERROR [42000] [Microsoft][ODBC Microsoft Access Driver] Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.

do you get an exception? if so, what is the exception you get? — Zohar Peled
– Zohar Peled, Commented Mar 29, 2015 at 7:22
possible duplicate of OleDbCommand Stored Procedure Cannot Find Access Query — user585968
– user585968, Commented Mar 29, 2015 at 7:23
Did you try myCommand.CommandText = "Exec getLicense" with commandtype as text — Anup Sharma
– Anup Sharma, Commented Mar 29, 2015 at 7:28

Wennie Valles Sasotona · Accepted Answer · 2015-03-29 09:46:31Z

2

It is like an execution of the MSSQL Server Stored Procedure, I have replaced the:

myCommand.CommandText = "getLicense";

with this:

myCommand.CommandText = "EXEC getLicense";

answered Mar 29, 2015 at 9:46

community wiki

Wennie Valles Sasotona

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to Execute an Object Query in MS Access using C#?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related