Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Problem

Truancy Call has been unable to connect to its own local database. Error could also be shown as: 

...

Press Start Button, then select Control Panel
Press the Start button and select Control Panel
Select Admin Tools
Select Administrative Tools

ODBC Data Sources (32-bit)
Double Click TC_DATA_P
Double click "TC_DATA_P"
Select 'Repair' button
Press the 'Repair' button
Press OK
Press the 'OK' button
Database successfully repaired
This should display a "Database successfully repaired" message. 
If so, restart Truancy Call.

...


64 bit system - Go to: C:\Windows\SysWOW64>odbcad32.exe > Select System DSN > double click the Microsoft Access driver with the name TC<name of your MIS> eg. TCSIMS or TCCMIS > select Repair > press OK. Retry Truancy Call.

...

  1. "You attempted to open a database which is already opened exclusively...". 
    Close down Truancy Call and ensure no other users are using Truancy Call. 
  2. "Unrecognised database format" or if repairing the databases does not resolve the issue 
    Go to the \Truancy Call sub folder on your Server (eg S:\SIMS\TruancyCall). Locate and rename the file TC_DATA_P.mdb to TC_DATA_Pold.mdb , then rename TC_DATA_P.bak -> to TC_DATA_P.mdb. Restart Truancy Call.
  3. "Not enough space on disk." It is possible the disk drive where the Truancy Call database is located is full. Free up some space and try Truancy Call again.
  4. Check your Truancy Call log file for the entry: 

...

Panel
bgColor#fff
If all the above has failed to resolve the problem please download this file (its a blank version of the Truancy Call database - any blocks or filters set would be lost): http://www.truancycall.com/tc_data_p.mdb and save it to your local machine. Then copy this file to your server. It will overwrite any existing file, so we recommend you rename the existing file to say tc_data_p_old.mdb first of all. The likely location of the file is below: 

SIMS users: \SIMS\TruancyCall 

CMIS users: \Admin\TruancyCall 

Integris users: \Keys\Integris\TruancyCall 

SEEMIS users: \truancycall folder inside wherever your SEEMIS export files are (e.g. G:\Seemis\contacts.txt or G:\Seemis\truancycall 

Filter by label (Content by label)
showLabelsfalse
max5
spacesCGCSD
showSpacefalse
sortmodified
reversetrue
typepage
cqllabel in ( "database" , "repair" , "tc" , "truancycall" , "truancy" ) and type = "page" and space = "CGCSD"
labelstruancycall tc database repair truancy

...