WiX ODBC 数据源错误。 ODBC 错误 8：无效的关键字-值对

Question

我试图在使用 Windows Installer XML (WiX) 在 Windows 7 计算机上安装的安装过程中为 SQL Server 2008 R2 数据库建立数据源名称 (DSN)。我正在对话框窗口中设置两个集成安全条件，但我的问题是其中一个失败。 Windows 身份验证（INTEGRATEDSECURITY =“是”）工作正常且没有错误。 SQL Server 身份验证（INTEGRATEDSECURITY =“否”）在 SQL 用户名和密码上失败。至少人们相信是这样，因为 SQL Server 名称和数据库名称对于 Windows 身份验证来说就像一个魅力。我希望有人能找到一个解决方案，不需要我使用第三方扩展来使用 SQL Server 身份验证创建与数据库的正确 ODBC DSN 连接。

在失败路径上安装期间出现的错误如下：

“配置 ODBC 数据源时出错：DB_Test，ODBC 错误 8：无效的关键字-值对。验证文件 DB_Test 是否存在并且您可以访问它。”

ODBC数据源如下：

<Component Id="DB_Test_DSN_SSPI" Guid="{******}">
  <Condition>INTEGRATEDSECURITY = "Yes"</Condition>
    <ODBCDataSource Id="DB_Test_DSN_SSPI" Name="DB_Test $(var.DisplayVersion)" DriverName="SQL Server" KeyPath="yes" Registration="machine">
      <Property Id="Server" Value="[SERVERNAME]" />
      <Property Id="Database" Value="[DATABASENAME]" />
      <Property Id="Description" Value="DB_Test" />
      <Property Id="Trusted_Connection" Value="[INTEGRATEDSECURITY]" />
    </ODBCDataSource>
</Component>
<Component Id="DB_Test_DSN_SQLAUTH" Guid="{*****}">
  <Condition>INTEGRATEDSECURITY = "No"</Condition>
    <ODBCDataSource Id="DB_Test_DSNSQLAUTH" Name="DB_Test $(var.DisplayVersion)" DriverName="SQL Server" KeyPath="yes" Registration="machine">
      <Property Id="Server" Value="[SERVERNAME]" />
      <Property Id="Database" Value="[DATABASENAME]" />
      <Property Id="Description" Value="DB_Test" />
      <Property Id="Trusted_Connection" Value="[INTEGRATEDSECURITY]" />
      <Property Id="uid" Value="[DATABASEUSER]" />
      <Property Id="pwd" Value="[DATABASEPASS]" />
    </ODBCDataSource>
</Component>

自定义对话框UI如下：

<Dialog Id="DialogDatabase" Width="370" Height="270" Title="$(var.ProductName) Setup">      
   <Control Id="Title" Type="Text" X="15" Y="6" Width="200" Height="15" Transparent="yes" NoPrefix="yes" Text="{\WixUI_Font_Title}Specify Database" />
   <Control Id="Description" Type="Text" X="25" Y="23" Width="280" Height="15" Transparent="yes" NoPrefix="yes" Text="Specify the location of the DB_Test" />

   <Control Id="BannerBitmap" Type="Bitmap" X="0" Y="0" Width="370" Height="44" TabSkip="no" Text="!(loc.InstallDirDlgBannerBitmap)" />
   <Control Id="BannerLine" Type="Line" X="0" Y="44" Width="370" Height="0" />
   <Control Id="BottomLine" Type="Line" X="0" Y="234" Width="370" Height="0" />

   <Control Id="ServerNameLabel" Type="Text" X="32" Y="54" Width="290" Height="13" NoPrefix="yes" Text="SQL Server (Hostname\Instance,Port):" />
   <Control Id="ServerNameEdit" Type="Edit" X="32" Y="66" Width="290" Height="18" Property="SERVERNAME" />

   <Control Id="DatabaseNameLabel" Type="Text" X="32" Y="88" Width="290" Height="13" NoPrefix="yes" Text="Database name:" />
   <Control Id="DatabaseNameEdit" Type="Edit" X="32" Y="100" Width="290" Height="18" Property="DATABASENAME" />

   <Control Id="INTEGRATEDSECURITY" Type="RadioButtonGroup" X="32" Y="124" Width="290" Height="28" HasBorder="yes" Property="INTEGRATEDSECURITY" Text="Select Authentication Method">
      <RadioButtonGroup Property="INTEGRATEDSECURITY">
         <RadioButton Value="Yes" X="8" Y="12" Width="130" Height="10" Text="Windows Authentication" />
         <RadioButton Value="No" X="150" Y="12" Width="130" Height="10" Text="SQL Server Authentication" />
      </RadioButtonGroup>
   </Control>

   <Control Id="DatabaseUserLabel" Type="Text" Hidden="yes" X="32" Y="158" Width="290" Height="13" NoPrefix="yes" Text="SQL Username:">
      <Condition Action="show"><![CDATA[INTEGRATEDSECURITY = "No"]]></Condition>
      <Condition Action="hide"><![CDATA[INTEGRATEDSECURITY = "Yes"]]></Condition>
   </Control>
   <Control Id="DatabaseUserEdit" Type="Edit" Hidden="yes" X="32" Y="170" Width="290" Height="18" Property="DATABASEUSER">
      <Condition Action="show"><![CDATA[INTEGRATEDSECURITY = "No"]]></Condition>
      <Condition Action="hide"><![CDATA[INTEGRATEDSECURITY = "Yes"]]></Condition>
   </Control>

   <Control Id="DatabasePassLabel" Type="Text" Hidden="yes" X="32" Y="192" Width="290" Height="13" NoPrefix="yes" Text="SQL Password:">
      <Condition Action="show"><![CDATA[INTEGRATEDSECURITY = "No"]]></Condition>
      <Condition Action="hide"><![CDATA[INTEGRATEDSECURITY = "Yes"]]></Condition>
   </Control>
   <Control Id="DatabasePassEdit" Type="Edit" Hidden="yes" X="32" Y="204" Width="290" Height="18" Property="DATABASEPASS" Password="yes">
      <Condition Action="show"><![CDATA[INTEGRATEDSECURITY = "No"]]></Condition>
      <Condition Action="hide"><![CDATA[INTEGRATEDSECURITY = "Yes"]]></Condition>
   </Control>

   <Control Id="Next" Type="PushButton" X="236" Y="243" Width="56" Height="17" Default="yes" Text="Next">
      <!--<Publish Event="NewDialog" Value="VerifyReadyDlg">1</Publish>-->
   </Control>
   <Control Id="Back" Type="PushButton" X="180" Y="243" Width="56" Height="17" Text="Back">
      <!--<Publish Event="NewDialog" Value="CustomizeDlg">1</Publish>-->
   </Control>
   <Control Id="Cancel" Type="PushButton" X="304" Y="243" Width="56" Height="17" Cancel="yes" Text="Cancel">
      <Publish Event="SpawnDialog" Value="CancelDlg">1</Publish>
   </Control>
</Dialog>

感谢大家协助我解决这个问题！

Answer 1

我有同样的错误...通过一些研究，我认为这与由于安全原因 SQL 连接不支持 uid 和 pwd 有关。这让我认为 ODBC 连接需要通过自定义操作而不是 ODBCDataSource 来设置...