Oracle ODBC connectivity - What is ODBC SQLPASSTHROUGH option? posted by
Babu Kunwar
What is ODBC SQLPASSTHROUGH option?
We use SQLPASSTHROUGH options when we need applications to access data both in
the front-end and back-end data servers with a single connection. SQL
statements that cannot be executed in the solidDB front-end server are passed
over to the back end.
SQLPASSTHROUGH mode can be set as per session or per transaction. The
connection between the front end and back end is made with a back-end
compatible ODBC driver which is loaded dynamically in solidDB server.
More links
Define PL/SQL sequences and write syntax for a sequence
How do we set the LASTVALUE value in an Oracle Sequence?
What does cache and no cache options mean while creating a sequence?..........
|
