Persisting Commands/SQL Statements

  • Article

Until OLE DB 2.0, there was no method-based mechanism for persisting and using persisted commands generically. Previously, the only way to create persisted commands, such as views or procedures, against OLE DB sources was to use SQL-based commands such as CREATE VIEW or CREATE PROCEDURE. Jet 3.5 did not natively support this syntax, essentially precluding clients from persisting commands against the version 3.5 provider. In Jet 4.0, clients can use either the SQL-based CREATE VIEW/CREATE PROCEDURE commands or the new ICommandPersist interface to save commands. Only the version 4.0 provider exposes this interface.