Changes

From SME Server
Jump to navigationJump to search
335 bytes added ,  07:36, 23 June 2009
m
Corrections
Line 89: Line 89:  
  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
Line 190: Line 190:  
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
Line 239: Line 239:  
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====
206

edits

Navigation menu