SubmitSQL Method (RDA)

  • Article

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 (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.

Syntax

object.SubmitSQL (SQLString, OLEDBConnectionString)

Parameters

  • SQLString
    Any SQL statement that does not return rows.
  • OLEDBConnectionString
    OLE DB connection string for the remote SQL Server database.

Applies To

SQL Server Compact 3.5 RDA object

See Also

Reference

RDA Object Methods

Help and Information

Getting Assistance (SQL Server Compact 3.5 Service Pack 1)