[ic] Interchange remote Postgres TCP
speters at killbygayford.co.uk
Thu Jul 19 10:51:13 EDT 2007
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?
More information about the interchange-users