Changes

From SME Server
Jump to navigationJump to search
428 bytes added ,  17:15, 18 June 2009
m
→‎Test with tsql: added tsql response
Line 88: Line 88:  
  unixodbc: yes
 
  unixodbc: yes
   −
Test connection to a foreign database, overriding settings in freetds.conf (modify to suit your conditions):
+
Test connection to a foreign database, overriding settings in freetds.conf (modify to suit your conditions, ip could be replaced with FQDN):
    
  tsql -S 192.168.0.112 -U username -P password
 
  tsql -S 192.168.0.112 -U username -P password
 +
 +
A response something like this would indicate that connection was successful but login failed (wich is normal at this stage):
 +
 +
locale is "sv_SE"
 +
locale charset is "ISO-8859-1"
 +
Msg 18456, Level 14, State 1, Server XP3B\SQLEXPRESS, Line 1
 +
Login failed for user 'testuser'.
 +
Msg 20014, Level 9, State 0, Server OpenClient, Line 0
 +
Login incorrect.
 +
There was a problem connecting to the server
    
===Configuration===
 
===Configuration===
206

edits

Navigation menu