206
edits
Changes
From SME Server
Jump to navigationJump to search
mLine 106:
Line 106: − + Line 118:
Line 118: − + − +
→freetds.conf: adjustments
====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.
This file contains the settings that tell freetds about each server it will connect to. Host should be a FQDN (Fully Qualified Domain Name).
Make directory to hold template fragments to be included in the original path: /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
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]
[remoteserver]
host = 192.168.0.112
host = xp3c
port = 1433
port = 1433
tds version = 8.0
tds version = 8.0
