InfoPath Dev

 Yes, you can do this. For a browser-enabled form you will need to create a webservice to be the middle man between the InfoPath form and the database. I'm not sure if I asked you this before - but do you have any programming experience? I used the following to teach myself how to create a webservice for my InfoPath ...

can you show some code? I've done this and got similar issues, you have to specify the credentials the web service is going to use.

I won't suggest returning any results from the trigger unless you are ok with making changes to the code when the feature is deprecated. as per the BOL the option will be deprecated in the future versions.