What does Prepare Method do?

This option is specific to the TDS-based Driver for Microsoft SQL Server & Sybase ASE/ASA. It is used to determine whether stored procedures are created on the server for SQLPrepare() calls.

It can take the values None, Partial, or Full (Options = -O [0, 1, 2], respectively).

When set to Full (-O 2), stored procedures are created for every call to SQLPrepare(). This can result in decreased performance when processing statements that do not contain parameters.

When set to Partial (-O 1) (the default), the driver creates stored procedures if the statement contains parameters. Otherwise, the statement is cached by the driver and run directly at the time of SQLExecute().

When set to None (-O 0), stored procedures are never created. The driver caches the statement, executes it directly at the time of SQLExecute(), and reports any syntax or similar errors at the time of SQLExecute().