TikAero TikSqlDbWeb service


Click here for a complete list of operations.

ExecuteADOCmd

Function ExecuteADOCmd(ByVal strTableName As String, ByVal strCommand As Byte(), ByVal vRowsAffected As Long, ByVal dprvProvider As Long, ByVal bReturnsRecords As Boolean, ByVal bCompression As Boolean) As Byte()

Test

The test form is only available for requests from the local machine.

SOAP 1.1

The following is a sample SOAP 1.1 request and response. The placeholders shown need to be replaced with actual values.

POST /TikSqlDbWeb.asmx HTTP/1.1
Host: asr.yetiairlines.com
Content-Type: text/xml; charset=utf-8
Content-Length: length
SOAPAction: "http://www.tiksystems.com/TikSqlDBWebServices/ExecuteADOCmd"

<?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>
    <ExecuteADOCmd xmlns="http://www.tiksystems.com/TikSqlDBWebServices">
      <strTableName>string</strTableName>
      <strCommand>base64Binary</strCommand>
      <vRowsAffected>long</vRowsAffected>
      <dprvProvider>long</dprvProvider>
      <bReturnsRecords>boolean</bReturnsRecords>
      <bCompression>boolean</bCompression>
    </ExecuteADOCmd>
  </soap:Body>
</soap:Envelope>
HTTP/1.1 200 OK
Content-Type: text/xml; charset=utf-8
Content-Length: length

<?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>
    <ExecuteADOCmdResponse xmlns="http://www.tiksystems.com/TikSqlDBWebServices">
      <ExecuteADOCmdResult>base64Binary</ExecuteADOCmdResult>
    </ExecuteADOCmdResponse>
  </soap:Body>
</soap:Envelope>

SOAP 1.2

The following is a sample SOAP 1.2 request and response. The placeholders shown need to be replaced with actual values.

POST /TikSqlDbWeb.asmx HTTP/1.1
Host: asr.yetiairlines.com
Content-Type: application/soap+xml; charset=utf-8
Content-Length: length

<?xml version="1.0" encoding="utf-8"?>
<soap12:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://www.w3.org/2003/05/soap-envelope">
  <soap12:Body>
    <ExecuteADOCmd xmlns="http://www.tiksystems.com/TikSqlDBWebServices">
      <strTableName>string</strTableName>
      <strCommand>base64Binary</strCommand>
      <vRowsAffected>long</vRowsAffected>
      <dprvProvider>long</dprvProvider>
      <bReturnsRecords>boolean</bReturnsRecords>
      <bCompression>boolean</bCompression>
    </ExecuteADOCmd>
  </soap12:Body>
</soap12:Envelope>
HTTP/1.1 200 OK
Content-Type: application/soap+xml; charset=utf-8
Content-Length: length

<?xml version="1.0" encoding="utf-8"?>
<soap12:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://www.w3.org/2003/05/soap-envelope">
  <soap12:Body>
    <ExecuteADOCmdResponse xmlns="http://www.tiksystems.com/TikSqlDBWebServices">
      <ExecuteADOCmdResult>base64Binary</ExecuteADOCmdResult>
    </ExecuteADOCmdResponse>
  </soap12:Body>
</soap12:Envelope>