CodeCharge Studio
search Register Login  

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> CodeCharge.Discussion

 2 databases for one project

Print topic Send  topic

Author Message
WizyWyg
Posted: 02/03/2003, 11:37 PM

With CC (not CCS) how does one set up for CC to use 2 databases?
I need 2 db's to be accessed all the time for every page in the project.

One db is used for Authentication/Admin so it contains user information.
The other db, of course, is used for the project/application.

Anyone know how to set it up to use 2 db's at once in CC?

Roger McIlmoyle
Posted: 03/03/2003, 7:17 PM

Is it possible to include the second DB via views in the application DB ?
This would be the simple way.

If not you may be able to create two apps that are basically integrated with
each other. A cheap trick is in one create stub pages for pages you call in
the other and simply click the exlude from generation checkbox so that it
does not over-right the real ones from teh other app. This way they are
included in the drop down lists for actions pages,etc.... Plus it documents
the cross project interfaces. The final trick is your logon page should be
tweaked to pass the userid,etc... authentication tokens to you 'second' app
and have that app store them in teh session variable userid... fakes out the
logon process.

"WizyWyg" <wizywyg@nnnnhotmail.com> wrote in message
news:b1nqke$93h$1@news.codecharge.com...
> With CC (not CCS) how does one set up for CC to use 2 databases?
> I need 2 db's to be accessed all the time for every page in the project.
>
> One db is used for Authentication/Admin so it contains user information.
> The other db, of course, is used for the project/application.
>
> Anyone know how to set it up to use 2 db's at once in CC?
>
>


   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by UltraApps.com  and YesSoftware, Inc.