Re: [WiX-users] How to Build / Check a localhost connection with db2 odbc

[dB. <db...@db...>]

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:mia...@gm...] 
Sent: Wednesday, September 16, 2009 8:49 AM
To: wix...@li...
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&reg; 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&#45;12, 2009. Register now&#33;
http://p.sf.net/sfu/devconf
_______________________________________________
WiX-users mailing list
WiX...@li...
https://lists.sourceforge.net/lists/listinfo/wix-users