https://www.infopathdev.com:443/forums/47.aspxFor questions concerning issues in the integration of SQL and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/125184.aspxMon, 21 Nov 2022 17:09:29 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125184Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/125184.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=125184I would try creating a new data connection - modify the SQL to call the stored procedure, and just try the data connection as is (the new one) to see if data is returned to the form. Put the data fields from the new connection on the form so you can see if data is returned. Compare the schemas of the original data connection to the new one to see if there is any difference in what is being returned.https://www.infopathdev.com:443/forums/thread/125183.aspxMon, 21 Nov 2022 16:27:33 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125183desasaurus0https://www.infopathdev.com:443/forums/thread/125183.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=125183still no luck after clearing the datatype errors. no more errors, but still no data. the command is reporting success in the execution history and examining packets sent to the server shows that the SQL statement is being sent, however the server is not receiving the data.https://www.infopathdev.com:443/forums/thread/125179.aspxFri, 18 Nov 2022 19:58:44 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125179Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/125179.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=125179Oh, I hope so, before this form kills us both. :)https://www.infopathdev.com:443/forums/thread/125178.aspxFri, 18 Nov 2022 19:55:06 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125178desasaurus0https://www.infopathdev.com:443/forums/thread/125178.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=125178on re-checking, the old form has the same error. Apologies, this form is giving me brain damage I think. I did however get a new error about datatypes when trying to run: The query cannot be run for the following DataObject: approvers InfoPath cannot run the specified query. [0x80040E07][Microsoft OLE DB Provider for SQL Server] Error converting data type varchar to numeric. so i think its at least narrowed down to the stored procedure now.https://www.infopathdev.com:443/forums/thread/125177.aspxFri, 18 Nov 2022 19:09:21 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125177Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/125177.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=125177I take it that is from the copy of the template I gave you? In your original, it was still succeeding?https://www.infopathdev.com:443/forums/thread/125176.aspxFri, 18 Nov 2022 18:58:25 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125176desasaurus0https://www.infopathdev.com:443/forums/thread/125176.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=125176the modifysqlquery command was succeding before. now It returns the following error: ModifySqlQuery error: InfoPath has encountered an error. The operation failed.  The form's code contains an error. The following call in the form's code failed: ADOAdapter.Query Operation abortedhttps://www.infopathdev.com:443/forums/thread/125175.aspxFri, 18 Nov 2022 18:50:52 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125175Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/125175.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=125175Can you put the QdabraRules execution history on your form and verify that the Modify SQL Query command for the approvers data connection is returning success? The command is supposed to execute the query, but if GetXml /dsname=approvers isn't returning any data, that would indicate there is no data being returned to the form... I also noted something a bit odd about this data connection in the form's manifest file. It had a xsf2:adoAdapterExtension element that appeared malformed. Not sure what happened there, but the other data connections don't have that element, so I thought I'd try removing it in this copy. You could also check and see if this copy behaves better. Right click the link in the header and save as to save locally, right click the saved file and select Design to open in design mode.https://www.infopathdev.com:443/forums/thread/125173.aspxFri, 18 Nov 2022 18:28:06 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125173desasaurus0https://www.infopathdev.com:443/forums/thread/125173.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=125173There are quite a few data connections and they are all working as expected. Thank you for all your help!https://www.infopathdev.com:443/forums/thread/125172.aspxFri, 18 Nov 2022 17:16:13 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125172Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/125172.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=125172So - to me, this indicates no data has been returned in that data source. You can check this by checking a different data connection - do you have other data connections in your form? You can also just use GetXml and it will return the main data source XML to the results field so you can see how the command works.... But I guess the next thing I'd verify is that your approvals data connection has been queried. Please feel free to attach a copy of your form under the Options tab if you'd like me to take a quick look. I can't connect to your data sources, of course, but could give it a quick check for logical errors.https://www.infopathdev.com:443/forums/thread/125171.aspxFri, 18 Nov 2022 16:39:12 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125171desasaurus0https://www.infopathdev.com:443/forums/thread/125171.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=125171Ah I see now. I entered the command in the proper way I think, however there is nothing populated in the error or results field and the success marker is checked. same is true in execution history. Any advice?https://www.infopathdev.com:443/forums/thread/125170.aspxFri, 18 Nov 2022 15:37:47 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125170Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/125170.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=125170Sounds like you may be trying to put that text in a formula editor. Put the qRules command and result field on the form so you can just enter the text as you have it into the command field and tab out: GetXml /dsname=approvershttps://www.infopathdev.com:443/forums/thread/125169.aspxFri, 18 Nov 2022 14:44:58 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125169desasaurus0https://www.infopathdev.com:443/forums/thread/125169.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=125169I keep getting an error: "GetXml/dsname" does not point to a valid location path of a field or group. is there something wrong with my syntax? GetXml /dsname = approvershttps://www.infopathdev.com:443/forums/thread/125157.aspxFri, 11 Nov 2022 18:07:45 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125157Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/125157.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=125157If you use GetXml /dsname=YourDataSourceName in the qRules command field, XML should be returned in the Result field - that would be at least a start to figuring out what's up.... is the XML returned what you expect?https://www.infopathdev.com:443/forums/thread/125156.aspxFri, 11 Nov 2022 17:12:25 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125156desasaurus0https://www.infopathdev.com:443/forums/thread/125156.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=125156we tried recreating the connection from scratch in a new form with the same results.https://www.infopathdev.com:443/forums/thread/125155.aspxFri, 11 Nov 2022 15:44:07 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125155Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/125155.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=125155First, your tag game is on point. Second - I wonder if the data returned from the stored procedure changed at all? Perhaps the data connection fields don't align with what is currently being returned from the stored procedure? You can use the qRules command: GetXml /dsname=YourDataSourceName to get back the actual XML in the data connection and compare that to the schema for the data connection - see if there are differences.