Re: Resend: 16-bit ODBC-driver

Hi,

I've asked this question several weeks ago, perhaps is was lost is space...

Is there a 16-bit ODBC driver available? I've a user who has to connect
a 16-bit application to the Postgres 7.0.x backend.
Is there somewhere an old driver under the dust?

gr,

Willem

Would the application being 16 bit really make a difference? I'd assume if
it can interface with the ODBC API, it should not matter if it was compiled
as 16 bit or 32 bit, correct?

Or do you have a problem where you need to install the postgres driver on a
Win3.1 machine?

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
----- Original Message -----
From: "W. van den Akker" <wvdakker(at)wilsoft(dot)nl>
To: <pgsql-interfaces(at)postgresql(dot)org>
Sent: Tuesday, December 05, 2000 3:23 PM
Subject: [INTERFACES] Resend: 16-bit ODBC-driver

Hi,

I've asked this question several weeks ago, perhaps is was lost is space...

Is there a 16-bit ODBC driver available? I've a user who has to connect
a 16-bit application to the Postgres 7.0.x backend.
Is there somewhere an old driver under the dust?

gr,

Willem

Adam,

The problem is: Lotus v5 (I think) is a 16-bit application. The user uses now
a Access database. I want to migrate all applications to PostgreSQL. But I'am
stuck with the Lotus-macro's. This can't be converted in a short time.
I've tried to let Lotus talk to a 32-bit driver but that won't work, only a 16-bit
driver does. In the Lotus configfile is a reference to the 16-bit ODBC driver.
For Access it looks like:

DN="DB-NAME" DL="DLODBC" DC="driver=odbcjt16.dll" AC=UI,PW;

but perhaps there is an other solution!

gr,

Willem

----- Original Message -----
From: "Adam Lang" <aalang(at)rutgersinsurance(dot)com>
To: <pgsql-interfaces(at)postgresql(dot)org>
Sent: Tuesday, December 05, 2000 9:33 PM
Subject: Re: [INTERFACES] Resend: 16-bit ODBC-driver

> Would the application being 16 bit really make a difference? I'd assume if
> it can interface with the ODBC API, it should not matter if it was compiled
> as 16 bit or 32 bit, correct?
>
> Or do you have a problem where you need to install the postgres driver on a
> Win3.1 machine?
>
> Adam Lang
> Systems Engineer
> Rutgers Casualty Insurance Company
> http://www.rutgersinsurance.com
> ----- Original Message -----
> From: "W. van den Akker" <wvdakker(at)wilsoft(dot)nl>
> To: <pgsql-interfaces(at)postgresql(dot)org>
> Sent: Tuesday, December 05, 2000 3:23 PM
> Subject: [INTERFACES] Resend: 16-bit ODBC-driver
>
>
> Hi,
>
> I've asked this question several weeks ago, perhaps is was lost is space...
>
> Is there a 16-bit ODBC driver available? I've a user who has to connect
> a 16-bit application to the Postgres 7.0.x backend.
> Is there somewhere an old driver under the dust?
>
> gr,
>
> Willem
>
>
>

I recall that 1 or 2 years ago the 16 bit code was dropped due to
support issues as the 32-bit version was being developed and expanded.

You might be able to resurrect it, but it will be at least some work
(probably *lots* of work) to upgrade the interfaces and embedded queries
to cope with a modern PostgreSQL backend.

Probably not worth it :(

- Thomas

> The problem is: Lotus v5 (I think) is a 16-bit application. The user
> uses now a Access database.

Using MS-Access 2.0 (16Bit) I cann open the 32BIT datasource without
any Problems on my NT 4 Machine.

> I want to migrate all applications to PostgreSQL.
> But I'am stuck with the Lotus-macro's. This can't be
> converted in a short time.
> I've tried to let Lotus talk to a 32-bit driver but
> that won't work, only a 16-bit driver does.

An rather strange solution would be to include the ODBC-Links into an
MDB-Database.

> DN="DB-NAME" DL="DLODBC" DC="driver=odbcjt16.dll" AC=UI,PW;

The ODBC.INI does contain an driver32 entry pointing to the
PostgreSQL-Driver.

Is it possible to connect your Lotus driectly to an ODBC-Datasource?
The Setup-Lines looks like tirectly connecting to the dirver
(bypassing the driver-manager).

Elmar