Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Catastrophic Error Expand / Collapse
Author
Message
Posted Thursday, April 1, 2004 12:08 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, June 27, 2011 3:18 PM
Points: 63, Visits: 67

Hi Guys,
Has anyone come accross something similar below...I will let you know more details if Yes.
Please let me know on what occasion this could occur.

1. Automation error
Catastrophic failure |GetArray|Table ID : 8|-2147418113||.

2. [Microsoft][ODBC SQL Server Driver][SQL Server]Changed database context to 'stride_demolaptop'.|General_SetMemObj||5||.

Levi




Jesus My Saviour
Post #109420
Posted Thursday, April 1, 2004 11:51 AM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Thursday, July 10, 2014 1:34 PM
Points: 6,623, Visits: 1,855
Here's what I found in the Knowledge Base.

FIX: "Catastrophic Failure" Error Message When You Use adPromptAlways to Connect to SQL Server 2000

http://support.microsoft.com/default.aspx?scid=kb;en-us;314635

PRB: Catastrophic Error Occurs Referencing ADO Recordset

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q187/9/42.asp&NoWebContent=1


K. Brian Kelley, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog | LinkedIn | Twitter
Post #109540
Posted Thursday, April 1, 2004 10:40 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, June 27, 2011 3:18 PM
Points: 63, Visits: 67

Thanks Kelly,

But we use ODBC and this does not seems to be the cause...anyway...let me know if you have something more on this..

Levi




Jesus My Saviour
Post #109592
Posted Friday, April 2, 2004 1:30 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 26, 2008 8:48 AM
Points: 4, Visits: 10
Check your service accounts are not locked out if they are network accounts. If this does not work then set your service accounts to local system and try again.


Post #109606
Posted Friday, April 2, 2004 2:22 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, June 27, 2011 3:18 PM
Points: 63, Visits: 67

Hi

The SQL Server7.0 is clustered and replication enabled...and the user account is in the local admin group, cannot change the service accounts to local

Levi




Jesus My Saviour
Post #109612
Posted Friday, April 2, 2004 6:56 AM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Thursday, July 10, 2014 1:34 PM
Points: 6,623, Visits: 1,855
Both articles use OLE DB as an example to reproduce the behavior but they leave it generic to ADO in general. If you are using ADO, these could apply. Also, even if you're using ODBC, you may have an OLE DB interconnectivity in there somewhere...

SQL Server Connection Basics (MSDN)


K. Brian Kelley, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog | LinkedIn | Twitter
Post #109654
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse