SQL Database Integration

Re: An error has occurred accessing a datasource

Kevin Wong — Fri, 20 Jul 2007 16:56:43 GMT

Thanks Clay, I'll talk to one of our network guys and see if she can do anything about it.

Re: An error has occurred accessing a datasource

Clay Fox — Wed, 18 Jul 2007 18:12:43 GMT

There could be several reasons for this. If it is working most of the time then I would not think it is a configuration issue.

One could be a network problem or latency that is occuring every so often where the connection is timing out.

It could be an issue on the client or the server processing the request.

Sometimes Internet Explorer/SharePoint can cause problems.

An error has occurred accessing a datasource

Kevin Wong — Wed, 18 Jul 2007 15:12:42 GMT

Hi everybody,

I have a problem. I created a form using infopath 2007. This form use a web service to access a SQL database (2005).
I publish the form and upload it to sharepoint. I can submit it with no error and on the browser it works most of the time, but
once in a while I get an error: "An error has occurred accessing a datasource."

The form has some fields that's being populated by the database (drop-down list box, repeating table, etc.),
so I'm pretty sure I have access to the database.

I don't why I'm getting this error and why it only occur once in a while and not every time.

Any ideas?