Analytica Business Systems: Pervasive.SQL and Btrieve Specialists

Pervasive.SQL, Btrieve and More KnowledgeBase | Article #54 | How to Tell if Your App Uses Btrieve API or SQL
View an Article   Back
Title: How to Tell if Your App Uses Btrieve API or SQL 
Category: Pervasive.SQL PSQL (Any Version) 
Keywords: btrieve, api, sql, which 
Description: Question:
How do I tell whether my application is using the Btrieve API or the Relational (SQL) Engine?

Answer:
1. Start the Pervasive Monitor utility (either from the server or from a workstation, then use Options/Connect to get to the server).
2. Go to the Microkernel/Active Users screen. If all of the users are showing up as regular user names, then your application is purely Btrieve-based. If you see users listed like "SRDE:", then you will also have SQL/ODBC users accessing the data. You can tell for sure the exact location of each user by looking at the "Network Address" line in the Monitor -- this gives you the exact address of the computer related to that connection.  
Approved

If you like our free Pervasive Knowledge Base Service, please consider purchasing your next Pervasive Software Product from our online store or call or email us!

In the meantime, to help us keep this service free, would you mind clicking on one of the ads at the left? Thanks for visiting!