Thread: Support for PostgreSQL 8.1.3 stable
Hi, like to check if psqlodbc-08.01.0200 can work with PostgreSQL 8.1.3? 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. Regards, Andrew Ng -- Andrew Ng ngandrew@fastmail.fm -- http://www.fastmail.fm - And now for something completely different
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? Regards, Luf
Hi Luf, only saw your below reply from archive, must have deleted original message inadvertently :) I can't find instructions on how to enable mylog and where the output is save to, please provide any reference or steps. Thanks. Regards ------------------------------------------------------------------------------------------------ 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? Regards, Luf ------------------------------------------------------------------------------------ -- Andrew Ng ngandrew@fastmail.fm -- http://www.fastmail.fm - And now for something completely different
> 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. Regards Luf > --------------------------------------------------------------------------- > 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? > > Regards, > > Luf
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. On Tue, 25 Apr 2006 15:03:16 +0200, "Ludek Finstrle" <luf@pzkagis.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. > > Regards > > Luf > > > --------------------------------------------------------------------------- > > 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? > > > > Regards, > > > > Luf -- Andrew Ng ngandrew@fastmail.fm -- http://www.fastmail.fm - Access all of your messages and folders wherever you are
> 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@pzkagis.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?
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@pzkagis.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@pzkagis.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@fastmail.fm -- http://www.fastmail.fm - Email service worth paying for. Try it for free
> 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)? I don't know maybe someone here could see the problem. I have zero knowledge about *BSD systems so maybe problem could be there. If I have same problem I'll try strace to see what happens. The odbc.ini location depends on configure parameters for unixODBC. Regards, Luf
Thanks, will check on strace. On Wed, 26 Apr 2006 15:11:13 +0200, "Ludek Finstrle" <luf@pzkagis.cz> said: > > 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)? > > I don't know maybe someone here could see the problem. I have zero > knowledge about *BSD systems so maybe problem could be there. If I have > same problem I'll try strace to see what happens. > The odbc.ini location depends on configure parameters for unixODBC. > > Regards, > > Luf -- Andrew Ng ngandrew@fastmail.fm -- http://www.fastmail.fm - I mean, what is it about a decent email service?