Skip site navigation (1) Skip section navigation (2)

Re: Support for PostgreSQL 8.1.3 stable

From: "Andrew Ng" <ngandrew(at)fastmail(dot)fm>
To: "Ludek Finstrle" <luf(at)pzkagis(dot)cz>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Support for PostgreSQL 8.1.3 stable
Date: 2006-04-25 14:43:59
Message-ID: 1145976239.10567.259885221@webmail.messagingengine.com (view raw or flat)
Thread:
Lists: pgsql-odbc
The only odbc.ini in my system is at /usr/local/etc/odbc.ini. If I'm not
wrong, it's for unixODBC configurations. Do you mind posting the file
location and content(with confidential data obfuscated)?

On Tue, 25 Apr 2006 16:04:43 +0200, "Ludek Finstrle" <luf(at)pzkagis(dot)cz>
said:
> > Added but /tmp/mylog_*.log file not found, search return no match as
> > well. I have checked the docs for unixODBC, don't think there is a
> > "Debug" entry, there are "Trace" and "TraceFile". I had enabled them but
> > couldn't find the log file too.
> 
> It's not unixODBC parameter. It's psqlodbc one. I check it and I have
> here Debug = Yes. I'm lazy to find if Yes and 1 is equivalent.
> I try it on linux box and it works as I expect.
> The non-exist mylog file could means that unixODBC doesn't connect
> psqlodbc.
> Maybe you could try to use Trace and TraceFile but I know nothing
> about it. I think they're unixODBC parameters.
> 
> Regards,
> 
> Luf
> 
> > On Tue, 25 Apr 2006 15:03:16 +0200, "Ludek Finstrle" <luf(at)pzkagis(dot)cz>
> > said:
> > > > I can't find instructions on how to enable mylog and where the output is
> > > > save to, please provide any reference or steps. Thanks.
> > > 
> > > You only add line Debug = 1 in the odbc.ini. You find the mylog output
> > > in /tmp directory. It is /tmp/mylog_*.log.
> > > 
> > > > ---------------------------------------------------------------------------
> > > > I'm sorry for late response at firest.
> > > > 
> > > > > like to check if psqlodbc-08.01.0200 can work with PostgreSQL 8.1.3?
> > > > 
> > > > Yes it can. I see no problem with this combination.
> > > > 
> > > > > I had compiled and installed psqlodbc on OpenBSD 3.8, but was unable to
> > > > > connect with isql. The Driver Manager is unixODBC-2.2.11 from source and
> > > > > PGSQL was installed from source as well. There was no error of warning
> > > > > when I run isql, the program just exit and return to the shell prompt.
> > > > 
> > > > > I tried with PGSQL 8.0.7 installed from OpenBSD packages, and was able
> > > > > to connect and query the db. Thus, I seek confirmation/verification on
> > > > > 8.1.3 support. Appreciate any advice. Thanks.
> > > > 
> > > > Are you able to produce some mylog output with psqlodbc 08.01.0200?
-- 
  Andrew Ng
  ngandrew(at)fastmail(dot)fm

-- 
http://www.fastmail.fm - Email service worth paying for. Try it for free


In response to

Responses

pgsql-odbc by date

Next:From: Philippe LangDate: 2006-04-25 16:16:47
Subject: PG 8 INOUT parameters & ADO
Previous:From: Ludek FinstrleDate: 2006-04-25 14:04:43
Subject: Re: Support for PostgreSQL 8.1.3 stable

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group