Re: XML ODBC Driver?
ADO will do this out of the box with any OleDB provider, including
the OleDb provider for ODBC.
Configure the ADO connection for a client-side cursor, execute the SQL
and save the resulting recordset by executing recordset.savetofile
('filename.xml')
You can then load the xml file from disk into an Ado recordset in
your Delphi application.
Thank you Arthur! I will be looking into this.
Tom
.
Relevant Pages
- Re: UPDATE query in Access 2003 raising error
... The only reason I questioned the recordset is that you could conceivably ... the SQL looks fine to me. ... Set qdfTemp = db.CreateQueryDef ... Elsewhere in the code I use the same technique to execute an SQL statement ...
(microsoft.public.access.formscoding) - Re: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT I
... This statement causes ADO to create a recordset to receive the results ... of the query being executed and assign that recordset to your qryAddProj ... You should use the ExecuteOptions argument of the Execute ... string containing a sql statement to be executed. ...
(microsoft.public.data.ado) - Re: ADODB.Recordset: Operation is not allowed when the object is closed
... > ' Create the ADO Connection and Recordset objects. ... > ' Set the connection string, open the connection and execute the ... If your sql string is an insert/update/delete statement, ...
(microsoft.public.scripting.vbscript) - Re: insert Q
... many sql statements on the page). ... When you use a connection's Execute method, a Command object is ... Always use an explicit recordset object: ...
(microsoft.public.inetserver.asp.db) - Re: insert Q
... >> conn.execute SQL ... When you use a connection's Execute method, a Command object is ... Always use an explicit recordset object: ...
(microsoft.public.inetserver.asp.db) |
|
