SQLPrepare

From: Dennis Evans <denniseevans(at)att(dot)net>
To: "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject: SQLPrepare
Date: 2010-08-10 19:16:34
Message-ID: 699063.7017.qm@web180401.mail.gq1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

When using the PostGreSQL ODBC driver is calling SQLPrepare needed? Or will the server compile, cache and reuse the execution

plan when SQLExecDIrect is used?

When using with MS-SQL the call does no harm but is really not needed SQL Server will compile and cache the plan without calling SQLPrepare.

Dennis

Browse pgsql-odbc by date

  From Date Subject
Next Message Victor Hugo 2010-08-13 12:25:19 PGexpress v4.11 + postgresql 8.4.4
Previous Message Michal Seliga 2010-08-10 07:25:54 i cannot use odbc with postgresql in linux