Following are some common errors that may occur when installing PCSchool software on a client machine.
Full instructions and error fixes for PCSchool installation can be downloaded from here.
1. When first logging on through the new icon the following errors appear:
Your sql_drv.cfg and sql_drv.dll files are were not properly installed or registered to your Visual DataFlex\bin folder on your local machine. Copy these files from your server to your local machine as shown below.
Copy these files from your server to your Visual DataFlex 11.0\Bin folder on your local machine (eg. C:\Program Files\Visual DataFlex 11.0\Bin)
2. When logging on through the new icon an error message stating “unable to verify User Counting System. License is exhausted.” Or “Cannot find lock file – user count exceeded for this license”. Your Mertech SQL Driver is not registered, follow the instructions above and register again.
Another possible cause of 1 and 2 above may be that the user does not have the necessary windows permissions to access the license files to run PCSchool. Ensure that the user has full access to both the PCSchool folder and the Visual DataFlex folder (and their subfolders) on their local machine.
3. If you are not able to install the SQL Connectivity from the PCRemote install (eg. a command prompt just flashes up on your screen then disappears) then you will need to install Mertech and SQL manually. To do this you need go to the PCSchool folder on the server and find the Setupwinv10.mis, run this, and then the find sqlncli.msi, and run this. 4. If installing PCSchool on a Windows 7 machine view possible issues outlined on the ‘PCSchool & Windows 7’ page.
5. If you get the following error after the install: Or a popup appears asking you to enter in the SQL server, username and password then you may need to check that the computer you are working on has a connection to the SQL server.
To test this you can do an ODBC Test from on the local machine via the Administrative Tools under Control Panel:
From the list select ‘Data Sources (ODBC)’ → select the User DSN tab → select Add → select SQL Server and Finish: Enter the name of the server and then search for the SQL Server you want to connect to:
Select the 2nd login option then enter in the correct SQL Server ID and Password → select Next to test the connection: You should receive a Server Login message stating that the connection was successful.
However if you receive a Server Login messaging stating that the connection failed (as below) it is likely that the Login ID and/or password was incorrect, or the Port number is not correct. To check the Port Number do the following.
If you are still unsuccessful it may be that the user does not have rights to connect to the SQL Server OR the Network Protocol has not been set correctily OR the Firewall may be blocking the port the computer is using to connnect to the SQL server.
1. When first logging on through the new icon the following error appears:The above error usually indicates that the PCRemote was not run correctly and that the path to the SOURCE location (where the FileList.cfg is found) was not selected correctly.
To resolve the problem re-run the PCRemote2005NonSQL.exe and ensure you select the correct path as shown below: Alternately this error message could indicate that the local machine has lost its connection with the Server, check that:
- The Network has not gone down and you can connect to the server
- The Server that PCSchool is on has not gone down
- The Drive that PCSchool is mapped to on your local machine (eg P:\) is still available / connected, if not it will need to be re-mapped for the local machine.
- That you have permissions to access the mapped / shared drive to PCSchool on the Server.
2. When first logging on through the new icon the following error appears: The above error usually indicates that the user who is logged onto the local machine does not have the necessary permissions to access the required files in the Visual DataFlex or PCSchool folders on their local drive (eg. the files may be ‘Read Only’).
It is recommended that the user of the local machine has FULL CONTROL to both the PCSchool folder and the Visual DataFlex folder (and all files and sub-folders within) on their local drive.
3. If installing PCSchool on a Windows 7 machine view possible issues outlined on the ‘PCSchool & Windows 7’ page.