Installing Client side Pervasive 2000
run install from server /win
Install Scout seems to hang on the diagnostic tests. Failed the comm test. Tested ping to server ok.
THERE qre 2 dhcp servers, disable the xo comm dhcpr
no dhcp - add router (gateway) to scope
changed liste4n address on server from 0000 to 192.168.1.50
failed to contact server on first client install, reinstall
ODBC only seems to be setup for demo data
no sql icon is on server or workstation.
rfms versions --> btrieve ver 7.94N, RFMS ver 8.4
is this a transactional or relational database?
only the demodata has *mkd files
RFMS - Resource and Financial Management System
Btrieve - relational database
Server Engine - Btrieve or ODBC requests
An engine icon should be in the startup folder: c:\pvsw\bin\W#dbsmgr.exe -BTRV but it is not in the server or client pvsw dir
Pervasive manual: Pervasive sql 2000i combines a transactional interface designed for high performance data handling and improved programming productivity with embeddable and scalable relational interface.
on the server, both the pervasive transactional and relational database servers are started. Pervasive System Analyzer passed all the transactional tests: the relational tests on DEMODATA all failed
Failed to connect to the database. The server name or the server DSN specified may not exist.
Make sure that the Pervasive SQL 2000i Server Engine on the machine specified is started and the usercount is valid. (The server user count administrator says there are 10 licenses.)
[Pervasive][ODBC Client Interrface][Client LNA][SHM]Connecton to the server could not be established. Please check if server is running.
testing at the server of the ODBC data sources failed with the above error.
The Client has no services: Pervasive.SQL 2000 (relational) or Pervasice.SQL 2000 (transactional)
The server system log was cleared yesterday but has a number of errors overnight.
Type Date Time Source Category Event User Computer
This event happens when you move the Dynamic Host Configuration Protocol (DHCP) database and its backup directories from the default location. When the DHCP server is initially installed, its database is stored in %SystemRoot%\SYSTEM32\DHCP and the backup directory is set to %SystemRoot%\SYSTEM32\DHCP\BACKUP\JET. The DHCP database remembers all attached database directories and files in the SYSTEM.MDB file. If the database and backup directories are moved, the backup fails because it tries to backup the database from the old and new locations, but cannot find the database file in the old location.
However, I found NO files in %systemroot%\system32\dhcp; there is NO system.mdb file on drive c.
Event Type: Information
Event Type: Error
Note: The Pervasive.SQL product provides two categories of maintenance utilities: Btrieve and SQL. The SQL Maintenance Utility supports data source named (DSNs), which are used for relational access through ODBC. See "Backing Up a Database with SQLUTIL" on page 8-18 for a discussion of the SQL Maintenance Utility.
On the Windows 2K server, the Pervasive ODBC Data Sources are a, b, c,
a --> Pervasive ODBC Engine Interface
b --> Microsoft dbase Driver (*.dbf)
c --> Driver do Microsoft Escel(*.xls)
DeluxeCD --> Microsoft Access Driver (*.mdb)
Working RFMS data files in the server c:\RFMS dir include: Receipt.dat, Comments,dat, Roll-hst.dat, Ap.dat, Roll-inv.dat, KG266180.tmp, Item-inv.dat, PRICECHG.DAT, iTEM-HST.DAT,password.dat, Wolne.dat, Jobcost.dat, Line.dat, Salesman.dat, posconfi.dat, WPASSPAT.DAT, USERCNT.DAT, Customer.dat, Header.dat
The SQL control center installed on Server 2003 is version 7.20.230.036
Task manager on W2k has more processes than the S2003
Note that when installing RFMS on Server 2003, first the Pervasive disk, then the 8.4 update, but data not connected, then the 8.4 & Payroll update, now data is connected. This also happened after installing 64 Microsoft updates.
Now the Server2003 is online and R mapped to RFMS and F mapped to PVSW. Reinstalled Pervasive from the client on Server2003. Pervasive test says it cannot connect to database. Cannot verify that relational access to Pervasive.SQL 2000 is functioning properly.
Failed to connect to the database. The Server Name of the Server DSN specified may not exist. Make sure that the Pervasive.SQL 2000 Server Engine is running on the machine specified and the user count is valid.
[Pervasive][ODBC Client Interfase][Client LNA] Connection attempt time out. The SQL Connection Manager may be inactive or using a diffenent transport protocol from the client.
I will now follow the communications troubleshooting as found in the Pervasive book
Checklist for Problems
Did you see any error messages displayed during installation? - yes see above.
Does the Network function correctly? - yes
Is the Engine running? There are no Pervasive services running on the client. On the Server, Pervasive.SQL 2000 (relatiolnal) and Pervasive.SQL 2000(transactional) services are both running
Is the Client software correctly functioning?
Are there errors in your PVSW.LOG file? No listings on the workstation, on the server, information only ntdbsmgr.exe NTMKDE. I guess these were created when I ran Navigator on the server.
There is no "Pervasive System Analyzer" but there is InstallScout which I think is the upgraded version.
The server you chose appears to have the TCP/IP protocol but Btrieve did not respond. --> Ensure Btrieve engine is started and rerun test.
Userguide.pdf, page 5-3; 6. Note: If your application used pure Btrieve access only, without ODBC, then skip this step. (This is probably what RFMS uses)
IN PCC, Supported protocols: Microsoft SPXII; Microsoft TCP/IP
On the workstation, the PCC shows Pervasive.SQL 2000 Engines --> PCS (x) SERVER (); PCS is the name of the workstation and has been changed to GX280-RFMS, SERVER is the name of the OLD server.
Therefore, reinstall Pervasive on workstation, uninstall, remove PVSW di
It worked before! Install 8.4 update and 8.4 payroll on the workstation. RFMS does not have an add/remove item, del the RFMS dir. Del PVSWarch dir. tuneup utilities for super clean
1. Install RFMS 8.4 update. The installation disk in the 8.4 update jacket said it was installing 8.3. It would not start because wbtrv32.dllwas not found, therefore start with Pervasive. delete RFMS and its shortcut.
1. install Pervasive.SQL SP4 using typical install. Logged into F and R by entering the password. Installed 10 licenses. Would not accept testing the transactional engine on F. but it would test on f:\samples but failed create, read, update, insert; passed all on c:\pvsw\samples; relational tests passed as well.
2, give everyone all rights to RFMS and PVSW on server.
3. Install RFMS from "Installation CD"
4. Install RFMS 8.4 and Paroll update, the RFMS directory is missing. Reinstall with "installation CD" Only one sub dir "Practice" was installed
5. The file c:\RFMS\RFMSvers.txt could not be opened. Copied it from the server, now installation completed. Now RFMS error (In harmony with your contract, your system is access code protected and has EXPIRED. Please contact te RFMS Sales Office. I think what got me this message is that I installed from the CD and not the server win client. But now I have the Pervasive System Analyzer Wizard.
PSV says: the server you chose appears to havfe the SPX and TCP/IP protocols but the network address returned does not look like a valid address and therefore failed, Connect to Server, Access Engine, Stress Test. usrguide.pdf says 3. check the client access requester, make sure the setting is set to on. There is no client access requester on either the server or workstation. See sgs.pdf, 15-9 Installing the Pervasive.SQL 2000i Client Components.
Run Pervasive setup from server. chose network installation, remove pervasive with add/remove, del psvw dir, installscout not found on the server; PCC on workstation shows server GX280(x).
Uninstall pervasive del pvsw and ffms, reinstall pv from server.
Forum provided new documentation followed sgs.pdf Client network configuration 17-17 to make server ip 192.168.1.51 and set up in hosts file. But it seems mostly like what I already have. Now following 15-9, Installing the Pervasive.SQL 200i Client Components. Setup is removing the existing copy. Selecting network install to c:\pvsw. Install Scout was not fiund on the Server. Database connectivity tests will not be performed but it continues on to copy files and utilities.
Had to install from CD to get the Pervasive System Analyzerv
server ip: 22.214.171.124
sql test passed when the server firewall was turned off. Reinstalled the Pervasive 2000 on server and on client, then the RFMS. Before this error 3012, and then passlvl.dat could not be opened. Still getting file c:\RFMS\Passlevl.dat could not be opened. Error: Unknown Error *3012) Press ok to end application. Runnig a fuller Pervasive System Analyzer. Copied Nadia RFMS backup from server 1 to c:
Client RFMS has File Access Error
Change the security of this file to full control for everyone. Add full control to Users (PC2\Users) But still says it cannot access. On the server, the owner of this file is Administrators (SERVER1\Administrators). Will copy this file which was last modified in 2002, to the client. The file on the Client was dated 4/20/2001 and the server file was dated 10/29/2002. Since now we still have file access error, this must be caused by something else.
Primary Computer Service, Inc.