Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SOAP Web Services for use in InfoPath Expand / Collapse
Author
Message
Posted Wednesday, August 6, 2008 6:39 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 26, 2009 8:22 AM
Points: 7, Visits: 24
I have created a Native XML Web Service using SOAP/HTTP. When I try to use the WSDL in InfoPath to receive data, I get the following error message:

"The file is not a valid XML file.
Not enough storage is available to process this command"

I am using a Vista development machine, and a 32 bit SQL 2005 Server running Windows 2003 R3. I have SP2 installed on the SQL server.

Thanks,

ML
Post #547440
Posted Wednesday, August 6, 2008 8:39 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 13,872, Visits: 9,596
Is the XML file simply huge? That's what the error message seems to indicate to me.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #547571
Posted Wednesday, August 6, 2008 8:43 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 26, 2009 8:22 AM
Points: 7, Visits: 24
Since I am new to SharePoint,InfoPath, and Web Services I am not sure how to view the XML file. I do know that the Stored Procedure that the Web Method calls returns only 248 rows of data.

ML
Post #547575
Posted Thursday, August 7, 2008 7:32 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 26, 2009 8:22 AM
Points: 7, Visits: 24
The error message "The file is not a valid XML file. Not enough storage is available to process this command" that I was getting did not have anything to do with memory or storage. It was a permissions issue. After creating a SOAP Endpoint the Server Administrator needs to "GRANT CONNECT ON ENDPOINT: ". Then the WSDL request from InfoPath will connect.

Thanks for the help

ML
Post #548282
Posted Thursday, August 7, 2008 3:36 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 13,872, Visits: 9,596
Good old fashioned useless error messages! Glad you got it fixed.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #548718
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse