15
edits
Changes
→The Installer Package
===The Installer Package===
This uses one of 8 template files, all based on registry exports, to produce entries using a mix of:-
* trusted connection
* SQL authentication
* named Database
* database not specified
- as needed. For example:-
# ODBC_template_SQL2K5_int_auth_db.reg
# ODBC_template_SQL2K5_int_auth_no_db.reg
# ODBC_template_SQL2K5_sql_auth_db.reg
# ODBC_template_SQL2K5_sql_auth_no_db.reg
# ODBC_template_SQL2K8_int_auth_db.reg
# ODBC_template_SQL2K8_int_auth_no_db.reg
# ODBC_template_SQL2K8_sql_auth_db.reg
# ODBC_template_SQL2K8_sql_auth_no_db.reg
<pre>
<package id="ODBC_CONN_X"
<variable name="tools" value="c:\tools" />
<variable name="ODBC_DSN_NAME" value="ODBC_CONN_ZODBC_CONN_X" />
<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 ServerNative Client 10.0" /> <variable name="ODBC_TEMPLATE_FILE" value="ODBC_template_SQL2K5_int_auth_no_dbODBC_template_SQL2K8_int_auth_db.reg" />
<check type="registry" condition="equals" path="HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources\%ODBC_DSN_NAME%" value="%ODBC_DRIVERNAME%" />
</package>
</pre>
This <depend>s on package "SQL_SERVER_NATIVECLIENT_10.0" which I've also added.
===The Registry Template===