Testing a connection involves establishing it. I am not sure about this set of CAs, but you might want to take a look at http://msiext.codeplex.com. There's a CA called ODBC_Connect and the test buttons are implemented like this:
<Control Id="TestButton" Type="PushButton" X="40" Y="215" Width="100" Height="17" Text="Test Connection"> <Publish Property="ODBC_SERVER" Value="[DATABASE_SERVER]" Order="1">1</Publish> <Publish Property="ODBC_SERVER" Value="[ComputerName]" Order="1"><![CDATA[DATABASE_SERVER = "(local)"]]></Publish> <Publish Property="ODBC_CONNECTION_STRING" Value="Driver=SQL Server;Server=[ODBC_SERVER],1433;Uid=[DATABASE_USERNAME];Pwd=[DATABASE_PASSWORD]" Order="2">1</Publish> <Publish Event="DoAction" Value="ODBC_Connect" Order="3">1</Publish> <Publish Property="LOGON_VALID" Value="1" Order="4"><![CDATA[ODBC_CONNECTION_ESTABLISHED]]></Publish> <Publish Property="LOGON_VALID" Value="0" Order="4"><![CDATA[NOT ODBC_CONNECTION_ESTABLISHED]]></Publish> <Publish Property="LOGON_ERROR" Value="Unexpected Error" Order="4"><![CDATA[(NOT ODBC_CONNECTION_ESTABLISHED) AND (ODBC_ERROR = "")]]></Publish> <Publish Property="LOGON_ERROR" Value="[ODBC_ERROR]" Order="4"><![CDATA[NOT ODBC_CONNECTION_ESTABLISHED]]></Publish> <Publish Event="SpawnDialog" Value="InvalidLogonDlg" Order="5"><![CDATA[NOT ODBC_CONNECTION_ESTABLISHED]]></Publish> </Control> I don't see a problem using this for DB2 if you can construct the proper connection string. dB. @ dblock.org Moscow|Geneva|Seattle|New York -----Original Message----- From: danimian [mailto:miand...@gmail.com] Sent: Wednesday, September 16, 2009 8:49 AM To: wix-users@lists.sourceforge.net Subject: [WiX-users] How to Build / Check a localhost connection with db2 odbc Hi, i have written the following code in wix to build a localhost db2 odbc driver connection. .msi is running without any problem. First question is about the written code, is it right to build the connection? or missing something? Second question how can i check whether the connection was successfull or not? here is code: <Component Id="MyComponent" Guid="myGuid" DiskId="1"> <ODBCDataSource Id="db2connection" Name="myDataBase" Registration="machine" DriverName="IBM DB2 ODBC DRIVER" > <Property Id="Server" Value="localhost" /> <Property Id="Database" Value="myDatabase" /> <Property Id="Port" Value="50000" /> <Property Id="User" Value="db2admin" /> <Property Id="Passwort" Value="password" /> </ODBCDataSource> </Component> <Feature Id="MyFeature" Title="TheODBCDSNCreate" Level="1"> <ComponentRef Id="MyComponent" /> </Feature> Please explain, I am new to wix. Best Regards Adnan -- View this message in context: http://n2.nabble.com/How-to-Build-Check-a-localhost-connection-with-db2-odbc-tp3655921p3655921.html Sent from the wix-users mailing list archive at Nabble.com. ------------------------------------------------------------------------------ Come build with us! The BlackBerry® Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9-12, 2009. Register now! http://p.sf.net/sfu/devconf _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
