Обсуждение: ODBC Driver Update...

Well, here it is the new year and I'm finding my way back to the 
PostgreSQL ODBC driver...  I am planning on updating this project again...  
If you have any suggestions or bug fixes please forward them to me.

You can expect the next official release to be in late January, early 
February.  (I need to get back into the code)

Thanks for your time,
Julie

-- 
[  Julia Anne Case  ] [        Ships are safe inside the harbor,       ]
[Programmer at large] [      but is that what ships are really for.    ]  
[   Admining Linux  ] [           To thine own self be true.           ]
[ Windows/WindowsNT ] [ Fair is where you take your cows to be judged. ]         

> Well, here it is the new year and I'm finding my way back to the
> PostgreSQL ODBC driver...  I am planning on updating this project again...
> If you have any suggestions or bug fixes please forward them to me.

Hi Julie. You will find several people interested in helping, but afaik
they will all appreciate having someone able to take the lead. Folks
have offered to test and to build in specific environments, so perhaps
they will speak up again now that you will be making some (more)
additions.
                   - Thomas

I offered my services before and are still available.  I will be willing to
test odbc drivers with VB and ADO (using the ole db provider for ODBC).

So... do you know anything about writing ole db providers? ;)

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
----- Original Message -----
From: "Thomas Lockhart" <lockhart@alumni.caltech.edu>
To: "Julia A . Case" <julie@MageNet.com>
Cc: <pgsql-interfaces@postgresql.org>
Sent: Friday, December 29, 2000 5:44 PM
Subject: Re: [INTERFACES] ODBC Driver Update...


> > Well, here it is the new year and I'm finding my way back to the
> > PostgreSQL ODBC driver...  I am planning on updating this project
again...
> > If you have any suggestions or bug fixes please forward them to me.
>
> Hi Julie. You will find several people interested in helping, but afaik
> they will all appreciate having someone able to take the lead. Folks
> have offered to test and to build in specific environments, so perhaps
> they will speak up again now that you will be making some (more)
> additions.
>
>                     - Thomas

> -----Original Message-----
> From: Adam Lang [mailto:aalang@rutgersinsurance.com]
> Sent: 30 December 2000 18:16
> To: Julia A . Case
> Cc: pgsql-interfaces@postgresql.org
> Subject: Re: [INTERFACES] ODBC Driver Update...
> 
> 
> I offered my services before and are still available.  I will 
> be willing to
> test odbc drivers with VB and ADO (using the ole db provider 
> for ODBC).
> 
> So... do you know anything about writing ole db providers? ;)

Likewise I can also help with testing using VB/ADO. A couple of suggestions
(not that there is any shortage of them I expect!):

1) The int8 type currently returns SQL_BIGINT as per the ODBC 3 spec rather
than SQL_CHAR as per the ODBC 2 spec (see patch below). This prevents the
use of int8's with ADO.

2) An installation using the Microsoft Installer may be useful to many
people as it can easily be automated across a network and is supposed to be
safer than older installation methods. I can probably help with this if
required (I have the Visual Studio Installer and could possibly buy an MSI
aware Installshield if necessary).

I'm sure I speak for all ODBC users when I say thanks for taking the lead on
the driver development!

Regards, Dave.


*** pgtypes.c.orig      Fri Dec 22 09:12:22 2000
--- pgtypes.c   Fri Dec 22 09:12:22 2000
***************
*** 217,223 ****       case PG_TYPE_XID:       case PG_TYPE_INT4:          return SQL_INTEGER;

!       case PG_TYPE_INT8:                      return SQL_BIGINT;       case PG_TYPE_NUMERIC:           return
SQL_NUMERIC;
       case PG_TYPE_FLOAT4:        return SQL_REAL;
--- 217,223 ----       case PG_TYPE_XID:       case PG_TYPE_INT4:          return SQL_INTEGER;

!       case PG_TYPE_INT8:                      return SQL_CHAR;       case PG_TYPE_NUMERIC:           return
SQL_NUMERIC;
       case PG_TYPE_FLOAT4:        return SQL_REAL;

On Fri, 29 Dec 2000, Julia A . Case wrote:

> Well, here it is the new year and I'm finding my way back to the 
> PostgreSQL ODBC driver...  I am planning on updating this project again...  
> If you have any suggestions or bug fixes please forward them to me.
Great news! As I can remember, there was no decision in the version
numbers of the driver. But I agree with Thomas' opinion: it should be
autogenerated with the tarball making script for avoiding confusions.

Regards, Zoltan