ADO Method Support in the OLE DB Provider for Internet Publishing
The following table summarizes the ADO version 2.5 object methods that are supported by the current version of the Microsoft® OLE DB Provider for Internet Publishing.
| ADO object | Method | Support |
|---|---|---|
| Command | CreateParameter | No |
| Cancel | No | |
| Execute | Yes, but options must be adCmdText | |
| Connection | BeginTrans | No |
| Cancel | No | |
| Close | Yes | |
| CommitTrans | No | |
| Execute | Yes, but options must be adCmdText | |
| Open | Yes | |
| OpenSchema | Yes | |
| RollbackTrans | No | |
| Field | AppendChunk | Yes |
| GetChunk | Yes | |
| ReadFromFile | No | |
| WriteToFile | No | |
| Parameter | AppendChunk | No |
| Record | Cancel | No |
| Close | Yes | |
| CopyRecord | Yes | |
| DeleteRecord | Yes | |
| GetChildren | No | |
| MoveRecord | Yes | |
| Open | Yes | |
| Recordset | AddNew | Yes |
| Cancel | No | |
| CancelBatch | Yes | |
| CancelUpdate | Yes | |
| Clone | Yes | |
| Close | Yes | |
| Delete | Yes | |
| Find | Yes | |
| GetRows | Yes | |
| Move | Yes | |
| MoveFirst | Yes | |
| MoveLast | Yes | |
| MoveNext | Yes | |
| MovePrevious | Yes | |
| NextRecordset | No | |
| Open | Yes | |
| Requery | Yes | |
| Resync | No | |
| Save | Yes | |
| Seek | Yes | |
| Supports | Yes | |
| Update | Yes | |
| UpdateBatch | Yes | |
| Stream | Cancel | No |
| Close | Yes | |
| CopyTo | Yes | |
| Flush | No | |
| LoadFromFile | Yes | |
| Open | Yes | |
| Read | Yes | |
| ReadText | No | |
| SaveToFile | Yes | |
| SetEOS | Yes | |
| SkipLine | No | |
| Write | Yes | |
| WriteText | Yes |
Using the Open method with the Connection object.
To use the Root Binder use the "URL=" keyword in the ConnectionString parameter.
For example: connection.Open "URL=https://server"
To use the Data Source object set connection.Provider to MSDAIPP.DSO
For example: connection.Open "provider=MSDAIPP.DSO;data source=https://server"
or
connection.Provider = "MSDAIPP.DSO"
connection.Open = "https://server"
If you use the Data Source object do not use the "URL=" keyword
Using the Open method with Record objects.
The Record object implicitly uses the Root Binder. Use the "URL=" keyword in the ActiveConnection parameter.
For example: record.Open "https://server/vroot/folder/file.txt", "URL=https://server/vroot/folder"
Do not use "URL=" in the Source parameter.
Using the Open method with Recordset objects.
To use the Root Binder use the "URL=" keyword in the ActiveConnection parameter.
For example recordset.Open "folder", "URL=https://server/vroot/", , , adCmdTableDirect
Do not use "URL=" in the Source parameter.
To use the Data Source object set the Provider to MSDAIPP.DSO in the ActiveConnection parameter.
For example: *recordset.*Open "folder", "Provider=MSDAIPP.DSO; Data Source=https://server/vroot/", , , adCmdTableDirect
Note adCmdTableDirect is required to indicate that the Source parameter is a URL. Without it the Source parameter will be interpreted as a command.
URL Context
The absolute URL passed to the Connection object, or the ActiveConnection parameter of the Record or Recordset, defines the context for subsequent operations. This restricts operations to the data source represented by the connection. Relative URLs can be used in the source or destination parameters of Record or Recordset methods.
For example: Recordset.Open "system32/Readme25.txt", "URL=https://server/winnt/", , , adCmdTableDirect
Note that adCmdTableDirect indicates the Source parameter is a URL.
Note In ADO 2.5 adCmdURLBind, adOpenURLBind, and adOpenStreamFromURL are eliminated from the Connection, Command, Stream, and Record objects. They are replaced by the "URL=" keyword. AdCmdURLBind has been replaced with AdCmdTableDirect for Recordset.Open.