Received: from u1.abs.net (root@u1.abs.net [207.114.0.131]) by hub.org
	(8.8.8/8.7.5) with ESMTP id RAA06534 for
	<pgsql-interfaces@postgreSQL.org>;
	Fri, 17 Apr 1998 17:10:31 -0400 (EDT)
Received: from insightdist.com (nobody@localhost)
	by u1.abs.net (8.8.5/8.8.5) with UUCP id QAA02828
	for pgsql-interfaces@postgreSQL.org;
	Fri, 17 Apr 1998 16:45:29 -0400 (EDT)
X-Authentication-Warning: u1.abs.net: nobody set sender to
	insightdist.com!byronn using -f
Received: by insightdist.com (AIX 3.2/UCB 5.64/4.03)
	id AA18577; Fri, 17 Apr 1998 16:28:58 -0400
Received: from [3.0.0.50] by ceodev (AIX 4.1/UCB 5.64/4.03)
	id AA67532; Fri, 17 Apr 1998 16:23:35 -0400
Message-Id: <3537BB1B.BE5085E2@insightdist.com>
Date: Fri, 17 Apr 1998 16:27:07 -0400
From: Byron Nikolaidis <byronn@insightdist.com>
X-Mailer: Mozilla 4.05 [en] (Win95; I)
Mime-Version: 1.0
To: Stephen Davies <scldad@sdc.com.au>, Hannu Krosing <hannu@trust.ee>
Cc: "pgsql-interfaces@postgreSQL.org" <pgsql-interfaces@postgreSQL.org>
Subject: Re: ODBC driver
References: <199804160750.RAA27706@mustang.sdc.com.au>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Stephen,

I fixed the problems where no dates (or times) were showing up at all in MS Query (and I hope VB too
-- i don't have that to test).  I still haven't added the DateStyle stuff yet, but at least US
format dates will show up.

Try it out.  The current stuff is at our web site.

Byron


Stephen Davies wrote:

> it does not seem to handle date fields at all well.
>
> In MS Query, I get empty columns for all date fields (using US format and real
> format), in  VB5  apps I get "3146 ODBC call failed" on the first
> OpenRecordSet call and in the same app under VB4 I get garbage if the dates
> are in real format  (dmy).
>
> If I switch the server to US format dates, the VB4 apps seem to work OK.
>
> Could we please have a version that works with VB5 and knows about
> international issues.
>