[turba] Trying to set up addressbook hosted on a remote MS SQL 2000 server

[Ben Chavet]

Quoting Mark Hennessy <mhennessy at cloud9.net>:

> In addition to my previous e-mail, I should mention that I wanted to have
> horde/imp prefs and datatree etc. live in a local MySQL database and the
> turba table live on the remote MS SQL 2000 server.  Would there be anything
> intrinsic to horde to prevent that?

No, the turba sources are independent of other horde settings.  Here's  
my config to connect to a remote MS-SQL2005 address book:

$cfgSources['localsql'] = array(
     'title' => _("My Addressbook"),
     'type' => 'sql',
     'params' => array(
         'phptype' => 'mssql',
         'hostspec' => 'sql.example.com',
         'username' => 'horde',
         'password' => 'password',
         'database' => 'horde',
         'table' => 'turba_objects',
         'charset' => 'iso-8859-1',
     ),
     'map' => array(

[snip]

     ),
     'search' => array(
         'name',
         'email'
     ),
     'strict' => array(
         'object_id',
         'owner_id',
         'object_type',
     ),
     'public' => false,
     'readonly' => false,
     'admin' => array(),
     'export' => true,
     'browse' => true,
);

--Ben
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: PGP Digital Signature
Url : http://lists.horde.org/archives/turba/attachments/20060906/13368481/attachment.bin