Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databases
SQL server problems after upgrade to SP4I 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 gene rate 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 w orking 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 righ t 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 (Conn ect()).]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=HourTra ck; 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
Post Follow-up to this message
Sponsored Links
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread
