InfoPath Dev

I created a secondary connection to a sql server db using sql authentication that works fine on my pc, when i published the form to SP 2007, i get "failed to connect to data source'  with the following details:

The query cannot be run for the following DataObject: Comet Units
InfoPath cannot run the specified query.
InfoPath cannot connect to the data source.
Access is denied.
Access is denied.

what did i do wrong, any suggestions would be greatly appreciated.

TIA
Dean

It might be cross domain issue. The InfoPath form is trying to retrieve dats that is hosted in a different domain. Can you give your form full trust and try again? or try changing the data connection to Universal Data connection format...

Hope that helps!

Thanks for the suggestion, how to i change the connection to UDC?

Here is another post about cross domain issues.