Re: Installer question

> -----Original Message-----
> From: Kristis Makris [mailto:kristis(dot)makris(at)datasoft(dot)com]
> Sent: 14 September 2001 02:01
> To: Dave Page
> Subject: Installer question
>
>
> Hi Dave,
>
> As I understand you are the person packaging the PsqlODBC
> driver, and I have a few driver packaging questions for you,
> if you have the time.
>
> I've been trying to figure out what registry entries need to
> be merged in order to properly add the driver in the ODBC
> Manager, plus whetever else needs to be done (e.g registering
> DLLs, etc). I'm at a stage where after merging a bunch of
> registry entries and copying over the psqlodbc.dll file, I
> try to manually add a system DSN using the ODBC Manager. I
> get the error "The Setup routines for the PostgreSQL ODBC
> driver cold not be loaded due to system error code 1114"
> followed by "Could not load the setup or translator library".
>
> I grabbed the .reg file distributed with the v04 of the
> driver and merged that in the registry. Here are it's contents:
>
>
> **************************************************************
> *************
> REGEDIT4
>
> [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI]
>
> [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers]
> "PostgreSQL"="Installed"
>
> [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PostgreSQL]
> "APILevel"="1"
> "ConnectFunctions"="YYN"
> "Driver"="PSQLODBC.DLL"
> "DriverODBCVer"="02.50"
> "FileUsage"="0"
> "Setup"="PSQLODBC.DLL"
> "SQLLevel"="1"
> "UsageCount"=dword:00000001
> **************************************************************
> *************
>
> Have their been any additions to the entries merged in the
> registry, or anything else I should know about? I suppose I'm
> trying to replicate the process of distributing the ODBC
> driver along with a client application into a single
> installer file. Is there some FAQ or HOWTO or .txt file with
> casual notes you folks are following for doing that?

Hi Kristis,

Basically all you need to do to install the driver manually is to add the
registry entries above and copy psqlodbc.dll to your system32 directory
(assuming your machine has and ODBC driver manager installed - which it
should unless it's an early Win95 machine iirc). There is no need to
register any files with regsvr32 or anything like that.

Having said that, those registry settings may well change with future
releases of the driver so installing that way isn't really recommended. I
will be releasing the new version of the driver as a Merge Module as well as
the other three distros, so if you're using a Windows Installer compliant
installation system then you should just be able to include that in your
installation. Alternatively, it is possible to silently install the existing
msi distro - check out the command line options for msiexec.exe. I
install/upgrade various bits of software on workstations on a multisite
network this way - just include the relevant commands in your logon script.

>
> P.S.: You guys are doing an amazing job with the driver
>

Thanks, though it's Hiroshi Inoue who deserves the real credit for the
changes over the last year or so. I'm just driving Wise Installer which is
no biggie.

Regards, Dave.