🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.ado
Article #1883

Run-time error '-2147418113': Catastrophic failure

#1883
From: Patrick Gibbons
Date: Sun, 11 Jan 2004 08:17
30 lines
2344 bytes
Does anyone know why I am getting this error:

Run-time error '-2147418113': Catastrophic failure

, from the following:

Set rstCat = New ADODB.Recordset
rstCat.CursorLocation = adUseClient
rstCat.Open "SELECT * FROM quniCatData", CurrentProject.Connection,
adOpenStatic, adLockReadOnly

MS has these available:
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q187/9/42.asp&NoWebContent=1
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q180/8/43.asp&NoWebContent=1

I have added the rstCat.CursorLocation = adUseClient to comply with the MS
documentation, however this as noted above has not solved the problem.

Some more info:
I am writing in Access 2K (9.0 Object Library) with ADO (2.1 Library) and
placing the data from this union query into a treeview control (Windows
Common Controls 6.0 (SP6)).

Any ideas?  I don't want to go back to DAO, but I am prepared to if it comes
to that . . . Hopefully I am just missing something easy . . .

Please contact me if you have any questions,

Patrick Gibbons
fnkleroi@hotmail.com
Technical Details
Message-ID: <PE7Mb.7352$EL4.5277@nwrddc02.gnilink.net>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!news.algonet.se!algonet!news.tele.dk!news.tele.dk!small.news.tele.dk!fi.sn.net!newsfeed2.fi.sn.net!news2.euro.net!216.166.71.118.MISMATCH!small1.nntp.aus1.giganews.com!nntp.giganews.com!cyclone1.gnilink.net!spamkiller.gnilink.net!nwrddc02.gnilink.net.POSTED!4e451a4f!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,35811cfa43e735a5,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2004-01-11 00:17:52 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!news.algonet.se!algonet!news.tele.dk!news.tele.dk!small.news.tele.dk!fi.sn.net!newsfeed2.fi.sn.net!news2.euro.net!216.166.71.118.MISMATCH!small1.nntp.aus1.giganews.com!nntp.giganews.com!cyclone1.gnilink.net!spamkiller.gnilink.net!nwrddc02.gnilink.net.POSTED!4e451a4f!not-for-mail
From: "Patrick Gibbons" <fnkleroi@hotmail.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Run-time error '-2147418113': Catastrophic failure
Lines: 34
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <PE7Mb.7352$EL4.5277@nwrddc02.gnilink.net>
Date: Sun, 11 Jan 2004 08:17:51 GMT
NNTP-Posting-Host: 4.41.131.1
X-Complaints-To: abuse@verizon.net
X-Trace: nwrddc02.gnilink.net 1073809071 4.41.131.1 (Sun, 11 Jan 2004 03:17:51 EST)
NNTP-Posting-Date: Sun, 11 Jan 2004 03:17:51 EST