Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > To work with two data bases in asp

Thread Tools

To work with two data bases in asp

Posts: n/a
Is possible to have a connection to SQL server and another one conaxion to a
data base Access to process data among them

Reply With Quote
Aaron Bertrand [SQL Server MVP]
Posts: n/a
> 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

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 ...?

Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Work in Management careers bases. gaurav Java 0 11-15-2010 12:26 AM
two bases with shared_from_this? C++ 1 03-06-2007 06:51 PM
Math problem - converting between arbitrary bases in perl - help! ! aaa Perl 1 05-28-2004 01:42 AM
Help with data bases news HTML 4 11-14-2003 01:44 PM
All Your Bases Are Belong To Us Zombie Computer Support 0 08-31-2003 01:20 PM