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?
Re: Connecting to multiple databases
Welcome to the forums. :wave:
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.
Re: Connecting to multiple databases