InfoPath Dev

Hi, I am new to InfoPath and also tot his forum.
I have created a form in InfoPath which uses the database in SQL Server. The form is working fine.
But when i share the form with other users, who do not have access to the SQL Server database, its giving an error such as "Login failed".
Is there any way where i can make the connection to the database as default(i.e using my login credentials) when the shared users try to poen the form.

Thanks.

Hi schikkam and welcome to InfoPathDev!

It appears that there may be an issue with the credentials for the users who are trying to use that form.

Here are some posts that might be helpful and get you started in the right direction:

http://infopathdev.com/forums/topic.asp?TOPIC_ID=1946#5851

http://groups.google.com/group/microsoft.public.infopath/browse_thread/thread/633d3eb97b8058ab/810a387ec78e41fc?q=sql+login&rnum=1#810a387ec78e41fc

And this one has information on how you can make sure that your login credentials are saved:

http://groups.google.com/group/microsoft.public.infopath/browse_thread/thread/9b9c5be47155069d/ba35ded54805935b?q=sql+login&rnum=8#ba35ded54805935b

Hope that helps!

Ted

Thanks a lot!!!!!!That helps.

I am having a similar problem to the issues discussed in previous forums. I followed the solutions, but without any luck. These forums were

On my machine everything works great with my Infopath form that is connected to a SQL database. When I share the form, or if if another user accesses the form, they are prompted with a SQL Server login diolog box. You can choose the database from the dropdown list, which isn't a problem and it will let you write to the database. The problem is the login box prompts after each form submission and the speed if very slow. I do not get the dialog box from my machine.

Any ideas would be greatly helpful.

Thanks.