What does ODBC mean

grybeard3 · Post by **grybeard3** » Fri Aug 25, 2006 6:54 pm

I read in several posts that some have used ODBC to access MyEncore date from EncorePro. Sure would like to know what ODBC means and how do you utilize it???

Wulfman · Post by **Wulfman** » Fri Aug 25, 2006 7:01 pm

ODBC

(pronounced as separate letters) Short for Open DataBase Connectivity, a standard database access method developed by the SQL Access group in 1992. The goal of ODBC is to make it possible to access any data from any application, regardless of which database management system (DBMS) is handling the data. ODBC manages this by inserting a middle layer, called a database driver , between an application and the DBMS. The purpose of this layer is to translate the application's data queries into commands that the DBMS understands. For this to work, both the application and the DBMS must be ODBC-compliant -- that is, the application must be capable of issuing ODBC commands and the DBMS must be capable of responding to them. Since version 2.0, the standard supports SAG SQL.

grybeard3 · Post by **grybeard3** » Fri Aug 25, 2006 7:05 pm

OK, think I understand, but, what is SAG in regards to SQL? Any ideas on what I need to do to make the darn thing work. I don't have an Excel file set up as I don't need or use Excel, so what else can I do?
do you know how I get into setup for MyEncore???

Wulfman · Post by **Wulfman** » Fri Aug 25, 2006 7:17 pm

Check your other thread I just posted to.

It has this link in it.

viewtopic.php?t=4612

Den

Wulfman · Post by **Wulfman** » Fri Aug 25, 2006 7:45 pm

grybeard3 wrote:OK, think I understand, but, what is SAG in regards to SQL?

I believe that was a reference to the ...(in that description)......"SQL Access Group".

Den