Article View: borland.public.cppbuilder.database.ado
Article #1883Run-time error '-2147418113': Catastrophic failure
From: Patrick Gibbons
Date: Sun, 11 Jan 2004 08:17
Date: Sun, 11 Jan 2004 08:17
30 lines
2344 bytes
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-mailShow 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