InfoPath Dev

I can run this locally but when I publish it to the sharepoint page I get a System.Data.SqlClient.Sqlclientpermission error. I'm probably not calling my stored proc correctly. I need to call it in the code behind after the submit is pressed. I need to pass 4 parameters and receive the ouput from 1. Can someone point me to, or give me an example of this? Thanks for your help inadvance.

Hi, Welcome to the Forums,

I think this is security issue, check your database permissions once and also check your infopath security level.

Thanks.

Thanks for the response K.Ramana Reddy. I could not resolve the permission problem and after talking to a friend he said the object would not support what I was trying to do. He suggest I create a webservice with the store proc in it and call it. That seems to have corrected my prob. Thanks again