SQL dataconnection

[Rudi Dreir]

Hi NG,

I have a form template (2007) which is published to a forms library in
Windows SharePoint Services 3.0 SP1 (no Forms Server). That form has a data
connection to an SQL-Server which is established when a new form is opened.
The SQL-data connection uses an dedicated username and password. This user
has the necessary rights on the SQL-Server and the database. On most of the
clients (~ 90 %) which are creating a new form (by clicking on the
"new-button" in the forms library) everything is working as expected. But on
some clients I am getting an error message on opening the form. The error
message says that the form couldn't be opened because the data connection
could not be opened (access denied). Any ideas?

 

[Clay Fox]

Hi Rudi.

This could be a network connectivity or how their connectivity is setup.

If you need help troubleshooting or if you would like to see how to interact
with your database via web services (perform better and are more powerful)
let me know.
You can email me here.
http://www.infopathdev.com/members/clayfox.aspx

 

[Rudi Dreir]

Hi Clary,

thank you for your reply.

Implementing a web service to interact with my database is a good idea. I
think this would be a further step. As a first step I want to get the
actually implementation to get to work.

Can you tell me which parameters of the connectivity I have to compare
between the healthy and the faulty clients? I already compared the TCP/IP
configuration. At this point the setup on all clients seems to be ok.

Best regards,

Rudi