.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
Post a Comment