ODBC - PowerPoint PPT Presentation

1 / 19
About This Presentation
Title:

ODBC

Description:

Results in Correct DDF s in your Company Data Directory . FILE FIELD INDEX Data thru ODBC Data thru Crystal Reports TA DA ! You have QUESTIONS? – PowerPoint PPT presentation

Number of Views:116
Avg rating:3.0/5.0
Slides: 20
Provided by: DaveM193
Category:
Tags: odbc | crystal | reports

less

Transcript and Presenter's Notes

Title: ODBC


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 DDFs
  • DDFs Data Dictionary Files.
  • Maintain the definitions of the Files(tables)
    used in the Database.
  • As well as Each Field name, its Attribute, and
    indexes for Each File(table).

9
Use the Correct set of DDFs !!
10
DBA/EVO DDFS
11
Creating specific Company DDFs
12
. And in EVO..
13
Results in Correct DDFs 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_at_earthlink.net
Write a Comment
User Comments (0)
About PowerShow.com