[ic] Additional database - readonly

[Rick Bragg]

On Sat, 2009-04-18 at 12:52 -0400, Carl Bailey wrote:
> On Apr 18, 2009, at 11:07 AM, Rick Bragg wrote:
> 
> > How would I add a second database to my IC stores?  I just want to be
> > able to select a field from an outside database table where the IC
> > catalog owners can't write to this table.
> >
> > thanks!
> > rick
> 
> 
> Rick,
> 
> Just define the database in catalog.cfg with a different DSN.
> 
> Normally you see something like this:
> mytable        mytable.txt              __SQLDSN__
> where __SQLDSN__ is defined in variables.txt.
> But you can specify an alternate explicitly
> othertable     othertable.txt           dbi:mysql:dbname:hostname
> 
> Then of course you need to make sure that your user has proper access  
> to the other database.
> 
> I hoe this helps.
> 
> Regards,
> Carl
> . . . . . . . . . . . . . . . . . .
> Carl Bailey
> End Point Corp.
> t: 919-323-8025
> . . . . . . . . . . . . . . . . . .
> 

right of course...  silly question!

Thanks
rick


-- 
This message has been scanned for viruses and
dangerous content by Green Mountain Network, and is
believed to be clean.