SubmitSQL Method (RDA)
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 2005 Compact Edition (SQL Server Compact Edition) Server Agent.
- The InternetLogin and InternetPassword properties must be specified if the SQL Server Compact Edition 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. For more information, see SQL Server Compact Edition Remote Data Access Programming.
Applies To
SQL Server Compact Edition RDA object