Custom ODBC driver creation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

doguedebordeaux - 27 Feb 2005 11:39 GMT

Hello

Could someone provide me information (tutorial), how to build custom ODBC
driver? Actualy I need a solution, how to translate SQL queries sent by
particalar application (change field names, table names, etc.).

Thank you all

Reply to this Message

Igor Shekalev - 27 Feb 2005 16:35 GMT

Translate to what? Do you need SQL parser or something else?

d> Could someone provide me information (tutorial), how to build custom
d> ODBC driver? Actualy I need a solution, how to translate SQL queries
d> sent by particalar application (change field names, table names,

Igor Shekalev, http://www.sqledit.com, powerful database tools

Reply to this Message

doguedebordeaux - 27 Feb 2005 18:02 GMT

Actualy I need a middleware tool (or metadata tool) to accept odbc commands
from my application and send it to actual database server on the fly. I
thought to make a custom odbc driver, which acts like an ODBC datasource,
gets commands from applications, makes changes in SQL queries, and
retrieves data from another datasource, makes changes in field names, etc.
and sends data back to application.

Another question maybe someone has Microsoft ODBC SDK or knows where to
get it?

Thank you
dogue

Reply to this Message

Igor Shekalev - 03 Mar 2005 08:19 GMT

Why you can't access your database server from your application directly if
you can do it from middleware?

d> Actualy I need a middleware tool (or metadata tool) to accept odbc
d> commands from my application and send it to actual database server on
d> the fly. I thought to make a custom odbc driver, which acts like an
d> ODBC datasource, gets commands from applications, makes changes in
d> SQL queries, and retrieves data from another datasource, makes
d> changes in field names, etc.
d> and sends data back to application.

Igor Shekalev, http://www.sqledit.com, powerful database tools

Reply to this Message

openaccess - 28 Feb 2006 19:39 GMT

We have a product called OpenAccess SDK that can be used to create a custom
ODBC driver that can easily look at a SQL statement that is coming in and
reformat it for sending to your data source. The SDK includes the SQL engine
with an API to easily walk through a SQL statement and use this information
for transforming the query to a backend compatible query. You can learn more
about it at http://www.OpenAccessSoftware.com. OpenAcces SDK is designed to
allow a programmer to create a custom ODBC or JDBC driver in days.

Thanks.

>Hello
>
[quoted text clipped - 3 lines]
>
>Thank you all

Reply to this Message