CodeVerge.Net Beta


   Explore    Item Entry    Members      Register  Login  
NEWSGROUP
.NET
Algorithms-Data Structures
Asp.Net
C Plus Plus
CSharp
Database
HTML
Javascript
Linq
Other
Regular Expressions
VB.Net
XML

Free Download:




Zone: > NEWSGROUP > Asp.Net Forum > starter_kits_and_source_projects.dotnetnuke.custom_modules Tags:
Item Type: NewsGroup Date Entered: 4/11/2005 5:50:53 AM Date Modified: Subscribers: 0 Subscribe Alert
Rate It:
(NR, 0)
XPoints: N/A Replies: 0 Views: 22 Favorited: 0 Favorite
Can Reply:  No Members Can Edit: No Online: Yes
6 Items, 1 Pages 1 |< << Go >> >|
jk_nzd
Asp.Net User
Using multiple databases?4/11/2005 5:50:53 AM

0/0

Whats the best way to go about using multiple databases?  ie some data is in DB1, some is in DB2, etc .. (all are sql server)

DNN only has one connection string, to the DNN db..  should I be adding extra connection strings at the DNN level, or maybe just at the module level?

Not sure what the best practice is here..

Thanks

JK.
SchelianHP
Asp.Net User
Re: Using multiple databases?4/11/2005 2:43:49 PM

0/0

There is no practice !

DNN doesn't support that in standard !


Best regards

Hans-Peter

DNNPortal German DotNetNuke Community
ErikVB
Asp.Net User
Re: Using multiple databases?4/11/2005 3:06:33 PM

0/0

JK, if you have sa access to at least one of the sql servers, you might want to consider adding your other server as a linked server. This way you can access all data through one server.

cheers,

erik


Erik van Ballegoij, The Netherlands














docluv
Asp.Net User
Re: Using multiple databases?4/11/2005 6:54:48 PM

0/0

I created a parrallel setup for this purpose.  Two connections strings, the DNN and my other data source.  It worked just fine.  I don't use the provider modele because it takes way too much time to manage little changes to the methods if you change a stored procedure..... but did use the basic premise of a base class with the connectionstring property in it.

The other thing I think I did that worked well was modifying the base data class to have two connection string, obviously referring to the approperiate setting in the config file.

 


Chris Love
PScarlett
Asp.Net User
Re: Using multiple databases?4/11/2005 11:55:44 PM

0/0

For a discussion on alternate data sources check out this thread http://forums.asp.net/ShowPost.aspx?PostID=855338

Paul.


Paul Scarlett - Ontario, Canada
www.tressleworks.ca
www.tz3p9v.ca
jk_nzd
Asp.Net User
Re: Using multiple databases?4/12/2005 1:41:51 AM

0/0

Thanks,

For now I've just created a linked server - nice and quick, and seems to work fine.. but I will probably switch to the method described in http://forums.asp.net/855338/ShowPost.aspx - it seems to be more of a best practices approach

JK.
6 Items, 1 Pages 1 |< << Go >> >|


Free Download:

Books:
Physical Database Design for SYBASE SQL Server Authors: Rob Gillette, Dean Muench, Jean Tabaka, Pages: 225, Published: 1995
Oracle Essentials: Oracle Database 11g Authors: Rick Greenwald, Robert Stackowiak, Jonathan Stern, Pages: 406, Published: 2007
Beginning MySQL Authors: Robert Sheldon, Geoff Moes, Pages: 840, Published: 2005
Access Cookbook: Solutions to Common User Interface & Programming Problems Authors: Ken Getz, Paul Litwin, Andy Baron, Microsoft Corporation, Pages: 810, Published: 2004
Oracle Automatic Storage Management: Under-the-Hood and Practical Deployment Guide Authors: Nitin Vengurlekar, Murali Vallath, Rich Long, Bill Bridge, Pages: 340, Published: 2007
Symbolic and Quantitative Approaches to Reasoning and Uncertainty: European Conference ECSQARU '95, Fribourg, Switzerland, July 1995 : Proceedings Authors: Christine Froidevaux, Jürg Kohlas, Pages: 430, Published: 1995
Research and Development in Knowledge Discovery and Data Mining: Second Pacific-Asia Conference, PAKDD-98, Melbourne, Australia, April 15-17, 1998 : Proceedings Authors: Xindong Wu, Kotagiri Ramamohanarao, Ramamohanarao Kotagiri, Kevin B. Korb, Pages: 424, Published: 1998
Knowledge Discovery in Multiple Databases Authors: Shichao Zhang, Chengqi Zhang, Xindong Wu, Pages: 233, Published: 2004
Oracle8i DBA Handbook: [effectively Manage a High-performance Oracle Database] Authors: Kevin Loney, Marlene Theriault, Pages: 979, Published: 1999

Web:
Single Database or Multiple Databases - SQLTeam.com With multiple databases come multiple log files. Does having multiple transaction log files impair a recovery if needed? Also, is there any benefit in using ...
Using multiple databases - ClassDBI There are cases when you have the same schema in multiple databases and would like to access two or more databases from the same script without reconnecting ...
Using Multiple Databases with Ruby On Rails - Programmer Assist With Ruby On Rails, you can connect to multiple databases. This is usually done by setting up class-specific connections. The same has been explained in ...
InformIT: Using Multiple Databases with JBoss > Configuring a ... Using Multiple Databases with JBoss ... Marcus Zarra breaks down how databases, and therefore datasources, are configured in JBoss. ...
using multiple databases e.g. access, mysql - Xtreme .NET Talk using multiple databases eg access, mysql Database / XML / Reporting.
Using Multiple Databases with the Dynamic Website Project config.Save(); }. This way you can create support pages (dynamic pages) using multiple databases. Print | posted @ Thursday, January 24, 2008 12:25 PM ...
Using Poly/ML - Chapter 8: Using Multiple Databases In fact, it is possible, and often useful, to create and use multiple databases. New databases are created using PolyML.make_database. ...
CodeProject: Using NHibernate with Multiple Databases. Free source ... This article describes using NHibernate with multiple databases concurrently.; Author: Billy McCafferty; Section: ASP.NET; Chapter: Web Development.
» Using Multiple Databases in Symfony with Propel : LampJunkie.com ... Apr 22, 2008 ... There comes a time in your symfony development career when you will need to connect to multiple databases from within one application. ...
Tips on Writing Portable SQL for Multiple Databases for PHP If you are writing an application that is used in multiple environments and operating systems, you need to plan to support multiple databases. ...

Videos:
Swapping out the DAL using Abstract Class http://blog.dmbcllc.com Last Thursday, we looked at how to replace the TableAdapter with our own TableAdapter as a way or eliminating our dependence ...
Using open source tools for performance testing Google London Test Automation Conference (LTAC) Google Tech Talks September 8th, 2006 Presenter: Goranka Bjedov
Time to get moving with DataSplice DataSplice allows you to access multiple databases and CMMSs with just one interface, With the ability to track and update critical resources and man...
oXygen XML Author and Native XML Databases oXygen XML Editor offers support for the following native XML databases: Berkeley, eXist, MarkLogic, Tamino, TigerLogic, X-Hive and Oracle XML like b...
Access 2003 Level 1 The Access 2003 Level 1 is part of KeyStone Learning Systems library of more than 1,200 CD-ROM and video-based information technology course titles. ...
Computer Science Technology Game Programming www.tstc.edu The Graphics, Gaming & Simulation specialization of Computer Science Technology is designed to prepare students for entry into the worl...
Access 2003 Level 1 The Access 2003 Level 1 is part of KeyStone Learning Systems library of more than 1,200 CD-ROM and video-based information technology course titles. ...
Access 2003 Level 1 The Access 2003 Level 1 is part of KeyStone Learning Systems library of more than 1,200 CD-ROM and video-based information technology course titles. ...
Disk-Based Parallel Computation, Rubik's Cube, and Checkpointing Google Tech Talks March, 24 2008 ABSTRACT This talk takes us on a journey through three varied, but interconnected topics. First, our research la...
Access 2003 Level 1 The Access 2003 Level 1 is part of KeyStone Learning Systems library of more than 1,200 CD-ROM and video-based information technology course titles. ...




Search This Site:










login authentication

where are the installation instructions

membership/roles/profile design question

kill session

does login control create session variable?

is "write a new post" a webparts interface?

how can i apply custom images to my sitemap

how to store a usercontrol's position

any full fledged webmail softwares anybody could recommend?

using membership class

ajaxpro

port 80 ?

tabstrip/multipage problem

web server project in vs2005 issue

procedure of functions has too many arguments.

problem with ~/ in master page path.

applicationpath in global.asax or somewhere else - how?

module to display an html file (enhanced text/html?)

how to display passwordanswer?

module name: bpm user manager

3.0.7 dotnetnuke.desktopmodules solution error

superuser security

isearchable method...

new definition

3.0.12 installation woes - fresh install

w3wp.exe account

raise an event from usercontrol in webpart to aspx?

aspnetwindowstokenroleprovider

loosing pic on masterpage when creating a file in sub folder

how can i attach content to tabs ?

 
All Times Are GMT