206
edits
Changes
From SME Server
Jump to navigationJump to search
mLine 1:
Line 1: + Line 92:
Line 93: − + − + − + − + + Line 159:
Line 161: − +
added medium skill level
{{Languages}}
{{Languages}}
{{Warning box| Under construction, some content may be totally wrong and misleading.}}
{{Warning box| Under construction, some content may be totally wrong and misleading.}}
{{Level|medium}}
===Description===
===Description===
Adding support in SME Server for a universal connection to foreign datebase servers using Open Database Connectivity (ODBC).
Adding support in SME Server for a universal connection to foreign datebase servers using Open Database Connectivity (ODBC).
===Configuration===
===Configuration===
Since theese configuration files reside in /etc they may be overwritten by other server modifications. Therefore we use a templating system to make sure key information survives. [http://wiki.contribs.org/SME_Server:Documentation:Developers_Manual:Section2#Configuration_file_templates More info here]
Since these configuration files reside in /etc they may be overwritten by other server modifications. Therefore we use a templating system to make sure key information survives. [http://wiki.contribs.org/SME_Server:Documentation:Developers_Manual:Section2#Configuration_file_templates More info here]
====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. Ip can (should) be replaced with FQDN. The original file contain examples.
Make directory to hold template fragment for the original file: /etc/freetds.conf
Make directory to hold template fragment to be included in the original file: /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:
Make and edit template fragment, "10xp3c" is my example and can be modified:
pico /etc/e-smith/templates-custom/etc/freetds.conf/10xp3c
pico /etc/e-smith/templates-custom/etc/freetds.conf/10xp3c
[http://se2.php.net/manual/en/book.uodbc.php php.net ODBC]
[http://se2.php.net/manual/en/book.uodbc.php php.net ODBC]
Input from and credit to Nick Critten [http://bends.se/it/smeserver/filer/HowTo_NickCritten_freetds.html unofficial copy of his HowTo] and [http://www.calio.it/docs/doku.php/sqlserver calio.it] [http://translate.google.se/translate?u=http%3A%2F%2Fwww.calio.it%2Fdocs%2Fdoku.php%2Fsqlserver&sl=it&tl=en&hl=sv&ie=UTF-8 translated]
Input from, and credit to, Nick Critten [http://bends.se/it/smeserver/filer/HowTo_NickCritten_freetds.html unofficial copy of his HowTo] and [http://www.calio.it/docs/doku.php/sqlserver calio.it] [http://translate.google.se/translate?u=http%3A%2F%2Fwww.calio.it%2Fdocs%2Fdoku.php%2Fsqlserver&sl=it&tl=en&hl=sv&ie=UTF-8 translated]
===Troubleshooting===
===Troubleshooting===
