PDA

View Full Version : Basic MSI project + MSDE SP3 fails configure DSN



jefftanner
06-03-2004, 05:00 PM
Bug: Basic MSI project + MSDE SP3 + ODBC yields failure to connect to SQL service and thus fail to configure DSN.

I created a Basic MSI and a InstallScript MSI installs. Both are configured as follows
a. For MSDE SP3 deployment: the setup.ini has an INSTANCENAME="FOO"
b. For ODBC Configuration: new DSN labeled FOO that is connected to SQL Service(local)\FOO

InstallScript MSI project succeeds in creating a service named MSSQL$FOO and succeeds in adding a new DSN of FOO using SQL Service (local)\FOO.

Basic MSI project succeeds in creating a service named MSSQL$FOO but fails in adding a new DSN of FOO because the installer cannot find SQL Service (local)\FOO.