Changes

From SME Server
Jump to navigationJump to search
21 bytes added ,  19:07, 18 June 2009
m
Line 77: Line 77:     
  tsql -C
 
  tsql -C
Should output someting similar to this:
+
Should output something similar to this:
 
  Compile-time settings (established with the "configure" script):
 
  Compile-time settings (established with the "configure" script):
 
  Version: freetds v0.64
 
  Version: freetds v0.64
Line 90: Line 90:  
Test connection to a foreign database, overriding settings in freetds.conf (modify to suit your conditions, ip could be replaced with FQDN):
 
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 -H 192.168.0.112 -p 1433 -U dbuser -P dbpass
    
A response something like this would indicate that connection was successful but login failed (wich is normal at this stage):
 
A response something like this would indicate that connection was successful but login failed (wich is normal at this stage):
Line 97: Line 97:  
  locale charset is "ISO-8859-1"
 
  locale charset is "ISO-8859-1"
 
  Msg 18456, Level 14, State 1, Server XP3B\SQLEXPRESS, Line 1
 
  Msg 18456, Level 14, State 1, Server XP3B\SQLEXPRESS, Line 1
  Login failed for user 'testuser'.
+
  Login failed for user 'dbuser'.
  Msg 20014, Level 9, State 0, Server OpenClient, Line 0
+
  Msg 2002, Level 9, State -1, Server OpenClient, Line -1
  Login incorrect.
+
  Adaptive Server connection failed
 
  There was a problem connecting to the server
 
  There was a problem connecting to the server
  
206

edits

Navigation menu