is it possible to use two different databases in vb 6.0? I will use DB A to fetch the records and save it to DB B,,Thanks :) Godbless
Mark Alonzo16 0 Newbie Poster
GeekPlease 16 Junior Poster
Yea. As long as you declare the right connection.
rishif2 57 Posting Whiz in Training
yes , its possible.
you will need to work with connection objects.
RonalBertogi 46 Junior Poster in Training
Previous answers are correct but I just want to post something clearer. If you are planning to use more than one database simultaneously in your program, you have to make one connection per database.
But the most ideal solution here is to make links to the table of interests from your DB A inside your DB B. The advantage of this is that you only have to create a single connection to work on both databases. The disadvantage here is that, DB A must not be moved to another location in your computer or else the link would be broke. But you can work around this problem, that is, if you know. Me? Show your interest first and I'd be willing to help you.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.