|
|
|
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. Wednesday 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 You may receive the following Event ID: Question: I have been receiving the following errors: Event Type: Error Event Source: DhcpServer Event Category: None Event ID: 1010 Description: The DHCP service encountered the following error while cleaning up the database: An error occurred while accessing the DHCP database. Look at the DHCP server event log for more information on this error. Event Type: Error Event Source: DhcpServer Event Category: None Event ID: 1014 Description: The following problem occurred with the Jet database -1032: Jet database read or write operations failed. If the computer or database has just been upgraded, then this message can be safely ignored. If this message appears frequently, either there is not enough disk space to complete the operation or the database or backup database may be corrupt. To correct this problem, either free additional space on your hard disk or restore the database. After you restore the database, ensure that conflict detection is enabled in DHCP server properties. For information about restoring the database, see Help and Support Center. Additional Debug Information: JetBackup. Event Type: Error Event Source: DhcpServer Event Category: None Event ID: 1016 Description: The DHCP service encountered the following error when backing up the database: An error occurred while accessing the DHCP database. Look at the DHCP server event log for more information on this error. Resolution: 1. Disable Allow Indexing Service to index this disk for fast file searching. To do that, open the properties of the C. Select General. Uncheck the Allow Indexing Service to index this disk for fast file searching. 2. It could a software issue, for example Anti-virus and security software. You may try to Windows clean boot to test it. 3. Copy the original Windows system.md_ file from the Windows compact disc to your hard drive. Then, run the <Systemroot>\\System32\\Expand.exe program to expand System.md_ to System.mdb. Next, copy System.mdb to the new database location. 4. Or refer to the following links: Event Viewer Displays DHCP Events 1010, 1016, and 1014 ... The DHCP server encountered the following error when cleaning up the user database -or- DHCP Event 1016 ... Article ID : 129730: Last Review : November 1, 2006: Revision : 4.1 http://support.microsoft.com/kb/129730 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. DHCP server stops leasing addresses
if a sharing violation occurs Related Topics Event ID Troubleshooting
Disk Check 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. 9/21/10 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 Forum link: http://cs.pervasive.com/forums/p/13234/45307.aspx#45307server ip: 67.105.91.86
9/30/10 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: 10/7/10 Client RFMS has File Access Error File C:\RFMS\Passlevl.dat could not bve opened. Error: Unknown Error (3012). Press OK to end this. 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.
|