2. ASPRunnerPro General questions
  3. List page from Different DBs
This topic is locked

List page from Different DBs

 		10/11/2011 7:06:15 PM
ASPRunnerPro General questions
author

I am running ASPRunnerPro version 6.3, Build 7474. I use several MS Sql Servers for my ASPR development.
Is there a way to create a list page that has fields from

  1. Different tables from the projects DB?
  2. Different SQL DBs on the same server?
  3. Different SQL Servers DBs?
    I have a client that wants a little more integration and has asked me to put a few fields from several tables and later from different servers on the list page. Is this possible in ASPR?

    Thanks in advance,

    Joe
Sergey Kornilov admin 10/11/2011

1 is easy - simply use JOIN to pull data from several tables. You can do this on SQL Query screen.



Connecting to multiple databases is more tricky. You can create a view in SQL Server that pulls data from tables that reside in different databases. Once created you can use those views as datasources in ASPRunnerPro.

3 is even more tricky. Step 1: use linked server option in SQL Server to link databases from another server. Step 2: create views that pull data from tables that belong to linked servers. Then use those views as datasources in ASPRunnerPro.