title: ODBC Config File for Datastage Connection to SQLServer 2008
body: <p>I have an odbc config file on a sun solaris server, used for IBM datastage.<br>
  We need to connect to a sqlserver express edition.<br>
  Ip used to connect is xxx.xxx.xxx.xxx\TARGET<br>
  port is 1433,<br>
  database is dbname.  </p>
  
  <p>Sample of config file is:  </p>
  
  <pre><code>[T_TEST]
  Driver=/opt/IBM/InformationServer/Server/branded _odbc/lib/VMmsss23.so
  Description=DataDirect SQL Server Wire Protocol driver
  Database=dbname
  LogonID=user
  Password=*****
  Address=xxx.xxx.xxx.xxx\TARGET,1433
  Instance=SQLEXPRESS
  QuotedId=No
  AnsiNPW=No 
  </code></pre>
  
  <p>If I try to connect to sqlserver from datastage, I can't!</p>
  
  <p>If I try to connect to sqlserver from Management Studio, using like server name field value "xxx.xxx.xxx.xxx\TARGET", I can.</p>
  
  <p>Is the config file correct about your opinion or is there some setting to do on sqlserver?</p>
  
  <p>Sqlserver machine has port 1433 open for connection from datastage server.</p>
  
  <p>All other connections to sqlserver machine go.</p>
  
  <p>Thanks a lot in advance. </p>