Results 1 to 3 of 3

Thread: Connecting to multiple databases

  1. #1

    Thread Starter
    New Member
    Join Date
    Dec 2005
    Posts
    2

    Connecting to multiple databases

    I am new to VB and I need to create a word template using VB. In general the template will read/write to a sql server database depending on the actions of the user.

    However, it will also be necessary to create a form in the template which will contain lists of values. These will be populated from an oracle database.

    Will this work ok having the template use 2 different databases at different times?

  2. #2
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: Connecting to multiple databases

    Welcome to the forums.

    Do you need both databases to be open at the same time?

    If so, just use two different connection objects. If not, you could probably reuse the same connection object.

  3. #3
    Super Moderator Shaggy Hiker's Avatar
    Join Date
    Aug 2002
    Location
    Idaho
    Posts
    40,106

    Re: Connecting to multiple databases

    Which language?
    My usual boring signature: Nothing

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width