Problems calling Stored Procedure in Access

[Kalisto]

Hi, I have a simple 'sproc' in access. If I run it from access it runs fine.

If I call the same code as a command string from my .net application it also runs and returns the values I'd expect.

If I use the code below to create a parameter set, in an attempt to call as a sproc, then I get the error
"Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done"

I have checked that all the sizes and datatypes match, so any more ideas?

OleDbParameter p = new OleDbParameter("loginName",OleDbType.VarChar,15);
p.Direction = ParameterDirection.Input;
p.Value = tbLoginName.Text;
parameters[0] = p;
		
p = new OleDbParameter("password",OleDbType.VarChar,15);
p.Direction = ParameterDirection.Input;
p.Value = tbPassword.Text;
parameters[1] = p;

p = new OleDbParameter("roles",OleDbType.VarChar,50);
p.Direction = ParameterDirection.Output;
parameters[2] = p;

p = new OleDbParameter("guid",OleDbType.Char,36);
p.Direction = ParameterDirection.Output;
parameters[3] = p;

 

[ca8msm]

I'm not really sure what the problem is (as I try to stay clear of MS Access for any web application) but this article may give you some clues as it includes a simple demo:

http://www.devcity.net/Articles/34/msaccess_sp2.aspx

____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[Kalisto]

Thanks, I got to the bottom of it, it was because I was using output parameters. As soon as I commented those out it worked like a dream.

And FWIW I agree, but the client is on a shoestring, so they say access, I say Oh ok...

Cheers

K

 

[ca8msm]

Oh ok.

There are actually other free databases that work much better if you are looking for a free db (SQL Server Express for example)


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[Kalisto]

Cheers, I'll look into it!