To work with two data bases in asp

Discussion in 'ASP General' started by Lakrom, Sep 1, 2005.

  1. Lakrom

    Lakrom Guest

    Is possible to have a connection to SQL server and another one conaxion to a
    data base Access to process data among them
    Thanks.
     
    Lakrom, Sep 1, 2005
    #1
    1. Advertising

  2. > to process data among them

    You were most vague about the most important piece.

    Yes, it is possible to have multiple connection strings in ASP. You can
    connect to an Access and a SQL Server database, 8 different SQL Server
    databases, or 2 MySQL, 4 Access and 3 FoxPro databases.

    The more important part is how you want to "process data among them" because
    that could have just as many meanings as there are possible database
    combinations.

    Typically, you would connect to one data source, and use linked tables
    (Access -> SQL Server) or linked servers (SQL Server -> Access). It all
    depends on exactly what you are doing. Is one database read-only from the
    web app, or do they have to share data and update both sources, or ...?
     
    Aaron Bertrand [SQL Server MVP], Sep 1, 2005
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. ! aaa
    Replies:
    1
    Views:
    1,078
    ! aaa
    May 28, 2004
  2. news

    Help with data bases

    news, Nov 14, 2003, in forum: HTML
    Replies:
    4
    Views:
    443
  3. Jim Fischer
    Replies:
    3
    Views:
    447
    Jim Fischer
    Jul 31, 2003
  4. Dave Theese

    Initialization of virtual bases

    Dave Theese, Aug 24, 2003, in forum: C++
    Replies:
    1
    Views:
    336
    John Harrison
    Aug 24, 2003
  5. Replies:
    1
    Views:
    897
Loading...

Share This Page