Re: [MASSMAIL]Re: use psqlodbc on Windows without Windows driver manager? - Mailing list pgsql-odbc

From Dieter Mueller (BOI GmbH)
Subject Re: [MASSMAIL]Re: use psqlodbc on Windows without Windows driver manager?
Date
Msg-id 570E0B72.1030905@boi.at
Whole thread Raw
In response to Re: use psqlodbc on Windows without Windows driver manager?  ("Prisma Computer - M. Neumann" <m.neumann@prisma-computer.de>)
List pgsql-odbc
Hello Malte,

the application already calls SQLDriverConnect, which works fine with
and without the driver manager. Thank you very much :-)

Kind regards,
Viele Grüße,

Dieter Mueller


Am 13.04.2016 um 10:48 schrieb Prisma Computer - M. Neumann:
> Hello Dieter,
>
> it is possible to use the odbc-driver without the windows driver manager.
>
> You only need to change the connection-function. Instead of Calling
> SQLConnect use SQLDriverConnect with the correct connectionstring.
>
> Kind regards,
> Malte
>
> Am 12.04.2016 um 08:41 schrieb Dieter Mueller (BOI GmbH):
>> Hello Takayuki,
>>
>> thanks for your reply :-)
>> Calling the ODBC driver via driver manager requires the driver to be
>> installed in Windows (means: written in the Windows registry). But a
>> test distribution of our (ODBC-)application should be able to run
>> without the need of any installation procedure and without
>> administrator rights.
>> IBM's DB2-CLI (call level interface) can be operated in 2 modes: with
>> or without an ODBC driver manager. So i hoped that the PostgreSQL ODBC
>> driver has this ability, too.
>>
>> Kind regards,
>> Dieter Mueller
>>
>>
>> -------- Original-Nachricht --------
>> Betreff: Re: [ODBC] use psqlodbc on Windows without Windows driver
>> manager?
>> Von: Tsunakawa, Takayuki <tsunakawa.takay@jp.fujitsu.com>
>> An: Dieter Mueller (BOI GmbH) <dieter.mueller@boi.at>,
>> pgsql-odbc@postgresql.org <pgsql-odbc@postgresql.org>
>> Datum: 12.04.2016 02:35
>>
>>>> From: pgsql-odbc-owner@postgresql.org
>>>> [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Dieter Mueller
>>>> (BOI
>>>> GmbH)
>>>> is psql-odbc designed to work on Windows without the Windows ODBC
>>>> driver
>>>> manager?
>>>>
>>>> (I want to prepare a distribution of our software for testing
>>>> purposes that
>>>> can be used without any installation on Windows - no ODBC driver
>>>> installation
>>>> as well)
>>>>
>>>> I created my own psqlodbc30a.lib of psqlodbc30a.dll by calling MS tools
>>>> "dumpbin /exports ..." and "lib /def:...", then I linked my ODBC
>>>> application
>>>> with the new psqlodbc30a.lib instead of Microsoft's obdc32.lib and
>>>> odbccp32.lib.
>>>
>>> I don't think it's reasonable.  According to the ODBC spec, the
>>> Driver Manager does many tasks, including error checks, and the ODBC
>>> driver depends on it.
>>>
>>> Why do you want to avoid linking with odbc32.lib?
>>>
>>> Regards
>>> Takayuki Tsunakawa
>>>
>>
>>
>


pgsql-odbc by date:

Previous
From: "Prisma Computer - M. Neumann"
Date:
Subject: Re: use psqlodbc on Windows without Windows driver manager?
Next
From: Huong Dangminh
Date:
Subject: Re: Why does binary of 09.05.0100 version was built with Visual Studio 2013?