Re: Query two databases with asp

dusty wrote:
I'm trying to create an asp page that will allow users to generate
search results by querying mssql databases.
I inherited these databases and did not build them. Here's the
scenario.

I have two databases: DB1 and DB2. School is a table of DB1 that
consists of the fields:
ID, Parish, School, Principal, address, city, zip, etc.

Users is a table of DB2 that consists of the following fields:
ID, firstname, lastname, address, city, CompanyName, etc.

What are the datatypes of these fields, please?
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.

Relevant Pages

  • Re: Running Periodic Tasks
    ... basically process data between two databases on a SQL server. ... I have DB1 which generates data in a table. ... that data and put it in a specific table in DB2. ... These are two different vendors' databases. ...
    (alt.2600)
  • Re: Append Record to External Database
    ... > I have two databases (db1 and db2) with the same structure. ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Security between databases
    ... SQL Server databases. ... I have two databases DB1 and DB2. ... DB1 has a table called DB1_Table1. ... The above model is repeated for DB2. ...
    (microsoft.public.sqlserver.security)
  • Transfering access records between databases via email?
    ... I have two databases with the exact same table format. ... to be able to click a control button to email her new data to db2. ... This is basically a telemarketing database where the user of db1 enters ... the contact details for sales leads, these are then sent to db2 where ...
    (comp.databases.ms-access)
  • Multiple db access from php
    ... Both databases are on the same server. ... // connect to DB1 ... // now connect to DB2 ... of $db1c and $db2c to the screen gives the same result which seems odd to ...
    (comp.lang.php)
Loading