Category Archives: SQL

Counting SQL Users

PCSchool Version 2014.0 or above. PCSchool has now added the ability for SQL schools to view which users are running a Back Office executable (eg. Curric.exe, Debtors.exe). This is often useful if you are doing an Update or End of … Continue reading

Posted in Security, SQL, Technical / Sys Admin | Tagged , , , , , , , , , | Leave a comment

ARTHIABORT error in Spider Teacher Timetable

Issue: Sometimes when you try to run the timetable for a staff member, it comes up with the following message:  Solution: Go into your PCSchool database properties in SQL server. It may have compatibity settings set to 2000. We use some TSQL … Continue reading

Posted in 'Spider' Web App, SQL, Teacher Portal | Tagged , , , , , | Leave a comment

Server Running Slow

Issue – A school running PCSchool on Microsoft Windows Server 2008 R2 (64 bit) found that the server (and PCSchool) was running VERY slowly. Solution – They increased the memory on the server (allowing for an additional 4GB) and  changed … Continue reading

Posted in SQL, Technical / Sys Admin | Tagged , , , , , , , | Leave a comment

SQL Server 2005/2008/R2 with data migrated from Version 2000

Issue – When opening the Teacher Timetable control in Spider the following error is received:  (The above error states: “Error generating SELECT failed because the following SET options have incorrect settings is ‘ARITHABORT’. Verify that SET options are correct for use … Continue reading

Posted in 'Spider' Web App, SQL, Teacher Portal, Technical / Sys Admin, Trouble Shooting / Error Messages | Tagged , , , , , , , | Leave a comment

Importing the Database From One Version of SQL to a Newer Version when Moving to a New Server

If you are currently running PCSchool on an SQL2005 server and are transferring PCSchool to a new server which has a newer version of SQL (eg. SQL2008) then a possible error you may receive after the transfer is ‘ERROR: 515 – SQLSTATE: 23000 – Execute … Continue reading

Posted in SQL, Technical / Sys Admin, Trouble Shooting / Error Messages | Tagged , , , , | 1 Comment

Install PCSchool Software (run a PCRemote)

Download instructions on how to install PCSchool on: SQL Client Machine (new machine) SQL Client Machine (reinstall or update from Dataflex) NonSQL Client Machine (new machine) NonSQL Client Machine (re-install or re-run PCRemote) Possible errors you may receive after the installation … Continue reading

Posted in Installation, SQL, Technical / Sys Admin, Trouble Shooting / Error Messages | Tagged , | 1 Comment

Installation Problems

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. SQL Installation 1. When first logging on through the new icon … Continue reading

Posted in Installation, SQL, Technical / Sys Admin, Trouble Shooting / Error Messages | Tagged , , , , , , , | Leave a comment