DSN Manager - DeleteODBCDSN

Version: 7C

HC7 Build: 7.00.0012 and later

API Build: 1.00.0001 and later

DSN Manager - DeleteODBCDSN retrieves ODBC DSN under a  specified owner. This web service call can be made as http://your-domain.com/HC7API/DSNManager.asmx?op=DeleteODBCDSN.

Input Parameters

• HostUserName

• HostPassword

• OwnerName

• DSNName

• WebsiteName

• OptionalParam

• Language
   

Output Parameters

         N/A

Sample Optional Parameters

<Parameters>

<Parameter Name = "Language">French</Parameter>

</Parameters>

Sample SOAP Request

POST /HC7API/DSNManager.asmx HTTP/1.1

Host: your-domain.com

Content-Type: text/xml; charset=utf-8

Content-Length: length

SOAPAction: "http://tempuri.org/DeleteODBCDSN"

<?xml version="1.0" encoding="utf-8"?>

<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">

  <soap:Body>

    <DeleteODBCDSN xmlns="http://tempuri.org/">

      <HostUserName>host</HostUserName>

      <HostPassword>host123</HostPassword>

      <OwnerName>david</OwnerName>

      <DSNName>MyDSN</DSNName>

      <WebsiteName>MyDomain.com</WebsiteName>

      <OptionalParam>xml</OptionalParam>

    </DeleteODBCDSN>

  </soap:Body>

</soap:Envelope>

Sample HTTP Request

POST /HC7API/DSNManager.asmx/DeleteODBCDSN HTTP/1.1

Host: your-domain.com

Content-Type: application/x-www-form-urlencoded

Content-Length: length

HostUserName=host&HostPassword=host123&OwnerName=david&DSNName=MyDSN&WebsiteName=

MyDomain.com&OptionalParam=xml

Sample C# Code

public DSNManager.Response DeleteODBCDSN(string strHostUserName, string strHostPassword, string strOwnerName, string strDSNName, string strWebsiteName)

{

         try

         {

                    DSNManager.DSNManager oDSN = new DSNManager.DSNManager();

                    DSNManager.Response oResponse = new DSNManager.Response();

                    oResponse = oDSN.DeleteODBCDSN(strHostUserName, strHostPassword, strOwnerName,   

                    strDSNName, strWebsiteName, null);

         }

         catch

         {

         }

         return oResponse;

}

Sample Response

<Response>

    <Method>DeleteODBCDSN</Method>

    <Status>true</Status>

    <ErrorCode>70600021</ErrorCode>

    <ErrorDescription>ODBC DSN deleted successfully.</ErrorDescription>           

    <Result/>

</Response>