0

I am creating a new installer for a program at work and I'm having issues registering the psqlodbc driver. Unfortunately I don't know much about installers or odbc drivers.

I have a copy of the old installer for this particular program, which was created by someone else. When I look at the registry table in the msi using Orca, I can see several entries related to psqlodbc :

**Registry**            **Key**                                 **Name**            **Value**
psqlodbc.reg.1.<GUID>   SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers PostgreSQL          Installed
psqlodbc.reg.2.<GUID>   SOFTWARE\ODBC\ODBCINST.INI\PostgreSQL   APILevel            1
psqlodbc.reg.3.<GUID>   SOFTWARE\ODBC\ODBCINST.INI\PostgreSQL   ConnectFunctions    YYN
psqlodbc.reg.4.<GUID>   SOFTWARE\ODBC\ODBCINST.INI\PostgreSQL   Driver              [#psqlodbc.dll.<GUID>]
psqlodbc.reg.5.<GUID>   SOFTWARE\ODBC\ODBCINST.INI\PostgreSQL   DriverODBCVer       03.00
psqlodbc.reg.6.<GUID>   SOFTWARE\ODBC\ODBCINST.INI\PostgreSQL   FileUsage           0
psqlodbc.reg.7.<GUID>   SOFTWARE\ODBC\ODBCINST.INI\PostgreSQL   Setup               [#psqlodbc.dll.<GUID>]
psqlodbc.reg.8.<GUID>   SOFTWARE\ODBC\ODBCINST.INI\PostgreSQL   SQLLevel            1
psqlodbc.reg.9.<GUID>   SOFTWARE\ODBC\ODBCINST.INI\PostgreSQL   UsageCount          #1

However, when I try to harvest the psqlodbc.dll file using heat in order to incorporate it into my installer, all that shows up in the .wxs file is a file element (no registry data). I've tried registering manually using regsvr32, but that gives me an error about the "entry-point" not being found.

Basically, the old installer is creating registry entries for the psqlodbc driver, which I can see using regedit and I have no idea how to incorporate this behavior into my new installer.

This is my last week at work and I'd really like to get this installer working before I leave.

Please help!!

Bob Arnson
  • 21,377
  • 2
  • 40
  • 47
user2437443
  • 2,067
  • 4
  • 23
  • 38

1 Answers1

1

Does it work if you replicate the registry entries from the original installer using RegistryKey and RegistryValue elements? It might just be hand-authored registry values in the original package.

Bob Arnson
  • 21,377
  • 2
  • 40
  • 47
  • Good idea! I'm trying to implement that now, but I'm having trouble writing anything to the registry at all. I've posted a separate question on that issue here: http://stackoverflow.com/q/18437649/2437443 – user2437443 Aug 26 '13 at 07:07
  • 1
    OK, I figured out my registry issue, tried your solution and it worked! Thanks a lot for the help! – user2437443 Aug 26 '13 at 22:42