hi, please check whether Webservice has any error. If not, check the response you are receiving from web service contains any invalid char to xml(like '&'). hope it would shed some light on your problem.
By providing more information.
------------------------------------ I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave CCC Link[^] Trolls[^]
Rami Said Abd Alhalim wrote:
Invalid use of 'EXECUTE' within a function.
Sounds like you need to use the execute command correctly.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
You asked this same question in the SQL Forum, please do not cross post.
"Try asking what you want to know, rather than asking a question whose answer you know." - Christian Graus
i read excel sheet all columns can getting but column contain string can not getting can change any setting in connection string or command to solving problems
It depends on how your tables are related. Let's say you had: ParentTable1 ChildTable1 ChildTable2 Both ChildTable1 and ChildTable2 have parenttable1ID which is the key. All of the records in childTable1 and childTable2 that have that parenttable1ID must be deleted before the record in ParentTable1 with parenttable1id can be deleted. The benifit of this is that you can't orphen the Child table records. They must be deleted before the parent table record can be deleted. Hope that helps. Ben
thanks talal : but i am using sql server 2000 and i trying test on application without firewall(Stop Firewall),and i opened all ports to connection on server (TCP/IP)port but i have the same problem
This is generral error given by SQL Server 2005 There might be any reasone for it I also faced this problem few days before i tried everything then also it was showing same error At last i switch OFF the Fire Wall of the operating System of the server then it allowed me :) :doh:
Thanks and Regards Sandeep If you want something you never had, do something you have never done!
