This topic is locked

Reading from one Database and writing to another?

4/13/2007 2:19:52 PM
ASPRunnerPro General questions
E
evileyez3 author

Hello All,
I was wondering if I could have a drop down menu that read from a different sql database to populate the drop down. When the user adds a new record, would I be able to have it insert the record to a different sql database?

Sergey Kornilov admin 4/13/2007

This won't be possible without generated files modification.
Take a look at BuildSelectControl function in include/commonfunctions.asp. You can modify this function to retrieve data from another database.

E
evileyez3 author 4/16/2007

Thanks. Instead, I just created some views in my DB I am writing to, and pulled the data from the other DB. Thanks anways Admin.