Newbie Questions

Re: Problem with Infopath database

Dustin.Klimczak — Thu, 15 Jun 2006 18:29:18 GMT

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.

Re: Problem with Infopath database

schikkam — Thu, 30 Mar 2006 15:28:58 GMT

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

Re: Problem with Infopath database

Ted Fitch — Thu, 30 Mar 2006 05:54:33 GMT

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

Problem with Infopath database

schikkam — Wed, 29 Mar 2006 20:29:15 GMT

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.