Submits SQL statements for execution on a Microsoft SQL Server database.

Before calling the SubmitSQL method, the following properties must be set:

  • The InternetURL property must contain the URL of the SQL Server Compact 3.5 Server Agent.

  • The InternetLogin and InternetPassword properties must be specified if the SQL Server Compact 3.5 Server Agent is configured to use HTTP Basic Authentication.

    object.SubmitSQL (SQLString, OLEDBConnectionString)

Applies To

SQL Server Compact 3.5 RDA object

  • SQLString
    Any SQL statement that does not return rows.

  • OLEDBConnectionString
    OLE DB connection string for the remote SQL Server database.

Reference

RDA Object Methods