1 / 19

ODBC

ODBC. Or How can I really see my data…?. ODBC defined:. Open DataBase Connectivity ODBC applications can access data in many of today's leading database management systems (DBMSs) by using ODBC drivers written to access those DBMSs. Pervasive provides the Driver for ODBC.

garron
Download Presentation

ODBC

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. ODBC Or How can I really see my data…?

  2. ODBC defined: • Open • DataBase • Connectivity • ODBC applications can access data in many of today's leading database management systems (DBMSs) by using ODBC drivers written to access those DBMSs.

  3. Pervasive provides the Driver for ODBC • There are TWO drivers • 1 at the “server” • 1 at the “workstation”

  4. DBA / EVO and PERVASIVE • DBA / EVO is a “Transactional Database”. • Pervasive provides the Engine for the Database to interact with the O/S. • Pervasive has Two Engines: Relational & Transactional • The Relational is for SQL type databases. • The Transactional is for Btrieve or “flat file” databases

  5. We use the ODBC to connect thru the Relational engine of Pervasive to Access the Transactional database of DBA / EVO. • The connection uses your Local Area Network on the established “protocol”: • TCP/IP • IPX/SPX • NETBIOS

  6. Client to Server Connection

  7. Server Side connection:

  8. The ODBC connects to the DDF’s • DDF’s : Data Dictionary Files. • Maintain the definitions of the Files(tables) used in the Database. • As well as Each Field name, it’s Attribute, and indexes for Each File(table).

  9. Use the Correct set of DDF’s !!

  10. DBA/EVO & DDF’S

  11. Creating specific Company DDF‘s

  12. …. And in EVO..

  13. Results in Correct DDF’s in your Company Data Directory….

  14. FILE

  15. FIELD

  16. INDEX

  17. Data thru ODBC

  18. Data thru Crystal Reports

  19. TA DA ! • You have QUESTIONS? • We provide Answers… Digital Consulting • www.digitalconsulting.biz • 760-832-2536 • davemeng@earthlink.net

More Related