[ic] Interchange remote Postgres TCP

Stephen Peters 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?

Steve



More information about the interchange-users mailing list