Обсуждение: Re: Your ODBC driver = PostODBC?

Поиск
Список
Период
Сортировка

Re: Your ODBC driver = PostODBC?

От
Byron Nikolaidis
Дата:
Mike Edwards wrote:

> Hi Byronn,
> I came across your message regarding the ODBC driver for PostgreSQL.  Is
> this the same as soemthing called PostODBC?  I ask, because I installed
> PostODBC and it does not seem to work quite correctly, and I was hoping
> to give your driver a shot.  If it is the same thing, I will install the
> postdll.zip files.  If not, I need to remove the old stuf and install
> postdrv.exe.
>

Well, our (Insight that is) version is currently at 6.30.0242 and is called
PostgreSQL odbc driver.  This driver is actively being maintained and
enhanced by me (Byron).  In fact, a new version will be available tomorrow.
We post a 32bit self-extracting EXE full install (postdrv.exe), so you dont
have to mess around with compiling it just to try it out.  The full source
code (postsrc.zip) is also there which includes the VC4.0 project workspace
that I use to build the driver.  And for those interested in saving time,
you can just download the postdll.zip, and extract psqlodbc.dll it into your
\windows\system directory.  YOU CAN ONLY DO THIS, however, if you have done
the full install (postdrv.exe) at least once --  otherwise, it wont work.
(maybe that is your problem).

Our website is http://www.insightdist.com/psqlodbc

I'm not sure about how our driver gets into the postgres distribution -- it
may be called Postodbc?  If you want, check for the "psqlodbc.h" file, and
there should be some defines like the following:
#define DRIVERNAME             "PostgreSQL ODBC"
#define DBMS_NAME              "PostgreSQL"
#define DBMS_VERSION           "06.30.0242 PostgreSQL 6.3"
#define POSTGRESDRIVERVERSION  "06.30.0242"
#define DRIVER_FILE_NAME  "PSQLODBC.DLL"

A while back, there was some division over whether to include it in the
distribution because it was only for 32bit windows (95 or nt).   There is a
pending patch to allow it to work on unix with iodbc, which I intend to put
in as soon as possible.  If running 16 bit applications on win95 or win nt,
it will work too.  The only scenario which is not supported yet is running
Win3.1

I'm not sure what the final standing on all this was.  Anyone like to
respond?

Byron



Re: [INTERFACES] Re: Your ODBC driver = PostODBC?

От
The Hermit Hacker
Дата:
On Thu, 28 May 1998, Byron Nikolaidis wrote:

> A while back, there was some division over whether to include it in the
> distribution because it was only for 32bit windows (95 or nt).   There is a
> pending patch to allow it to work on unix with iodbc, which I intend to put
> in as soon as possible.  If running 16 bit applications on win95 or win nt,
> it will work too.  The only scenario which is not supported yet is running
> Win3.1
>
> I'm not sure what the final standing on all this was.  Anyone like to
> respond?

    The argument kinda of died out, I think *shrug*  Not enough ppl
seems to have cared, I guess...

    As for included in the distribution...its there as just
src/interfaces/odbc, but its really old...never saw any patches for
it...if I gave you an account directly into the repository, would you be
willing to upgrade and maintain those?  Nobody else appears to be
contributing anything to the code but you, so I'm not too worried about
problems arising *shrug*




Re: [INTERFACES] Re: Your ODBC driver = PostODBC?

От
"Ken J. Wright"
Дата:
Byron,

How do you get a 16 bit app on win95 to use this driver? I need exactly that!

Ken

>in as soon as possible.  If running 16 bit applications on win95 or win nt,
>it will work too.  The only scenario which is not supported yet is running
>Win3.1

Re: [INTERFACES] Re: Your ODBC driver = PostODBC?

От
Byron Nikolaidis
Дата:

The Hermit Hacker wrote:

> On Thu, 28 May 1998, Byron Nikolaidis wrote:
>
> > A while back, there was some division over whether to include it in the
> > distribution because it was only for 32bit windows (95 or nt).   There is a
> > pending patch to allow it to work on unix with iodbc, which I intend to put
> > in as soon as possible.  If running 16 bit applications on win95 or win nt,
> > it will work too.  The only scenario which is not supported yet is running
> > Win3.1
> >
> > I'm not sure what the final standing on all this was.  Anyone like to
> > respond?
>
>         The argument kinda of died out, I think *shrug*  Not enough ppl
> seems to have cared, I guess...
>
>         As for included in the distribution...its there as just
> src/interfaces/odbc, but its really old...never saw any patches for
> it...if I gave you an account directly into the repository, would you be
> willing to upgrade and maintain those?  Nobody else appears to be
> contributing anything to the code but you, so I'm not too worried about
> problems arising *shrug*


Yes, I would certainly be willing to maintain it!   I have been working a lot
with the driver on my own time.  Our customers (Insight) only needed it to do so
much, so I am now mostly working on the driver on my own time.  I would like to
keep this driver working well, adding new enhancements and functionality
(including a 16 bit version eventually), and of course, fixing any problems that
arise.

BTW, I have gotten at least 4 patches from people (new features and bug fixes)
and have put them in.  So, people are contributing.

So, just give me some instruction on what to do with the repository, etc.  Maybe
we could even do something with the divergent odbc driver websites too.  That
would also be on my own time.

Regards,

Byron


Re: [INTERFACES] Re: Your ODBC driver = PostODBC?

От
Byron Nikolaidis
Дата:

Ken J. Wright wrote:

> Byron,
>
> How do you get a 16 bit app on win95 to use this driver? I need exactly that!
>
>

Through the magic of "thunking".  The 16 bit app should be able to thunk to the
32 bit driver.Thunking files are redistributed with our self-extracting exe.  I
know people are using Access 2.0, for example, with our 32 bit driver
successfully.

Byron