If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Pervasive.SQL > Viewing who's logged on Pervasive through Monitor

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 06-12-08, 09:45
Keereweer Keereweer is offline
Registered User
 
Join Date: Mar 2008
Posts: 14
Viewing who's logged on Pervasive through Monitor

With the tool 'Monitor' you can see who's logged on in Pervasive. We have a lot problems with betrieve status 84.
We checked on users using the wrong engine, now we're hunting somebody using programmes which calles Pervasive through the net.
How can we use Monitor looking for 'Record lock type' or searching for somebody creating this huge problem?

Thanx in advance.
Reply With Quote
  #2 (permalink)  
Old 06-12-08, 11:07
mirtheil mirtheil is online now
Registered User
 
Join Date: Dec 2001
Posts: 1,015
You can use the Monitor to see the information you're looking for but it'll be difficult. You'll need to search each active user and active file to see which users have locks. You could also write your own tool using the DTI or DTO interfaces to query the Pervasive engine for active users/files information. If you'd rather not build, you might check out Goldstar Software's FindLock tool (http://www.goldstarsoftware.com/tools.asp). It'll help you find which users have locks.
__________________
Mirtheil Software
Certified Pervasive Developer
Certified Pervasive Technician
Custom Btrieve/VB development
http://www.mirtheil.com
I do not answer questions by email. Please post on the forum.

Last edited by mirtheil; 06-12-08 at 11:54.
Reply With Quote
  #3 (permalink)  
Old 06-12-08, 11:40
Keereweer Keereweer is offline
Registered User
 
Join Date: Mar 2008
Posts: 14
thanx for quick reply.
Unfortunately, your link to the findlock tool (just curious to see) isn't correct.
Anyway, i'd rather build the tool myself, good for self learning.
What means or where can i find these DTI and DTO?
Query Pervasive engine is something hiy can connect with through crystal or vb.net?

Thanx again.
Reply With Quote
  #4 (permalink)  
Old 06-12-08, 11:57
mirtheil mirtheil is online now
Registered User
 
Join Date: Dec 2001
Posts: 1,015
I fixed the link. You should try it now.

DTI and DTO are documented at the Pervasive site (http://www.pervasive.com/developerzo...ods/dtidto.asp. There are samples and docs.

The Pervasive engine can be accessed through Crystal or VB.NET (or any number of different tools/languages).
__________________
Mirtheil Software
Certified Pervasive Developer
Certified Pervasive Technician
Custom Btrieve/VB development
http://www.mirtheil.com
I do not answer questions by email. Please post on the forum.
Reply With Quote
  #5 (permalink)  
Old 07-16-08, 06:16
Keereweer Keereweer is offline
Registered User
 
Join Date: Mar 2008
Posts: 14
I downloaded a trial version of PCConfig distributed bij Goldstar software. While having a status 84 lock, we executed the pgm. There is output, but no information about record locks.
We tried /MUL, /MUFE.
Something else is wrong. Maybe you have any ideas?
Reply With Quote
  #6 (permalink)  
Old 07-16-08, 09:55
mirtheil mirtheil is online now
Registered User
 
Join Date: Dec 2001
Posts: 1,015
What was reported? I haven't tried the PSConfig tool so I'm not sure how it works.
__________________
Mirtheil Software
Certified Pervasive Developer
Certified Pervasive Technician
Custom Btrieve/VB development
http://www.mirtheil.com
I do not answer questions by email. Please post on the forum.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On