.net - Exception calling Access 2010 stored select query using OleDb.NET in VB.NET -


i have created , saved named query in access 2010 database 1 parameter. cannot seem able use via vb.net oledb.

here's code i'm using (disregard connection, set correctly - works using non-stored procedures)

dim command new oledb.oledbcommand dim reader oledb.oledbdatareader command.commandtext = "selectuser" command.parameters.addwithvalue("@userid", "1234131") command.commandtype = commandtype.storedprocedure reader = command.executereader 

this code of stored procedure in access 2010:

select users.* users users.user_id=[@userid]; 

when executing .net code, i'm getting following exception: the microsoft access database engine cannot find input table or query 'selectuser'. make sure exists , name spelled correctly.

what doing wrong, me make no sense.

connected wrong copy of database, copy did not contain query.


Comments

Popular posts from this blog

php - Calling a template part from a post -

Firefox SVG shape not printing when it has stroke -

How to mention the localhost in android -