Re: rdoResultset

Hmm, this seems to apply to a different thread ...

Mark J. McGinty wrote:
You might also try analyzing the XML differences and correcting them
at that level.


-Mark



"Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx> wrote in message
news:e59v3%23nBIHA.3548@xxxxxxxxxxxxxxxxxxxxxxx
MarcOS wrote:
Hi,

How can I pass a rdoResultset from an old database to an SQL 2005?

Can I desconect the rdoResultset from the old database, and then
connect it to the SQL 2005 in order to create or update a table with
the rdoResultset data?

No. You have to insert the records into the new database via one of
the following techniques (in order of preference):

1. SQL 2005 has builtin import functionality - look up SQL Server
Integration Services (SSIS) either in BOL or using google or post to
a sql server newsgroup if you wish to pursue this route, which is the
one I recommend

2. You can still use BCP with SQL 2005 if that's relevant

3. using a parameterized sql insert statement executed via an ADO
(this IS and ADO newsgroup ... <grin>) Command object passing the
parameter
values from the rdo recordset

4. Opening an ADO recordset on the table in the new database using
adLockOptimisticBatch, disconnecting it, updating it with the data in
the rdo recordset, reconnecting it and calling the UpdateBatch method

4. Opening a recordset on the table in the new database and updating
it with the data from the rdo recordset.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get
a quicker response by posting to the newsgroup.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Relevant Pages

  • Re: rdoResultset
    ... How can I pass a rdoResultset from an old database to an SQL 2005? ... the rdo recordset, reconnecting it and calling the UpdateBatch method ...
    (microsoft.public.data.ado)
  • Re: rdoResultset
    ... How can I pass a rdoResultset from an old database to an SQL 2005? ... the rdo recordset, reconnecting it and calling the UpdateBatch method ...
    (microsoft.public.data.ado)
  • Re: dbdebunk Quote of Week comment
    ... > a lot of really bad SQL programmers. ... But SQL does not have a pointer data type or the ... > being told to design a database. ... But why is little Cindy Lou Who employee ...
    (comp.databases.theory)
  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)
  • Re: dbdebunk Quote of Week comment
    ... > a lot of really bad SQL programmers. ... a surrogate key should support the primary key. ... But SQL does not have a pointer data type or the ... > being told to design a database. ...
    (comp.databases.theory)