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

Re: datetime and ODBC driver

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: datetime and ODBC driver
Date: 2002-09-30 14:32:52
Message-ID: F74JJF0nxLNLfNUa1xE000094ae@hotmail.com (view raw or flat)
Thread:
Lists: 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(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


Responses

pgsql-odbc by date

Next:From: SrilathaDate: 2002-09-30 16:38:21
Subject: inserting blob field
Previous:From: Dave PageDate: 2002-09-29 19:11:53
Subject: psqlODBC *nix Makefile (new 7.3 open item?)

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