[ic] Interchange remote Postgres TCP

Mike Heins mike at perusion.com
Thu Jul 19 12:58:15 EDT 2007


Quoting Stephen Peters (speters at killbygayford.co.uk):
> On Thu, 2007-07-19 at 12:06 -0400, Mike Heins wrote:
> 
> > > ifndef SQLDSN
> > > Variable  SQLDSN
> > > dbi:Pg:dbname=standard;host='my.postgres.server';port=5432;
> > > Variable  SQLDB   standard
> > > Variable  SQLUSER standard
> > > Variable  SQLPASS lamepassword
> > > endif
> > 
> > Looks like you still have single quotes there -- why? You
> > haven't done what is suggested.
> > 
> > In any case, remote DSNs work fine with IC and there have been no
> > reports other than yours with doubtful syntax.
> > 
> > Suggest you start from scratch and use a standard DSN instead of trying
> > to specify port and single quotes when you don't need to.
> > 
> 
> Sorry, I seem to have been suffering from fat fingers when typing the
> reply. I can't get it to work without the quotes i.e.
> 
> Variable  SQLDSN  dbi:Pg:dbname=standard;host=my.postgres.server;port=5432;
> 
> I have also tried it without the port:
> 
> Variable  SQLDSN  dbi:Pg:dbname=standard;host=my.postgres.server;
> 
> Should either of these DSN's work?

I don't know. I don't use Postgres. I would get rid of the trailing
semicolon if I were you, but I see no reason why they should not.

Again, if it works in a Perl call it should work with IC.

-- 
Mike Heins
Perusion -- Expert Interchange Consulting    http://www.perusion.com/
phone +1.765.647.1295  tollfree 800-949-1889 <mike at perusion.com>

There's nothing sweeter than life nor more precious than time.
-- Barney


More information about the interchange-users mailing list