Quoting Stephen Peters (suppressed): > 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 <suppressed> There's nothing sweeter than life nor more precious than time. -- Barney _______________________________________________ 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.