Thread: 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@wilsoft.nl> To: <pgsql-interfaces@postgresql.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@rutgersinsurance.com>
Sent: Tuesday, December 05, 2000 9:33 PM
Subject: Re: [INTERFACES] Resend: 16-bit ODBC-driver
> 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@wilsoft.nl>
> To: <pgsql-interfaces@postgresql.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