SQLServer2000 date conversion error occurs in non-US systems
Date: September 17, 2002
Version affected: v1.60 SQLServer2000, non-US
Does not affect copies of WBT
Manager 1.60 downloaded after September 17, 2002.
Symptoms:
In installations running against SQLServer2000 where the database server is using a non-US date format (yy/dd/mm rather than yy/mm/dd), a SQLServer "value out of range" error occurs during student login when the day is past 12. On French systems the error looks like:
Module: /wbtmanager/asp/smaint.asp At: ExpireCertificates@1100 Statement: select cp.name, ct.class_id, ct.compldt, ct.expdt from certif ct, classes cp where ct.class_id=cp.class_id and stud_id=1 and ct.expdt is not null and ct.expdt<CONVERT(datetime,'2002-9-13 12:6:20') Error In: Microsoft OLE DB Provider for ODBC Drivers Error Code: -2147217913 Description: [Microsoft][ODBC SQL Server Driver][SQL Server]La conversion d'un type de données CHAR en type DATETIME a donné une valeur hors des limites des valeurs de date et d'heure. SQLState: 22008
Correction:
It appears that SQLServer 2000 no longer recognizes ODBC Canonical date format (yyyy-mm-dd hh:mm:ss) by default. global.asa has been modified to include a format specifier in the SQLServer CONVERT function call.
This patch contains a updated versions of:
global.asa dated:9/17/2002 08:13
After unzipping the patch file to a temporary directory, copy the global.asa to the root of your WBT Manager web installation.
It is not necessary to re-start the web-server.