Velocity Reviews - Computer Hardware Reviews

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

Reply
Thread Tools

To work with two data bases in asp

 
 
Lakrom
Guest
Posts: n/a
 
      09-01-2005
Is possible to have a connection to SQL server and another one conaxion to a
data base Access to process data among them
Thanks.


 
Reply With Quote
 
 
 
 
Aaron Bertrand [SQL Server MVP]
Guest
Posts: n/a
 
      09-01-2005
> 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 ...?


 
Reply With Quote
 
 
 
Reply

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? limcore@gazeta.pl 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



Advertisments