System DSN not created as expected

[DanChan]

Dear support personnel,

I am in the process of repackaging applications to MSI using InstallShield 2012 Spring Premier. When adding an ODBC DSN resource to an MSI, we found only adding User DSN (SQL Server) is effective, but otherwise adding System DSN using identical attributes is ineffective (Blank result in System DSN after the edited MSI installation). So please try to tell us why and advise a solution. FYI, we have used administrator account and no errors reported all along in our processes.

Please find the ODBC settings attached as jpg.

Thanks for your assistance.

DANIEL CHAN

[hidenori]

Are you try installing your DSN as a 64-bit system DSN on a 64-bit operating system? If so, make sure that the component assoicated with the DSN is marked as a 64-bit comoponent. Otherwise, it will be installed as a 32-bit system DSN.

Hope that helps.