Goldstar Logo
Your Source for PSQL Database Products, Services and Training Since 1997 EMail: Sales@goldstarsoftware.com 
Phone: 1-708-647-7665 
Web Site Login 
Free PSQL Support
Quick Links
PSQL Database Engines
+ Actian PSQL v13
+ Actian PSQL v12
+ Actian PSQL v11
+ Pervasive PSQL v10
+ Pervasive PSQL v9
+ Pervasive.SQL V8
+ Pervasive.SQL 2000i
+ Pervasive.SQL 7
+ Btrieve v12
+ Btrieve 6.15

+ Data Protection Products

+ Goldstar Software Services

+ Goldstar Software Tools

+ Other Solutions

AMS Users: Click Me Fix My PSQL License Repair PSQL Files Get Support Now Join Our Mailing List

Navigation Background

Advanced Network Troubleshooting for Pervasive.SQL

Register Now!

Course Developer: Goldstar Software Inc. -- Bill Bach

Level: Advanced

Length: 1 Day

Course Materials: 80+ page, Two-Sided, Color Printed Manual with CDROM (Available Separately for $250)

Course Objectives: This one-day course provides a background into network design and troubleshooting concepts. It includes an introduction to network packet capture and analysis with hands-on use of the Novell LANalyzer tool or other tools. (More tools may be compared if vendors can provide them.) Several trace files depicting common Btrieve and networking problems will be evaluated in a lab environment, with special attention to the Btrieve and Pervasive.SQL communications process. It will include a review of the entire communications process for TCP and SPX, and will provide packet analysis details of Btrieve 6.x, Btrieve 7.x, and other clients, along with a review of real-life case studies.

An outline of the course includes:

Section 1 - Introduction & Review
Objectives
Concepts (Hexadecimal, Btrieve, OSI Model)
The Physical World (Cabling)
Ethernet In Depth
Network Design Rules
Common Networking Mistakes
Section 2 - Application-Level Troubleshooting Section 3 - Network Troubleshooting
Network Cable Testing
Overview of Network Analyzers
Network Analysis Tools
Novell LANalyzer
Microsoft Network Monitor
Other Tools
Translating Traces Across Multiple Analyzers
Section 4 - Capturing Network Traces
Capturing Network Traces Effectively
Common Mistakes
Section 5 - Understanding Higher Level Protocols
Understanding SPX Communications
Understanding TCP Communications
Understanding Application-Layer Communications
Section 6 - Pervasive Packet Formats
Btrieve 6.x Packet Formats
Btrieve 7.x Packet Formats
Other Formats
Section 7 - Reading Network Traces
Examining SPX Communications
Examining TCP Communications

Section 8 - Case Studies & Examples


Course Prerequisites:
Student should have a basic understanding of database access methods, including Btrieve (Transactional) and Relational access. Completing the Pervasive PSQL Service & Support class is ideal in this regard. A strong understanding of networking and about installing and maintaining applications in Windows 9x and/or Windows NT is required.

We will be introducing one or more network analyzers to view and interpret network access, so a background and understanding of how a network analyzer works is a plus, but is not required.

Note: All students will be receiving some background reading information prior to the first day of the class. This information is technically part of the class and important to understand, but due to time constraints, it cannot be covered during the class time. Some time will be available in the morning part of the class to review and answer questions from this material.

Out Of Town Students: Please be aware that this class is a highly technical class requiring a lot of background information. In order to cover the required information and still have time to review examples and perform lab work, please plan on staying through AT LEAST 5PM for this class. Students who are required to leave early for travel reasons may not realize the full benefits of this session!

  Copyright © 1997-2017, Goldstar Software Inc., All rights reserved. PRODUCTS | SERVICES | TRAINING | SUPPORT | DOWNLOADS | ABOUT US  
Goldstar Software Inc. | 3007 Carmel Dr | Flossmoor IL 60422 Legal Statements | EULAs | Uninstall | Privacy Statements | Contact Us