Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 what the hell....

Author  Topic 

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2006-01-05 : 09:39:21
.. does this error mean:

rs.ActiveConnection.Errors(0)
Number: -2147467262
Source: "Microsoft OLE DB Service Components"
Description: "No such interface supported"


MDAC = 2.8
it happens when i run:
rs.Open "valid select statement", conn



Go with the flow & have fun! Else fight the flow

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2006-01-05 : 10:36:06
I got no idea but this came up on a google.groups search:
quote:

IE 5.5 -2147467262 no such interface supported error message

1. ray nelson
Jun 7 2002, 2:28 pm show options

Newsgroups: microsoft.public.windows.inetexplorer.ie55.browser
From: "ray nelson" <rnel...@firstam.com> - Find messages by this author
Date: Fri, 7 Jun 2002 12:24:24 -0700
Local: Fri, Jun 7 2002 2:24 pm
Subject: IE 5.5 -2147467262 no such interface supported error message

Getting -2147467262 no such interface supported interface
running web based application while trying to print.
Setup Pc's identical to ones at another office and they
work fine.


2. Henri Leboeuf
See if these article can help identify your problem.


PRB: System Error "No Such Interface Supported"
System Error &H80004002 (-2147467262) Note that the memory address may vary.
This error is caused by an incorrect version of comcat.dll.
http://support.microsoft.com/default.aspx?scid=KB;EN-US;q183370 (VB 5.0 Oct.
3, 2001)


PRB: Mismatched Ole32.dll and Comcat.dll
System Error &H80004002 (-2147467262). No such interface supported.
http://support.microsoft.com/default.aspx?scid=KB;EN-US;q201364 (Aug. 10,
2001)


PRB: Error Message: "No Such Interface Supported" Creating Data Connection
in Visual InterDev
System Error &H80004002 (-2147467262) No Such Interface Supported
http://support.microsoft.com/default.aspx?scid=KB;EN-US;q246896



Be One with the Optimizer
TG
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2006-01-05 : 10:56:11
thanx TG.
i'm doing some reading of this...
i have win2k and old ASP VBScript app with commerce server 2000 and sql server 2000.
best thing is it all worked fine yesterday... so i can't really see how could it got corrupt...
this is going to be an "interesting" bug hunt...

EDIT:
oh yeah... we use VS 2003 for writing old ASP code.


Go with the flow & have fun! Else fight the flow
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-01-06 : 01:53:47
Strange. Once I also got the error like "There is no error message for this type of error".

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2006-01-10 : 04:51:54
well i still have no idea why this error occured but we fixed it
we restored a previous day backup and it worked ok.

now if anyone has any ideas... i'm all ears... Paul maybe?


Go with the flow & have fun! Else fight the flow
Go to Top of Page
   

- Advertisement -