SQL Database Integration

Re: Not Able to Pull Data From a SQL Database

Clay Fox — Thu, 29 May 2008 23:01:53 GMT

The basics would be just to set up a new form, with the data connection to load when opened, and then just dump the whole data set on a view as a repeating table to verify the data is being pulled in and the issue is not in script.

Re: Not Able to Pull Data From a SQL Database

David P — Thu, 29 May 2008 21:13:41 GMT

Those were all great suggestions. I checked the security and it is good. I am using a secondary connection and querying it via JScript.

I did try the final suggestion of recreating a form. I got a new error message:
The following error occurred:

'XDocument.DOM.selectSingleNode(...)' is null or not an object
File:script.js
Line:86

I checked to see if my code was sending correct values by setting a XDocument.UI.Alert. The form sees the original variable value (xxxx). It sends the correct SQL to the database. But the database returns no values.

I can forward the form and jscript if you would like to see it.

Re: Not Able to Pull Data From a SQL Database

Clay Fox — Thu, 29 May 2008 20:07:04 GMT

That should not be a problem.

I would verify the permissions on the view in SQL for the user's account, that is the most common.

Is this a secondary connection or a main data connection? Are you actually sending a query parameter?

Another test would be to create a new blank form and see if that works, that would tell you if the issue is in the form or with the connectivity.

Not Able to Pull Data From a SQL Database

David P — Thu, 29 May 2008 19:27:08 GMT

I have created a InfoPath form that queries a datasource for a a user and then auto populates other fields on the form. I orginally designed this using an MS Access database and everything worked perfectly. I changed the datasources to point to a SQL database (The SQL view's structure is identical to the Access table) and now I get no results. Has anyone seen this before?