Re: use psqlodbc on Windows without Windows driver manager?

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(dot)takay(at)jp(dot)fujitsu(dot)com>
> An: Dieter Mueller (BOI GmbH) <dieter(dot)mueller(at)boi(dot)at>,
> pgsql-odbc(at)postgresql(dot)org <pgsql-odbc(at)postgresql(dot)org>
> Datum: 12.04.2016 02:35
>
>>> From: pgsql-odbc-owner(at)postgresql(dot)org
>>> [mailto:pgsql-odbc-owner(at)postgresql(dot)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
>>
>
>

--
Prisma Computer GmbH
Sternallee 89 - 68723 Schwetzingen
Fon 0 62 02.5 75 68 10
Fax 0 62 02.5 75 68 75
eMail: m(dot)neumann(at)prisma-computer(dot)de
Internet: www.prisma-computer.de

Geschäftsführung: Gerald Wilkens, Bernhard Goebel
Amtsgericht Mannheim HRB 420986 S
USt-IdNr.: DE 144 278 153