ODBC: dates (again) and passthrough

G'day Byron.

I have just been modifying one of my VB5/ODBC 6.30.10/PostgreSQL 6.3.2 apps
and ran into a couple of funnies.

I thought that you had said that the default date format was now US so I
changed my code to say the following:

insert into quote (id,qdate,price) values (12,'05/01/1998',123)

(that is, I reversed dd/mm/yyyy to mm/dd/yyyy) and what arrived in the
database was Jan 5, 1998. I switched it back and got the correct result.

My postmaster is running in default US mode and I have removed the registry
entry that I had before.

Also, my app originally used the DB.Execute S$,passthrough option.
This worked with the old driver but fails with an "Out of memory" error with
your driver. Removing the passthrough option fixes the app.

Cheers and thanks,
Stephen.
========================================================================
Stephen Davies Consulting scldad(at)sdc(dot)com(dot)au
Adelaide, South Australia. Voice: 61-8-82728863
Computing & Network solutions. Fax: 61-8-82741015