What is ODBC compliant application ?

Posted on 2003-03-01
Medium Priority
Last Modified: 2012-05-04
What is an ODBC compliant application ?
Question by:JustStarted
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Accepted Solution

heskyttberg earned 80 total points
ID: 8050497

I'm not sure what you mean, but...

It's an application that conforms to and follows the ODBC specifications.

No extra functions that only your ODBC app can use.
Just something that can be used with any DB supporting ODBC.

For example if you app does a simple select from a DB.
This app should only need an ODBC connection.

If this connection is to Oracle, MS SQL and so on is irrelevant.

But this is seldom true since you use DB specific queries.

So I would take it as you are coding youe own ODBC driver for you own DB, then if that driver follows ODBC standard it's ODBC compliant app.

This is how I see on the matter.

/Hans - Erik Skyttberg

Expert Comment

ID: 8054034
That's true but the point of using an ODBC compliant DB (Open Database Connectivity) is that it acts like a supplementary layer between your database and your program.

So if you need to manage different kinds of databases OR you want to use a database that you don t really know, you can use ODBC to handle your requests. It acts kinda like a middleware which allows a programmer to abstract a program from a database.
LVL 17

Expert Comment

ID: 10322844
No comment has been added lately, so it's time to clean up this TA.
I will leave the following recommendation for this question in the Cleanup topic area:

Accept: heskyttberg {http:#8050497}

Please leave any comments here within the next four days.

EE Cleanup Volunteer

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A company’s centralized system that manages user data, security, and distributed resources is often a focus of criminal attention. Active Directory (AD) is no exception. In truth, it’s even more likely to be targeted due to the number of companies …
In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question