[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