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