|
 |
asp_databases thread: selecting values from multiple databases
Message #1 by "Daniel O'Dorisio" <dodorisio@h...> on Fri, 22 Jun 2001 14:36:20 -0400
|
|
hey.
i have 3 or 4 databases that have tables in them that are identical, the
databases are msde. what i want to do is take the master db and create a new
view or something that will contain all the data from each of the other 4
dbs
can that be done? thanks!
daniel
Message #2 by "Tomm Matthis" <matthis@b...> on Fri, 22 Jun 2001 15:44:50 -0400
|
|
Yes,you can... and you the view just as you would a table.
If you have Access 2000, you can setup an access project file to
administer the MSDE database.
This will give you an easier environment to create and test your view(s)
before you call them via ADO/ASP.
-- Tomm
> -----Original Message-----
> From: Daniel O'Dorisio [mailto:dodorisio@h...]
> Sent: Friday, June 22, 2001 2:36 PM
> To: ASP Databases
> Subject: [asp_databases] selecting values from multiple databases
>
>
> hey.
>
> i have 3 or 4 databases that have tables in them that are identical,
the
> databases are msde. what i want to do is take the master db and
> create a new
> view or something that will contain all the data from each of the
other 4
> dbs
>
> can that be done? thanks!
>
> daniel
>
Message #3 by "Daniel O'Dorisio" <dodorisio@h...> on Mon, 25 Jun 2001 06:20:47 -0400
|
|
would you have any reference on doing this? i played arround with access2000
and msde but couldnt find what i was looking for.
would it be that i add the db name to all the sql syntax? like
dbname.tablename.fieldname
daniel
thanks
daniel
Daniel O'Dorisio
dodorisio@h...
xxx-xxx-xxxx
-----Original Message-----
From: Tomm Matthis [mailto:matthis@b...]
Sent: Friday, June 22, 2001 3:45 PM
To: ASP Databases
Subject: [asp_databases] RE: selecting values from multiple databases
Yes,you can... and you the view just as you would a table.
If you have Access 2000, you can setup an access project file to administer
the MSDE database.
This will give you an easier environment to create and test your view(s)
before you call them via ADO/ASP.
-- Tomm
> -----Original Message-----
> From: Daniel O'Dorisio [mailto:dodorisio@h...]
> Sent: Friday, June 22, 2001 2:36 PM
> To: ASP Databases
> Subject: [asp_databases] selecting values from multiple databases
>
>
> hey.
>
> i have 3 or 4 databases that have tables in them that are identical, the
> databases are msde. what i want to do is take the master db and
> create a new
> view or something that will contain all the data from each of the other 4
> dbs
>
> can that be done? thanks!
>
> daniel
Message #4 by "Tomm Matthis" <matthis@b...> on Mon, 25 Jun 2001 11:25:17 -0400
|
|
Acutally it should be in the Books OnLine for SQL Server...
And the syntax is:
dbServer.dbName.dbOwner.dbTablename.dbFieldName
-- Tomm
> -----Original Message-----
> From: Daniel O'Dorisio [mailto:dodorisio@h...]
> Sent: Monday, June 25, 2001 6:21 AM
> To: ASP Databases
> Subject: [asp_databases] RE: selecting values from multiple databases
>
>
> would you have any reference on doing this? i played arround with
> access2000
> and msde but couldnt find what i was looking for.
> would it be that i add the db name to all the sql syntax? like
> dbname.tablename.fieldname
>
> daniel
>
> thanks
> daniel
>
> Daniel O'Dorisio
> dodorisio@h...
> xxx-xxx-xxxx
>
|
|
|
View Cart
