Can't connect to oracle

[Mike D]

I am trying to connect to Oracle 9i release 2 from my IIS
5 on win 2000 pro development machine.

I have oracle 8.1.7 client which has the OO4O installed.

My connect string looks like this:

Provider=OraOLEDB.Oracle.1;Password=xxx;Persist Security
Info=True;User ID=xxx;Data Source=xxx

I am getting an error:
The remote procedure call failed and did not execute.

My asp code looks like this:



cstIntranetdb = "VALID string"

set Conn = server.createobject("adodb.connection")
conn.open cstIntranetdb
Conn.Close
Set Conn = Nothing

What am I missing? I don't want to use a DSN.

Thanks
Mike

[Aaron [SQL Server MVP]]

> cstIntranetdb = "VALID string"

"VALID" = an assumption, I presume, based on it working elsewhere (probably
with different security configuration). Please try the string using
OraOLEDB.Oracle found in [url]http://www.aspfaq.com/2126[/url]

--
[url]http://www.aspfaq.com/[/url]
(Reverse address to reply.)

[Mike D]

ASPFAQ was the first place I went for the string.

I said valid string because I made a .udl file and tested
the connection through it and the connection succeeded.

Mike

>-----Original Message-----

>> cstIntranetdb = "VALID string"

>
>"VALID" = an assumption, I presume, based on it working

elsewhere (probably

>with different security configuration). Please try the

string using

>OraOLEDB.Oracle found in [url]http://www.aspfaq.com/2126[/url]
>
>--
>[url]http://www.aspfaq.com/[/url]
>(Reverse address to reply.)
>
>
>.
>

[Roland Hall]

"Mike D" wrote in message news:174b501c448e8$ecab0520$a301280a@phx.gbl...
: ASPFAQ was the first place I went for the string.
:
: I said valid string because I made a .udl file and tested
: the connection through it and the connection succeeded.

With a UDL file that works you can drag that to notepad and view the
content. However, if this is Oracle from Oracle and not MSFT, then this
should work:

[url]http://able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForOracleFromOrac le[/url]

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - [url]http://www.microsoft.com/technet/scriptcenter/[/url]
WSH 5.6 Documentation - [url]http://msdn.microsoft.com/downloads/list/webdev.asp[/url]
MSDN Library - [url]http://msdn.microsoft.com/library/default.asp[/url]

[Aaron [SQL Server MVP]]

> ASPFAQ was the first place I went for the string.

And what happened when you tried THAT string? The string I've listed
mentions nothing about persist security info, etc.

> I said valid string because I made a .udl file and tested
> the connection through it and the connection succeeded.

YES! You executed that as YOU. Now, let's go back to IIS fundamentals...
IIS doesn't run ASP pages as YOU, it executes them as IUSR_YourMachineName.
Which, by default, is a very low-privileged, local user account. Which is
why the "Persist Security Info" part of your string appeared quite
suspicious to me. If Oracle is running on another machine, it has no idea
who IUSR_YourMachineName is.

A