security of xsn files and sql server

[Metin]

XSN files contain many files. One of that is an xsf file. If i use data
connection, this file contains connection string of this connection. I want
to publish my forms over internet. But when user wants to fill a form,
he/she also have my xsn file. So my db connectin string is published. How
can I handle this problem? or I should not to share my forms over internet?

Please help.

Thanks.

 

[Mike Sharp]

That would be true of any client application that makes it's own connections
to SQL Server. I use a web service to talk to the form, and the web service
makes the connections to the DB (after it authenticates the request, and
check the role for authorization).

Regards,
Mike Sharp