To work with two data bases in asp

[Lakrom]

Is possible to have a connection to SQL server and another one conaxion to a
data base Access to process data among them
Thanks.

 

[Aaron Bertrand [SQL Server MVP]]

to process data among them

You were most vague about the most important piece.

Yes, it is possible to have multiple connection strings in ASP. You can
connect to an Access and a SQL Server database, 8 different SQL Server
databases, or 2 MySQL, 4 Access and 3 FoxPro databases.

The more important part is how you want to "process data among them" because
that could have just as many meanings as there are possible database
combinations.

Typically, you would connect to one data source, and use linked tables
(Access -> SQL Server) or linked servers (SQL Server -> Access). It all
depends on exactly what you are doing. Is one database read-only from the
web app, or do they have to share data and update both sources, or ...?