Results 1 to 3 of 3

Thread: ASP using SQL

  1. #1
    Join Date
    Nov 2005
    Posts
    6

    Unanswered: ASP using SQL

    Hi
    Can I use a SQL in statement using 2 tables from 2 different databases one from Access and the other one from SQL Server.

    select distinct region_id,country_name,country_id from Renewal_Data where region_id in (select region_id from smUsrGrp where userid = '"& suserid & "')

    Here Renewal_Data table is an Access table and smUsrGrp is SQL table.
    Regards
    Madhuri

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    providing you have physical access (permission) to read or write those data sources you can do what ever you like.

    As far as I'm aware ASP like other such languages doesn't care what db storage method it talks to, providing in it knows how to talk to the db.

    It does mean that you will be running 2 connections to your data for each instance of your script, so you may have a resource issue, especailly if you don't correctly clean up after the connection is finished with.
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jun 2003
    Location
    USA
    Posts
    1,032
    At first I didn't think it could be done, but I actually tried it and it worked:

    http://www.sitepoint.com/forums/showthread.php?t=101500
    Forums » Program Your Site » ASP » Populate 1 Array with 2 Queries?
    J. Paul Schmidt, Freelance Web and Database Developer
    www.Bullschmidt.com
    Access Database Sample, Web Database Sample, ASP Design Tips

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •