Aleks
asked on
Connecting to multiple databases to create a Dashboard
I want to create a small application to be used as a Dashboard.
I have multiple databases (Same design) that I want to query, example one page could show everyone who signed in that day.
I can do that for one database no problem. I connect my ASP application to the MS SQL 2012 database via ODBC.
How can I connect this ASP file to ALL the databases I have so that when I run the query in my Dashboard it shows the results for all the databases ? I want to be able to connect to them with one ODBC if possible.
I have multiple databases (Same design) that I want to query, example one page could show everyone who signed in that day.
I can do that for one database no problem. I connect my ASP application to the MS SQL 2012 database via ODBC.
How can I connect this ASP file to ALL the databases I have so that when I run the query in my Dashboard it shows the results for all the databases ? I want to be able to connect to them with one ODBC if possible.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks
sounds good, if you have any issues regarding this, post in here (instead of posting a new question) and I'll answer any questions you may have
ASKER
As always best help ever, thanks!
ASKER