Re: ADO - Copy Data from one data source to another via VB6
From: William \(Bill\) Vaughn (billvaRemoveThis_at_nwlink.com)
Date: 08/24/04
- Next message: William \(Bill\) Vaughn: "Re: sql connection errors as usage increases"
- Previous message: .Net Newbie: "ASP.Net bug when inserting Blobs?"
- In reply to: rmsterling: "Re: ADO - Copy Data from one data source to another via VB6"
- Next in thread: Doug Stoltz: "Re: ADO - Copy Data from one data source to another via VB6"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 24 Aug 2004 14:35:32 -0700
Nope, I would search the archives of this list and google--it's been
mentioned before. You're getting paid to write the code--I'm just a
volunteer here and busy with my own work as well.
-- ____________________________________ William (Bill) Vaughn Author, Mentor, Consultant Microsoft MVP www.betav.com Please reply only to the newsgroup so that others can benefit. This posting is provided "AS IS" with no warranties, and confers no rights. __________________________________ "rmsterling" <rmsterling@avaya.com> wrote in message news:D4E49849-2651-44D5-9FAB-EF2672677F28@microsoft.com... > > Bill, > > Are you able to give some sample code please as I am unfamilar with SQL > DMO > and I have not got time to look up extensive help pages to find the code. > > Can you help? > > Regards, > Richard. > > > "William (Bill) Vaughn" wrote: > >> Yes, you can write BCP or DTS routines using SQL-DMO from VB6. It would >> move >> the data far faster than ADO. >> >> -- >> ____________________________________ >> William (Bill) Vaughn >> Author, Mentor, Consultant >> Microsoft MVP >> www.betav.com >> Please reply only to the newsgroup so that others can benefit. >> This posting is provided "AS IS" with no warranties, and confers no >> rights. >> __________________________________ >> >> "rmsterling" <rmsterling@avaya.com> wrote in message >> news:F8E2F464-F681-4143-9FAE-4FAA00A5C2B0@microsoft.com... >> > Re: ADO - Copy Data from one data source to another via VB6 >> > >> > I have two data sources located on two different servers. >> > Both data sources are defined as a System DSN in the ODBC >> > Administrator. >> > >> > Currently I open both sources using ADO and copy the records from one >> > source >> > to another. As there are thousands of records it takes hours to copy >> > the >> > data. >> > >> > I noticed if both sources are SQL Server I can use DTS services. The >> > problem >> > with this is that the SQL query is fixed. I need to be able to alter it >> > from >> > VB6. >> > >> > Does anyone have any VB6 code that does this using a OLE plug-in? >> > OR >> > Does anyone know any other way of performing this task quicker than the >> > way >> > I am doing it above? >> > >> > Please post answers to MSDN Newsgroup thread and to my email address >> > below. >> > >> > Many thanks in advance. >> > >> > -- >> > ---------------------------- >> > Regards, >> > Richard Sterling >> > Senior Software Engineer Tel : +44 (0)1707 392200 ext 4815 >> > Avaya ECS Ltd, United Kingdom >> > mailto:rmsterling@avaya.com >> > >> >> >>
- Next message: William \(Bill\) Vaughn: "Re: sql connection errors as usage increases"
- Previous message: .Net Newbie: "ASP.Net bug when inserting Blobs?"
- In reply to: rmsterling: "Re: ADO - Copy Data from one data source to another via VB6"
- Next in thread: Doug Stoltz: "Re: ADO - Copy Data from one data source to another via VB6"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
