VB Help for Two Database Connection

[DhavalPatel1983]

Hi,

I need help for connecting two different database(not table) using Visual Basic.

Discription

I have two different database in SQL, now my problem is i want to transfer day to day data from one database to another database (not table) table with condition.... for exa. daily transaction data transfer from date to to date from database1 to database2.

can any one help me for transfering data from one database to anther database.

for this task i have one VB form interface with ADODC component.

How to connect two separat database, how to open record set, how to compare condition. and how to insert/transfer data.

Thanks in Advance.


Dhaval

[willakawill]

What is it that links the 2 databases?

Hi,

I need help for connecting two different database(not table) using Visual Basic.

Discription

I have two different database in SQL, now my problem is i want to transfer day to day data from one database to another database (not table) table with condition.... for exa. daily transaction data transfer from date to to date from database1 to database2.

can any one help me for transfering data from one database to anther database.

for this task i have one VB form interface with ADODC component.

How to connect two separat database, how to open record set, how to compare condition. and how to insert/transfer data.

Thanks in Advance.


Dhaval

[DhavalPatel1983]

Could u please mention clearly. I m not getting ur points.


Sorry for inconvience.