206
edits
Changes
From SME Server
Jump to navigationJump to search
mLine 89:
Line 89: − + Line 190:
Line 190: − + Line 239:
Line 239: − + − + − + + + + +
Corrections
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'> (apostrophe before and after).
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'>.
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 fussy about correct configuration settings than tsql, therefore we include also this test.
Generally speaking, isql is a bit more fussy 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'> (apostrophe before and after):
At the command line enter <isql -v DSN USERNAME PASSWORD>. If on a NT domain, replace <dbuser> with <'DOMAINNAME\dbuser'>:
isql -v remoteserver dbuser dbpass
isql -v remoteserver dbuser dbpass
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'> (apostrophe before and after).
If on a NT domain, replace <dbuser> with <'DOMAINNAME\dbuser'> (with a single quotation mark before and after).
<br> Tests suggest that <DOMAINNAME\\dbuser> also work.
<br>Escaping the backslash with another backslash <DOMAINNAME\\dbuser> would 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.
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.
In the source directory freetds-0.82/src/apps is the shell script "osql" that attempts to automatically verify the ODBC setup. It checks odbc.ini, odbcinst, and, optionally, freetds.conf, then execute isql (assume it's unixODBC's isql). Syntax: osql -S server -U user -P password.
cd freetds-0.82/src/apps
./osql -S xp3c -U dbuser -P dbpass
====Ms SQL Server====
====Ms SQL Server====
