OLE error can't find anything that works

[npd]

my website is [url]http://12.206.71.14/asp[/url] (for now)... none of
the ASP in that section works. Here is what I posted at
devshed...

I'm using the example on borland with the IBPheonix
connect string in another thread. Also the ODBC "Test
Connection" says it's OK, and I know ASP runs on my IIS
server... but I still get

error '8002801c'
Error accessing the OLE registry.

/iisHelp/common/500-100.asp, line 10

I'm using this
Set cnn = CreateObject("ADODB.Connection");
cnn.Open("DRIVER={Firebird/Interbase(r) Driver};
DBNAME=localhost:C:\Program Files\Firebird\Firebird_1_5
\examples\EMPLOYEE.FDB; UID=SYSTEM1; PWD=USER23");

anyone know what to do?
I've searched for 2 hours on the 'net... and have had
problems all the way through getting ISI to work. This
should be the last step.

Thanks, I'm on XP, if that helps.

MAJOR EDIT:
I did this with MySQL too... same error, doesn't seem to
be a problem with firebird. I enabled the permissions on
the OLE registry values as well, didn't help.

I've been using Regmon to find out what accesses the
registry from where and finding ACCDENIED on Guest, so I
enabled them all but HKCR\TypeLib won't allow Guest to
access it even with permissions. This happens when I
access my DB page.

[url]http://www.learnasp.com/listserv/archives/error0177.asp[/url]

that guy has a similar problem. I don't think this is DB
related. MS has been so kind as to not offer 8002801c on
their knowledge base as well. Anyone know what's going on?

[npd]

forgot to say, ASP itself works, I've tested it without db
stuff.

[Jeff Cochran]

On Mon, 5 Jan 2004 03:54:48 -0800, "npd"
<anonymous@discussions.microsoft.com> wrote:

>my website is [url]http://12.206.71.14/asp[/url] (for now)... none of
>the ASP in that section works. Here is what I posted at
>devshed...
>
>I'm using the example on borland with the IBPheonix
>connect string in another thread. Also the ODBC "Test
>Connection" says it's OK, and I know ASP runs on my IIS
>server... but I still get

To start, skip ODBC and go to OLEDB connections. IU won't go into all
the reasons, they get hashed out enough.

>error '8002801c'
>Error accessing the OLE registry.
>
>/iisHelp/common/500-100.asp, line 10
>
>I'm using this
>Set cnn = CreateObject("ADODB.Connection");
>cnn.Open("DRIVER={Firebird/Interbase(r) Driver};
>DBNAME=localhost:C:\Program Files\Firebird\Firebird_1_5
>\examples\EMPLOYEE.FDB; UID=SYSTEM1; PWD=USER23");

Why the "Localhost" in the ODBC string? I don't use Interbase so it
may be a requirement there.

>anyone know what to do?
>I've searched for 2 hours on the 'net... and have had
>problems all the way through getting ISI to work. This
>should be the last step.
>
>Thanks, I'm on XP, if that helps.
>
>MAJOR EDIT:
>I did this with MySQL too... same error, doesn't seem to
>be a problem with firebird. I enabled the permissions on
>the OLE registry values as well, didn't help.

Enabled *which* permissions and for *which* user? Normally the IUSR
account will need change permission to the ODBC key in the registry.

Jeff

> I've been using Regmon to find out what accesses the
>registry from where and finding ACCDENIED on Guest, so I
>enabled them all but HKCR\TypeLib won't allow Guest to
>access it even with permissions. This happens when I
>access my DB page.
>
>[url]http://www.learnasp.com/listserv/archives/error0177.asp[/url]
>
>that guy has a similar problem. I don't think this is DB
>related. MS has been so kind as to not offer 8002801c on
>their knowledge base as well. Anyone know what's going on?
>
>
>
>
>

[npd]

Hey, thanks man... your IUSR suggestion helped. I had it
on Guest... now it's using my name, turns out it was the
permissions. I'll deal with it later for security, but
right now, with full access... well

[url]http://12.206.71.14/asp/testit.asp[/url]

is way more helpful. And yeah, firebird runs that way. You
can do directory browsing, testit is my firebird test,
testitmy is my mysql test.now for those connection things.

dude, this has taken me over 30 hours ... usually it's 72.
Thanks. My AIM is fighting shadow if you need anything.

[Jeff Cochran]

On Mon, 5 Jan 2004 07:37:25 -0800, "npd"
<anonymous@discussions.microsoft.com> wrote:

>Hey, thanks man... your IUSR suggestion helped. I had it
>on Guest... now it's using my name, turns out it was the
>permissions. I'll deal with it later for security, but
>right now, with full access... well
>
>[url]http://12.206.71.14/asp/testit.asp[/url]
>
>is way more helpful. And yeah, firebird runs that way. You
>can do directory browsing, testit is my firebird test,
>testitmy is my mysql test.now for those connection things.
>
>dude, this has taken me over 30 hours ... usually it's 72.

Usually takes me more like two weeks, but I'm stubborn. :)

Good to hear it worked.

Jeff