| John Van Hengel 2005-07-28, 1:25 pm |
| I recently installed the SBS 2003 SP1 update.
This included ISA 2004 and SQL 2000 SP4.
After installing this update I am having problems with the SQL server.
I use a time clock software called Hourtrack 2000 enterprise.
This software uses SQL server as it's database.
Since the update just moving from record to record is very slow and can generate errors.
I am unable to run reports.
I have tested this from another workstation with the same effect.
However if I run the software on the SBS server itself it seems to work ok.
I will include a portion of the error log from Hourtrack.
Note: these errors are happening after you sign in to the database and are working in the program.
A test of the ODBC connection is successful.
I will try to find an error log in the SQL server (not sure where it is right off the bat so will
have to hunt it down.)
Error Location: Organization::GetPay
Type
Error Number: 0
Error Description: Cannot open database
Internal Error Number: 10002
Time Error Occurred: 07/25/2005 4:06:14 PM
Error Location: VHTTIMESHEETS. CUtilities::OpenDB:G
etNativeError
Error Number: 17
Error Description: Native error for: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not
exist or access denied.
Internal Error Number: -2147467259
Time Error Occurred: 07/25/2005 4:10:41 PM
Error Location: VHTTIMESHEETS. CUtilities::OpenDB:S
electErrorCode
Error Number: -2147467259
Error Description: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied. Connection String=Provider=SQLO
LEDB;Server=10.0.0. 1;Database=HourTrack
;
Internal Error Number: -2147467259
Time Error Occurred: 07/25/2005 4:10:41 PM
Error Location: TimeSheets::GetHours
WorkedDetails
Error Number: 0
Error Description: Cannot open database
Internal Error Number: 70002
Time Error Occurred: 07/25/2005 4:10:41 PM
Error Location: VHTEMPLOYEES. CUtilities::OpenDB:S
electErrorCode
Error Number: -2147467259
Error Description: Timeout expired Connection
String=Provider=SQLO
LEDB;Server=10.0.0. 1;Database=HourTrack
;
Internal Error Number: -2147467259
Time Error Occurred: 07/26/2005 9:51:57 AM
Error Location: Employees::GetEmploy
ees
Error Number: 0
Error Description: Cannot open database
Internal Error Number: 20003
Time Error Occurred: 07/26/2005 9:51:57 AM
Error Location: VHTORGANIZATION. CUtilities::OpenDB:S
electErrorCode
Error Number: -2147467259
Error Description: Timeout expired Connection
String=Provider=SQLO
LEDB;Server=10.0.0. 1;Database=HourTrack
;
Internal Error Number: -2147467259
Time Error Occurred: 07/26/2005 9:53:39 AM
Error Location: Organization::GetPay
Type
Error Number: 0
Error Description: Cannot open database
Internal Error Number: 10002
Time Error Occurred: 07/26/2005 9:53:39 AM
Error Location: VHTTIMESHEETS. CUtilities::OpenDB:S
electErrorCode
Error Number: -2147467259
Error Description: Timeout expired Connection
String=Provider=SQLO
LEDB;Server=10.0.0. 1;Database=HourTrack
;
Internal Error Number: -2147467259
Time Error Occurred: 07/26/2005 9:56:45 AM
Error Location: TimeSheets::GetHours
WorkedDetails
Error Number: 0
Error Description: Cannot open database
Internal Error Number: 70002
Time Error Occurred: 07/26/2005 9:56:45 AM
Error Location: VHTTIMESHEETS. CUtilities::OpenDB:S
electErrorCode
Error Number: -2147467259
Error Description: Timeout expired Connection
String=Provider=SQLO
LEDB;Server=10.0.0. 1;Database=HourTrack
;
Internal Error Number: -2147467259
Time Error Occurred: 07/26/2005 9:57:52 AM
|