psqlodbc installation problem

Hi everybody,

I've lost my driver install and I can't recreate it... I'm trying to
install psqlODBC 08.02.0002 using the MSI installer. I have the driver
from PostgreSQL installed, which gives me a "PostgreSQL ANSI" and a
"PostgreSQL Unicode" driver (both version 8.01.0200), but installing the
MSI does _not_ add another driver. Is there anyhting else I need to do
to get this to work?

Thanks in advance!

Cheers,
Bart

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Re: psqlodbc installation problem

> install psqlODBC 08.02.0002 using the MSI installer. I have the driver
> from PostgreSQL installed, which gives me a "PostgreSQL ANSI" and a
> "PostgreSQL Unicode" driver (both version 8.01.0200), but installing the
> MSI does _not_ add another driver. Is there anyhting else I need to do
> to get this to work?

MSI - I hope you use OS Windows.

It may install PostgreSQL driver. It contains:
C:\Program Files\psqlODBC\0802\bin\psqlodbc35w.dll (and some others
needed only for SSL and kerberos)
Registry:
HKEY_LOCAL_MACHINE\Software\ODBC\ODBCINST.INI\PostgreSQL
APILevel = REG_SZ 1
ConnectFunctions = REG_SZ YYN
Driver = REG_SZ C:\Program Files\psqlODBC\0802\bin\psqlodbc35w.dll
DriverODBCVer = REG_SZ 03.51
Setup = REG_SZ C:\Program Files\psqlODBC\0802\bin\psqlodbc35w.dll
SQLLevel = REG_SZ 1
UniqueIndex = REG_SZ 1 (I'm not sure if it's required)
UsageCount = REG_DWORD 0x0001
HKEY_LOCAL_MACHINE\Software\ODBC\ODBCINST.INI\ODBC Drivers
PostgreSQL = REG_SZ Installed

I hope I help you.

Regards,

Luf

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

FW: Re: psqlodbc installation problem

--_890186ed-0018-4f10-8839-b2012cb9abd1_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

i have no idea why, but i seem to be subscribed to this email group, can so=
meone please remove me :-S

> Date: Tue, 6 Jun 2006 07:59:27 +0200> From: luf@pzkagis.cz> To: bart@samw=
el.tk> CC: pgsql-odbc@postgresql.org> Subject: Re: [ODBC] psqlodbc installa=
tion problem> > > install psqlODBC 08.02.0002 using the MSI installer. I ha=
ve the driver > > from PostgreSQL installed, which gives me a "PostgreSQL A=
NSI" and a > > "PostgreSQL Unicode" driver (both version 8.01.0200), but in=
stalling the > > MSI does _not_ add another driver. Is there anyhting else =
I need to do > > to get this to work?> > MSI - I hope you use OS Windows.> =
> It may install PostgreSQL driver. It contains:> C:\Program Files\psqlODBC=
\0802\bin\psqlodbc35w.dll (and some others> needed only for SSL and kerb=
eros)> Registry:> HKEY_LOCAL_MACHINE\Software\ODBC\ODBCINST.INI\PostgreSQL>=
APILevel =3D REG_SZ 1> ConnectFunctions =3D REG_SZ YYN> Driver =3D R=
EG_SZ C:\Program Files\psqlODBC\0802\bin\psqlodbc35w.dll> DriverODBCVer =
=3D REG_SZ 03.51> Setup =3D REG_SZ C:\Program Files\psqlODBC\0802\bin\psq=
lodbc35w.dll> SQLLevel =3D REG_SZ 1> UniqueIndex =3D REG_SZ 1 (I'm not =
sure if it's required)> UsageCount =3D REG_DWORD 0x0001> HKEY_LOCAL_MACHI=
NE\Software\ODBC\ODBCINST.INI\ODBC Drivers> PostgreSQL =3D REG_SZ Install=
ed> > I hope I help you.> > Regards,> > Luf> > ---------------------------(=
end of broadcast)---------------------------> TIP 1: if posting/reading thr=
ough Usenet, please send an appropriate> subscribe-nomail command to=
majordomo@postgresql.org so that your> message can get through to t=
he mailing list cleanly
____________________________________________________________ _____
Express yourself instantly with MSN Messenger! Download today it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/ 01/=

--_890186ed-0018-4f10-8839-b2012cb9abd1_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

=0A=
=0A=
=0A=
=0A=
i have no idea why, but i seem to be subscribed to this email group, =
can someone please remove me :-S

Re: psqlodbc installation problem

Ludek Finstrle wrote:
>> install psqlODBC 08.02.0002 using the MSI installer. I have the driver
>> from PostgreSQL installed, which gives me a "PostgreSQL ANSI" and a
>> "PostgreSQL Unicode" driver (both version 8.01.0200), but installing the
>> MSI does _not_ add another driver. Is there anyhting else I need to do
>> to get this to work?
>
> MSI - I hope you use OS Windows.

I wish I didn't, but yes, I do. :-)

> It may install PostgreSQL driver. It contains:
> C:\Program Files\psqlODBC\0802\bin\psqlodbc35w.dll (and some others
> needed only for SSL and kerberos)
> Registry:
> HKEY_LOCAL_MACHINE\Software\ODBC\ODBCINST.INI\PostgreSQL
> APILevel = REG_SZ 1
> ConnectFunctions = REG_SZ YYN
> Driver = REG_SZ C:\Program Files\psqlODBC\0802\bin\psqlodbc35w.dll
> DriverODBCVer = REG_SZ 03.51
> Setup = REG_SZ C:\Program Files\psqlODBC\0802\bin\psqlodbc35w.dll
> SQLLevel = REG_SZ 1
> UniqueIndex = REG_SZ 1 (I'm not sure if it's required)
> UsageCount = REG_DWORD 0x0001
> HKEY_LOCAL_MACHINE\Software\ODBC\ODBCINST.INI\ODBC Drivers
> PostgreSQL = REG_SZ Installed

The files are present, but for me, every registry key except UniqueIndex
is missing. I do have BoolsAsChar, CancelAsFreeStmt, CommLog, Debug,
ExtraSysTablePrefixes, Fetch, Ksqo, MaxLongVarCharSize, and some more
settings of the driver. It might be that the MSI doesn't install the
registry key if it is already present. [checking...] No, no dice. Maybe
the MSI doesn't install the registry key if the _files_ are already
present. [checking...] Yes, removing the files and reinstalling works, I
now have my driver back. Apparently the uninstaller didn't remove them.
However, I just re-tested uninstalling as well, and the uninstaller
_does_ remove the files now...

> I hope I help you.

Yes, thanks very much for your help! I'm very thankful for the fact that
I can access my database again. :-)

Cheers,
Bart

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings