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 _______________________________________________ interchange-users mailing list suppressed http://www.icdevgroup.org/mailman/listinfo/interchange-users
Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.