Re: time problem with postgres ODBC driver (fwd) - Mailing list pgsql-odbc

From Laurette Cisneros
Subject Re: time problem with postgres ODBC driver (fwd)
Date
Msg-id Pine.LNX.4.33.0202131427580.13665-300000@visor.corp.nextbus.com
Whole thread Raw
In response to Re: time problem with postgres ODBC driver (fwd)  (Hiroshi Inoue <Inoue@tpf.co.jp>)
List pgsql-odbc
Ok, here's a lot more information on the problem.

Regardless of trying to remember which driver we used before and if it
worked then or not, we are seeing this problem now.  So, we did a lot more
research on it and found got some interesting results.

We are almost certain that the driver we were using before (when we are
almost positive we did not see this problem) was the  psqlodbcplus driver
released 04/01/2001.  In "Data Sources (ODBC)" / "Drivers" menu, it shows
7.01.00.00 as the version.

Then we loaded on the latest driver which "Data Sources (ODBC)" / "Drivers"
menu shows as version 7.01.00.07, and we started seeing this problem.

So, we re-loaded the old driver (which we no longer had on our system and had
to find and are pretty sure it was the one from 04/01/2001).  That is the
driver we are using now.

But wait -

The client we are using, ESRI's ArcView, actually provides 2 ways of
extracting the data from the database.

1)  The first way, is using it's menu option "SQLConnect".  When we use this
option, the data comes back correct!  Yay.  But, of course, this is *not*
what we need to do our work. Darn.  But it works.

2)  The second way, is to use their menu option or "Add Database Table".  With
this option, the time data comes back as today's date.  This is what we
need to do our work.

So, we turned on the "CommLog (C:\psqlodbc.log)" option for the driver.

I have attached the output from #1 and #2 to this mail:
1)  psqlodbc-756.log is the ouput for try #1 (the one that returns the time
    correctly).
2)  psqlodbc-536.log is the output for try #2 (the one that returns today's
    date instead of time).

I can see some differences in the two outputs:
A)  The "nDriverCompletion value is different.  For #1 it is 1, for #2 it
is 3.  What is this value?  Is it meaningful / pertinent?

B)  The "sqltype" value is different.  For #1 it is "40277776", for #2 it
is "47027984".  The "sqltype" value is the same for each and every column
but it is different between #1 and #2.  Meaningful / pertinent?

C)  The driver connection between the two seems to happen differently?

Any ideas?

Thanks for all your help,

Laurette

On Wed, 13 Feb 2002, Hiroshi Inoue wrote:

> Laurette Cisneros wrote:
> >
> > Repost...sorry if it goes to the list twice.
> >
> > We are seeing a problem with the ODBC driver.
> >
> > Using this table:
> >
> > create table tst
> > ( col1 date,
> >   col2 time);
> >
> > and inserting values (rows) into the date and time columns.
> >
> > When using the PostreSQL ODBC driver version 07.01.0007 against both a 7.2
> > and 7.1.3 database server, a select * from tst returns the date value for
> > col1 correctly, but returns the current date for col2 (which obviously is
> > wrong).
>
> If you are using 7.01.0007 you can turn on the Mylog
> option using ODBC DataSource Administrator.
> Please send me the Mylog output for debug.
>
> regards,
> Hiroshi Inoue
>

--
Laurette Cisneros
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
Passenger Information Everywhere

Attachment

pgsql-odbc by date:

Previous
From: "Mark A. Taff"
Date:
Subject: Re: Windows client?
Next
From: "Hiroshi Inoue"
Date:
Subject: Re: time problem with postgres ODBC driver (fwd)