Re: [Phpgroupware-developers] Synchronizations across different databasesystems

[Chris Weiss]

soon there should be a ADODB patch for .18, I think someone already
has it working, maybe it will easier with this.


On Tue, 7 Dec 2004 11:57:00 +0100, sigurdne <address@hidden> wrote:
> I am moving from mssql to pgsql (performance issue) - but then I need to
> synchronize phpgroupware (pgsql) with an integrated system on mssql as a cron
> job (I have a nice interface for this - using asyncservice)
> 
> I tried to initiate the db-objekt with :
> 
> $dbtype = $GLOBALS['phpgw_info']['server']['db_type'];
> $dbtype_remote                              = 'mssql';
> $GLOBALS['phpgw_info']['server']['db_type'] = $dbtype_remote;
> $this->db_boei                              = CreateObject('phpgwapi.db');
> $this->db_boei->Host                        = xx.xx.xx.xx;
> $this->db_boei->Type                        = $dbtype_remote ;
> $this->db_boei->Database                    = 'BOEI';
> $this->db_boei->User                        = 'user';
> $this->db_boei->Password                    = 'pw';
> $this->db_boei->Halt_On_Error               = 'yes';
> $GLOBALS['phpgw_info']['server']['db_type'] = $dbtype;
> 
> But $GLOBALS['phpgw_info']['server']['db_type'] was not altered from pgsql
> (the mssql db class wouldn't load)
> 
> My temporary workaround for this is to copy class.db_mssql.inc.php from
> /phpgwapi/inc to /property/inc (and rename class db to class db_mssql) and
> create the object as
> $this->db_boei= CreateObject('property.db_mssql');
> 
> Any idea for dealing with this?
> 
> Sigurd
> 
> _______________________________________________
> Phpgroupware-developers mailing list
> address@hidden
> http://lists.gnu.org/mailman/listinfo/phpgroupware-developers
> 
>