Re: datetime and ODBC driver

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(at)hotmail(dot)com>
>To: Inoue(at)tpf(dot)co(dot)jp
>CC: pgsql-odbc(at)postgresql(dot)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(at)tpf(dot)co(dot)jp>
>>To: "Ben Trewern" <ben_trewern(at)hotmail(dot)com>
>>CC: <pgsql-odbc(at)postgresql(dot)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(at)hotmail(dot)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 worlds 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