Line 106: |
Line 106: |
| | | |
| ====freetds.conf==== | | ====freetds.conf==== |
− | This file contains the settings that tell freetds about each server it will connect to. Ip can (should) be replaced with FQDN. The original file contain examples. | + | This file contains the settings that tell freetds about each server it will connect to. Ip can (should) be replaced with FQDN. |
− | Make directory to hold template fragment to be included in the original file: /etc/freetds.conf | + | Make directory to hold template fragments to be included in the original path: /etc/freetds.conf |
| mkdir -p /etc/e-smith/templates-custom/etc/freetds.conf | | mkdir -p /etc/e-smith/templates-custom/etc/freetds.conf |
| | | |
− | Make and edit template fragment, "10xp3c" is my example and can be modified: | + | Copy the original file to be included as a template fragment when we regenerate the file: |
− | pico /etc/e-smith/templates-custom/etc/freetds.conf/10xp3c | + | cp /etc/freetds.conf /etc/e-smith/templates-custom/etc/freetds.conf/10original |
| + | |
| + | Make additional fragment for your foreign server, "20xp3c" is my example name and can be modified: |
| + | pico /etc/e-smith/templates-custom/etc/freetds.conf/20xp3c |
| | | |
| Add text about your foreign database server (modify to suit your conditions): | | Add text about your foreign database server (modify to suit your conditions): |
| # Microsoft SQL Server 2005 Express on a Win XP machine | | # Microsoft SQL Server 2005 Express on a Win XP machine |
| [xp3c] | | [xp3c] |
− | host = 192.168.0.112
| + | host = 192.168.0.112 |
− | port = 1433
| + | port = 1433 |
− | tds version = 8.0
| + | tds version = 8.0 |
− | instance = db_kalle
| + | instance = db_kalle |
− | Exit with ctrl-x, save with y and enter. Insert your template fragment into the original file: | + | Exit with ctrl-x, save with y and enter. Regenerate the complete file: |
| | | |
| expand-template /etc/freetds.conf | | expand-template /etc/freetds.conf |
| | | |
| ====odbcinst.ini==== | | ====odbcinst.ini==== |
− | This file tells unixODBC about the FreeTDS driver. Its kind of like an Alias, e.g. | + | This file tells unixODBC about the FreeTDS driver. |
| | | |
| mkdir -p /etc/e-smith/templates-custom/etc/odbcinst.ini | | mkdir -p /etc/e-smith/templates-custom/etc/odbcinst.ini |
| + | |
| + | cp /etc/odbcinst.ini /etc/e-smith/templates-custom/etc/odbcinst.ini/10original |
| | | |
| pico /etc/e-smith/templates-custom/etc/odbcinst.ini/20sqlserver | | pico /etc/e-smith/templates-custom/etc/odbcinst.ini/20sqlserver |
Line 144: |
Line 149: |
| mkdir -p /etc/e-smith/templates-custom/etc/odbc.ini | | mkdir -p /etc/e-smith/templates-custom/etc/odbc.ini |
| | | |
− | pico /etc/e-smith/templates-custom/etc/odbc.ini/20sqlserver | + | cp /etc/odbc.ini /etc/e-smith/templates-custom/etc/odbc.ini/10original |
| + | |
| + | pico /etc/e-smith/templates-custom/etc/odbc.ini/20xp3c |
| | | |
| Add text (modify to suit your conditions): | | Add text (modify to suit your conditions): |
| | | |
| [xp3c] | | [xp3c] |
− | Driver = FreeTDS
| + | Driver = FreeTDS |
− | Description = Connection to DB_KALLE on server xp3c
| + | Description = Connection to DB_KALLE on server xp3c |
− | Trace = No
| + | Trace = No |
− | Server = 192.168.0.112
| + | Server = 192.168.0.112 |
− | Database = db_kalle
| + | Database = db_kalle |
− | Port = 1433
| + | Port = 1433 |
− | TDS_Version = 8.0
| + | TDS_Version = 8.0 |
| | | |
| expand-template /etc/odbc.ini | | expand-template /etc/odbc.ini |