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

Re: [INTERFACES] Access'97 and ODBC

From: "Jose' Soares Da Silva" <sferac(at)bo(dot)nettuno(dot)it>
To: "Julia A(dot)Case" <julie(at)hub(dot)org>
Cc: "Jose' Soares Da Silva" <sferac(at)proxy(dot)bazzanese(dot)com>, interfaces postgres <pgsql-interfaces(at)postgreSQL(dot)org>
Subject: Re: [INTERFACES] Access'97 and ODBC
Date: 1998-04-27 14:25:11
Message-ID: Pine.LNX.3.96.980427141308.1975A-100000@proxy.bazzanese.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-interfaces
On Fri, 24 Apr 1998, Julia A.Case wrote:

> 	Please see the Insight Dist site for a newer source and binary
> distribution of the ODBC driver
> 	
> 	http://www.insightdist.com/psqlodbc
> 
> Julie

Thanks Julie. Now it works, but now I have a little problem about
date formats.
I have a table with field1 DATE and field2 TIMESTAMP. If I insert data
into these fields, field2 looks OK, but Access97 show me a strange
date on field1.

This is Access97 output:
                 field1: 27/7/99
                 field2: 1998-04-27 12:20:21+02
 
This is psql output:
                 Field | Value
                 -- RECORD 0 --
                 field1| 1998-04-27
                 field2| 1998-04-27 12:20:21+02
----
PS: My DateStyle is setting to 'ISO'
                                                         Jose'


In response to

Responses

pgsql-hackers by date

Next:From: Byron NikolaidisDate: 1998-04-27 14:28:42
Subject: Re: [HACKERS] Re: [INTERFACES] retrieving varchar size
Previous:From: Matthew N. DoddDate: 1998-04-27 13:41:27
Subject: Re: [HACKERS] Re: [QUESTIONS] PostgreSQL and LDAP ?

pgsql-interfaces by date

Next:From: Byron NikolaidisDate: 1998-04-27 14:28:42
Subject: Re: [HACKERS] Re: [INTERFACES] retrieving varchar size
Previous:From: Byron NikolaidisDate: 1998-04-27 13:41:19
Subject: Re: [INTERFACES] Odbc and Visual Basic

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