Hello All,
Using the following query "Select * from tblEmployees FOR XML"
how to retrieve the XML string from VC++?
I do not want to use save method of recordset.
Is there any way of exceuting the above query and getting the XML string?
I am using VC 6.0,ADO 2.6 and SQL server 2000.
Re: XML and SQL2000 ... you cannot query against XML strings in a SQL Server 2000. ... > information as a XML string stored in a field in the database. ... (microsoft.public.dotnet.framework.adonet)
Help with connection to WebServer via VB ... I need to connect Web Server, send a xml string... I know the xml query string like: ... Could someone help plese?... (microsoft.public.dotnet.languages.csharp)
Inserting XML String to a Text datatyped column ... I have an XML string that I get by using a query similar ... FROM ZipCodes where id < 3 ... This returns an XML string,... Any kind of help in this regard will be grately ... (microsoft.public.sqlserver.xml)
LINQ to SQL as XML ... I have a LINQ class that I can use to query data from my database. ... want to query the data directly into an XML string without defining ... (microsoft.public.dotnet.languages.csharp)
Re: Pass Recordset from Web Service to Classic ASP. ... Use Interop on the server to work with the ADO recordset.... > Set oStream = New ADODB.Stream ... > oStream.WriteText sXML 'Give the XML string to the ADO Stream ... > Set oRecordset = New ADODB.Recordset ... (microsoft.public.dotnet.framework.aspnet)