Comments

• mohit198 Members

  April 2012

  Hi All,
  
  code:
  //Function for retrieve data from DB
  function getDataFromDB(){
  $Query = "select * from taskmaster";
  var $db1 = _getDB("com.microsoft.sqlserver.jdbc.SQLServerDriver","jdbc:sqlserver://172.16.221.180:8080;databaseName=Billing;user=mohit;password=test200","mohit","test200");
  $res = $db1.select($Query);
  var $length1 = $res.length;
  return $length1;
  }
  
  $len1 = getDataFromDB();
  _alert($len1);
  
  Error:
  
  exception: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host 172.16.221.180, port 8080 has failed. Error: "Connection refused: connect. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".
  at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError
  
  Please help.
  
  Mohit
• mohit198 Members

  April 2012

  Hi All,
  
  Now system is giving below issue.
  
  Code:
  var $db1 = _getDB("com.microsoft.sqlserver.jdbc.SQLServerDriver","jdbc:sqlserver://172.16.221.175\\mnettestsvr:1433;databaseName=Glb_TimeSheetBilling","mohit","test200$");
  
  Error:
  
  exception: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'mohit'. The user is not associated with a trusted SQL Server connection.
  
  Please let me know if there is any issue with code.
  
  Please help to resolve above issue.
  
  Thanks,
  Mohit
• mohit198 Members

  April 2012

  Hi All,
  
  Its working fine now. i have removed port from jdburl.
  
  
  code:
  //Function for retrieve data from DB
  function getDataFromDB(){
  $Query = "select * from taskmaster";
  var $db1 = _getDB("com.microsoft.sqlserver.jdbc.SQLServerDriver","jdbc:sqlserver://172.16.221.180;databaseName=Billing;user=mohit;password=test200","mohit","test200");
  $res = $db1.select($Query);
  var $length1 = $res.length;
  return $length1;
  }
  
  $len1 = getDataFromDB();
  _alert($len1);