Searching for "SQLPASSTHROUGH"

Q:

What is ODBC SQLPASSTHROUGH option?

Answer

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.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle