|
 |
activex_data_objects thread: Multiple dB. and ADO Connections
Message #1 by Ian Oates <Ian.Oates@U...> on Wed, 24 Oct 2001 09:55:27 +0100
|
|
I have three separate MS Access databases and three ODBC DNS strings,
'Local', 'System' and 'Archive'.
When all the tables were in one MS Access dB no problem. I set the DNS and
execute a SQL statement to return a recordset.
What I want to do now is the same but open two/three connections, execute a
SQL statement which would use two or three databases and return a recordset.
Any help appreciated
Ian Oates
Message #2 by Kyle Burns <kburns@c...> on Thu, 25 Oct 2001 08:24:21 -0500
|
|
I think your easiest answer would be to create an Access database that uses
linked tables to "join" your databases and then query that database.
=================================
Kyle M. Burns, MCSD, MCT
ECommerce Technology Manager
Centra Credit Union
kburns@c...
-----Original Message-----
From: Ian Oates [mailto:Ian.Oates@U...]
Sent: Wednesday, October 24, 2001 3:55 AM
To: ActiveX_Data_Objects
Subject: [activex_data_objects] Multiple dB. and ADO Connections
I have three separate MS Access databases and three ODBC DNS strings,
'Local', 'System' and 'Archive'.
When all the tables were in one MS Access dB no problem. I set the DNS and
execute a SQL statement to return a recordset.
What I want to do now is the same but open two/three connections, execute a
SQL statement which would use two or three databases and return a recordset.
Any help appreciated
Ian Oates
$subst('Email.Unsub')
Message #3 by Nick Parker <nparker@i...> on Thu, 25 Oct 2001 22:29:32 -0500 (CDT)
|
|
I am facing a similar problem within SQL server. I have a file that I am
creating that is going to two separate databases. My only thought is to use
two separate connection strings along with two separate recordset at the same
time. Are there any ways to connect to multiple databases where there is no
logical relation to the tables (i.e. I would not be able to join between the
two databases themselves)
Nick Parker
nparker@i...
> I think your easiest answer would be to create an Access database that uses
> linked tables to "join" your databases and then query that database.
>
> =================================
> Kyle M. Burns, MCSD, MCT
> ECommerce Technology Manager
> Centra Credit Union
> kburns@c...
>
>
>
> -----Original Message-----
> From: Ian Oates [mailto:Ian.Oates@U...]
> Sent: Wednesday, October 24, 2001 3:55 AM
> To: ActiveX_Data_Objects
> Subject: [activex_data_objects] Multiple dB. and ADO Connections
>
>
> I have three separate MS Access databases and three ODBC DNS strings,
> 'Local', 'System' and 'Archive'.
>
> When all the tables were in one MS Access dB no problem. I set the DNS and
> execute a SQL statement to return a recordset.
>
> What I want to do now is the same but open two/three connections, execute a
> SQL statement which would use two or three databases and return a recordset.
>
> Any help appreciated
> Ian Oates
>
>
|
|
|
View Cart
