Re: datetime and ODBC driver - Mailing list pgsql-odbc

From Ben Trewern
Subject Re: datetime and ODBC driver
Date
Msg-id F74JJF0nxLNLfNUa1xE000094ae@hotmail.com
Whole thread Raw
In response to datetime and ODBC driver  ("Ben Trewern" <ben_trewern@hotmail.com>)
List pgsql-odbc
Hi,

This is the first time I've had chance to try this and I still get the same
problem.  In the logs I get the following:

2002-09-30 15:23:48 ERROR:  Relation "msysconf" does not exist
2002-09-30 15:23:48 LOG:  statement: SELECT Config, nValue FROM MSysConf
2002-09-30 15:23:49 ERROR:  Type "datetime" does not exist
2002-09-30 15:23:49 LOG:  statement: CREATE TABLE "Labour"("Id"
int4,"WeekEnding" datetime,"EmployeeID" int4,"LabourRate" float8)

Is msysconf the problem?  I've looked in the the access help file and it
doesn't seem to relate.  I just wondered.

Thanks for any help

Regards,

Ben


>From: "Ben Trewern" <ben_trewern@hotmail.com>
>To: Inoue@tpf.co.jp
>CC: pgsql-odbc@postgresql.org
>Subject: Re: [ODBC] datetime and ODBC driver
>Date: Sat, 21 Sep 2002 18:46:06 +0100
>
>I seem to get the same error if ever I try to export any table with a
>date/time field.
>
>I'm not at work at the moment but i seem to remember three different
>versions of the driver.  I used the first in the list.  I'll try the other
>two on Monday.
>
>Regards,
>
>Ben
>
>>From: "Hiroshi Inoue" <Inoue@tpf.co.jp>
>>To: "Ben Trewern" <ben_trewern@hotmail.com>
>>CC: <pgsql-odbc@postgresql.org>
>>Subject: Re: [ODBC] datetime and ODBC driver
>>Date: Sun, 22 Sep 2002 01:44:47 +0900
>>
>> > -----Original Message-----
>> > From: Ben Trewern [mailto:ben_trewern@hotmail.com]
>> >
>> > Thanks for the reply.  I've downloaded your new dll (version
>> > 7.02.00.03) and
>> > copied it over the original but I still get the same error message.
>>
>>Hmm seems to work here.
>>Could you tell me the description of the Access table ?
>>
>>regards,
>>Hiroshi Inoue
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 4: Don't 'kill -9' the postmaster
>
>
>
>
>_________________________________________________________________
>Join the world�s largest e-mail service with MSN Hotmail.
>http://www.hotmail.com
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>http://archives.postgresql.org




_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com


pgsql-odbc by date:

Previous
From: "Dave Page"
Date:
Subject: psqlODBC *nix Makefile (new 7.3 open item?)
Next
From: Peter Eisentraut
Date:
Subject: Re: [HACKERS] psqlODBC *nix Makefile (new 7.3 open item?)