Difference between revisions of "ODBC Connection"

          name="Create ODBC Connect to DB XYZ on SQL 2008 Server ABC..."
          revision="1.1"
          reboot="false"
          execute="always">

   <depends package-id="SETUP" />
   <depends package-id="SETUPTOOLS" /> 
   <depends package-id="SQL_SERVER_NATIVECLIENT_10.0" />
   
   <variable name="LOCALDOWNLOADS" value="C:\downloads\provisioning" />
   <variable name="WPKGHOME"       value="\\enterprise\development\infrastructure\provisioning\wpkg-1.1.2\" />
   <variable name="tools"          value="c:\tools" />

   <variable name="ODBC_DSN_NAME"      value="ODBC_CONN_Z" />
   <variable name="ODBC_DBSERVER"      value="SQLDEV-2005-A" />
   <variable name="ODBC_DBNAME"        value="AutomationTest" />
   <variable name="ODBC_DESC"          value="A test of blah for blah" />
   <variable name="ODBC_DRIVERNAME"    value="SQL Server" />
   <variable name="ODBC_TEMPLATE_FILE" value="ODBC_template_SQL2K5_int_auth_no_db.reg" />

   <check type="registry" condition="equals" path="HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources\%ODBC_DSN_NAME%" value="%ODBC_DRIVERNAME%" />
   
   <install cmd="xcopy /Y "%WPKGHOME%\ODBC\%ODBC_TEMPLATE_FILE%" "%LOCALDOWNLOADS%\"" />
   <install cmd="%tools%\TxtReplace\TxtReplace.exe -i "%LOCALDOWNLOADS%\%ODBC_TEMPLATE_FILE%" -r __ODBC_DSN_NAME__ "%ODBC_DSN_NAME%" -r __ODBC_DESCRIPTION__ "%ODBC_DESC%" -r __ODBC_DBSERVER__ "%ODBC_DBSERVER%" -r __ODBC_DBNAME__ "%ODBC_DBNAME%" " />
   <install cmd="%tools%\reg.exe import "%LOCALDOWNLOADS%\%ODBC_TEMPLATE_FILE%"" />

   <remove cmd="cmd /c %tools%\reg.exe DELETE "HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources" /v "%ODBC_DSN_NAME%" /f" />
   <remove cmd="cmd /c %tools%\reg.exe DELETE "HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\%ODBC_DSN_NAME%" /f" />
   
 </package>