2. ASPRunnerPro General questions
  3. [SOLVED]  2 databases
This topic is locked
[SOLVED]

 2 databases

 		8/10/2010 7:05:42 AM
ASPRunnerPro General questions
S
 shiv_mahima author

Hi Guys,
I want to create a different database for user access authentication as my current (main) database has validations checks with commissioners and therefore when we create a table there is crashes our downloads. my idea is to create a new table in other database but not sure how to do this... please can someone advise urgently.
thank you!
A
 		ann 8/10/2010

Hi,
unfortunately ASPRunnerPro do not support usage of two databases in one project.
hichem 8/20/2010



Hi,
unfortunately ASPRunnerPro do not support usage of two databases in one project.


You may try to query the table in second database from your main database using a database link to make it transparent to ASPR.

You can link MS SQL to Oracle and Oracle to MS SQL. If you google the setup of DB Links you'll find a few tutorials.