206
edits
Changes
From SME Server
Jump to navigationJump to search
mLine 1:
Line 1: − {{Warning box| Under construction, some content may be totally wrong and misleading.}} Line 90:
Line 89: − + Line 191:
Line 190: − + Line 236:
Line 235: + + − + + + − + Line 248:
Line 251: − +
Corrected typos and removed 'Under construction'-sign
{{Languages}}
{{Languages}}
{{Level|medium}}
{{Level|medium}}
===Description===
===Description===
unixodbc: yes
unixodbc: yes
Test connection to the foreign database, overriding settings in freetds.conf (modify to suit your conditions). IP and not FQDN should be used. If on a NT domain, replace <dbuser> with <'DOMAINNAME\dbuser'> (single quote before and after) instead.
Test connection to the foreign database, overriding settings in freetds.conf (modify to suit your conditions). IP and not FQDN should be used. If on a NT domain, replace <dbuser> with <'DOMAINNAME\dbuser'> (apostrophe before and after).
tsql -H 192.168.0.112 -p 1433 -U dbuser -P dbpass
tsql -H 192.168.0.112 -p 1433 -U dbuser -P dbpass
Generally speaking, isql is a bit more fuzzy about correct configuration settings than tsql, therefore we include also this test.
Generally speaking, isql is a bit more fuzzy about correct configuration settings than tsql, therefore we include also this test.
At the command line enter <isql -v DSN USERNAME PASSWORD>. If on a NT domain, replace <dbuser> with <'DOMAINNAME\dbuser'> (single quote before and after) instead:
At the command line enter <isql -v DSN USERNAME PASSWORD>. If on a NT domain, replace <dbuser> with <'DOMAINNAME\dbuser'> (apostrophe before and after):
isql -v remoteserver dbuser dbpass
isql -v remoteserver dbuser dbpass
===Troubleshooting===
===Troubleshooting===
There are some ifs and buts involved in theese config files, please consult the docs at FreeTDS and UnixODBC if you are running into trouble. Feel free to contribute to this HowTo with your experiences.
Tab spaces in config files may cause troubles, use single space before and after the <=>.
Tab spaces in config files may cause troubles, use single space before and after the <=>.
If on a NT domain, replace <dbuser> with <'DOMAINNAME\dbuser'> (single quote before and after).
If on a NT domain, replace <dbuser> with <'DOMAINNAME\dbuser'> (apostrophe before and after).
<br> Tests suggest that <DOMAINNAME\\dbuser> also work.
<br> Tests suggest that <DOMAINNAME\\dbuser> also work.
The host name xp3c used in the examples above works in a workgroup environment, it could(should?) be a full FQDN like xp3c.mydomain.com in a NT domain environment.
====Ms SQL Server====
====Ms SQL Server====
If you are using instances, replace "port = 1433" with "instance = db_kalle" in your freetds.conf template fragment (replace db_kalle with the name of your instance).
If your SQL Server are using instances, replace "port = 1433" with "instance = MyInstance" in your freetds.conf template fragment (replace MyInstance with the name of your instance).
From SQL Server 2000 TDS version 8.0 should be used. Add the line "tds version = 8.0" in your template fragment for freetds.conf
From SQL Server 2000 TDS version 8.0 should be used. Add the line "tds version = 8.0" in your template fragment for freetds.conf
Ms SQL Server might not allow the db system user "sa" to connect from outside the server, create another account with proper permissions.
Ms SQL Server might not allow the db system user "sa" to connect from outside the server, create another account with proper permissions.
Express edition have remote access disabled by default. Can be changed in the menu "Surface Area Configuration". [http://support.microsoft.com/kb/914277 More info]
Express edition have remote access disabled by default. Can be changed in the menu "Surface Area Configuration". [http://support.microsoft.com/kb/914277 More info here]
----
----
[[Category:Howto]]
[[Category:Howto]]
