Hi all

I hope this question is not off topic...

I have a project to design "something" to grab drug records from an =
Oracle database, dump them in a SQL Server database and clean them up.  =
These 2 databases don't interact with each other at all, so I thought to =
use Access to run a number of pass-through queries between the =
databases.  However, for some reason it balks when using ODBC to connect =
to Oracle despite the fact that the DSN works properly when tested. =20

So, I'm now testing the less efficient method of using an ASP page to =
dump the Oracle resultset (24000 records!) into an array using  =
RS.GetRows().  However, in order to update the SQL Server, I need to =
double-loop through the array, building a querystring and executing. I =
reset the querystring and begin the second loop etc. etc. I know that =
ASP was not designed with this sort of batch-processing in mind but, =
being an foolishly optimistic person, I am wondering if anyone working =
with ASP has any knowledge of a means of sending the entire Oracle =
recordset to a SQL Server procedure in one single execution and then =
have the database perform its insert.
_____________
Andrew Browne
IT
658-6484        =20
_____________

HWG: hwg-languages mailing list archives, maintained by Webmasters @ IWA