Changes

  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" 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'> (single quote before and after) instead.

  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" instead:

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:

  isql -v remoteserver dbuser dbpass

  isql -v remoteserver dbuser dbpass

===Troubleshooting===

===Troubleshooting===

Tab spaces in config files may cause troubles, use single space before and after =.

Tab spaces in config files may cause troubles, use single space before and after the <=>.

 

<br> Tests suggest that <DOMAINNAME\\dbuser> also work.

====Ms SQL Server====

====Ms SQL Server====