2. ASPRunnerPro General questions
  3. More than 1 database
This topic is locked

More than 1 database

 		5/24/2008 9:07:31 AM
ASPRunnerPro General questions
L
 lennyc11563 author

I am trying to search 2 databases from 1 search box, Example last_name is in both databases. These databases are not on the same database server.
In asprunner I only have the option to list tables from one database.
Can you help.
Extra credit, on the search page is it possible to list databases inwhich to be searched, Example check box on databases you want to search and unchecked the ones you do not want to search.
Thank you
J
 		Jane 5/26/2008

Hi,
unfrotunately you can't use two database in one ASPRunner project.

As workaround you can edit ..._list.asp file manually. This may involve a bit of coding.

However we don't have a ready to go solution for this.
L
 		lyngaaskhan 5/28/2008

Hi,

unfortunately you can't use two database in one ASPRunner project.

As workaround you can edit ..._list.asp file manually. This may involve a bit of coding.

However we don't have a ready to go solution for this.


Actually, you can, if you're using a database that supports views. I have a project that uses it's own database, but I need to pull employee data from another database. I set up a view in the primary database in SQL server that simply selects the records from the table in the second database and use this view in the ASPRunner application.