Re: Query two databases with asp

Are the two databases on different database servers?

dusty wrote:
I need help with all items you've mentioned.

Thanks so much.

"Bob Barrows [MVP]" wrote:

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.

Field CompanyName (DB2\Users) is linked to ID (DB1\School). Users
would like to have the capability of finding out which users are in
a particular parish or school.

I don't know how to produce the correct asp code that will pull
information from two different databases.

I'm not sure where you are having the problem:
- constructing the sql statement to join the tables?
- executing the sql statement and retrieving the results into a
recordset?
- displaying the results to the users?

Where do you specifically need help?

--
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.

--
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: Query two databases with asp
    ... The databases are on the same server. ... ID, Parish, School, Principal, address, city, zip, etc. ... Please reply to the newsgroup. ... header is my spam trap, so I don't check it very often. ...
    (microsoft.public.inetserver.asp.db)
  • RE: I would like to move my company web databases from C to D
    ... You can use OSQL -Q command to query if the correct databases are attached. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • RE: I would like to move my company web databases from C to D
    ... Thank you for posting in SBS newsgroup. ... You can refer to the following articles to do a backup of SBS: ... I would like to move my company web databases from C to D ...
    (microsoft.public.windows.server.sbs)
  • RE: I would like to move my company web databases from C to D
    ... and Jenny Wu's instructions. ... SQL engine to determine if the correct databases are attached? ... >> Thank you for posting in SBS newsgroup. ... you may want to contact Microsoft CSS directly. ...
    (microsoft.public.windows.server.sbs)
  • RE: I would like to move my company web databases from C to D
    ... can the two databases be moved independantly? ... > Thank you for posting in SBS newsgroup. ... you may want to contact Microsoft CSS directly. ... I would like to move my company web databases from C to D ...
    (microsoft.public.windows.server.sbs)