Using two different database data in one application

[mohana123]

Hi,

Can I able to use two different databases in a asp application i.e one database is sqlserver that is installed in US and other is Mysql server in India? Is it possible? Please provide your comments and ideas.

Actually we have developed an application in asp with sql server and now we would like to develop reports based on the data stored in mysql server of another application and our sql server.

Mona

[ck9663]

Yes. Your connection object on your ASP apps should have a server setting. However, you have to consider security aspects of your apps and data.

-- CK