Oracle Adventures [英] Oracle Adventures

问题描述

该机器正在运行带有所有最新服务包等的XP专业版。我必须

访问Oracle数据库，所以我安装了Oracle客户端的东西。我可以从Windows应用程序查询Oracle的b $ b，没问题。使用完全相同的代码（复制

并粘贴）到Web应用程序中我收到以下错误错误，同时尝试

检索文本错误ORA-01019。安全性我想，所以我在网站上使用

模拟，然后aspnet_wp.exe在'无论''参考内存'处的'

指令崩溃' '随你''。内存可以

不能读取


我想安全性是这里的一个问题，ASP.NET用户或互联网客户

帐户可能需要访问Oracle目录，我不知道在哪里。

任何帮助将不胜感激。

The machine is running XP Pro with all the latest service packs, etc. I must
access an Oracle database so I installed the Oracle client stuff. I can
query Oracle from a Windows app, no problem. Using the exact same code (copy
and paste) into a Web app I get the following error "Error while trying to
retrieve text for error ORA-01019". Security I thought, so I use
Impersonation on the Web site, then the aspnet_wp.exe crashes with "The
instruction at ''whatever'' referenced memory at ''whatever''. The memory could
not be read"

I guess security is one issue here, the ASP.NET user or Internet Guest
account may need access to an Oracle directory and I don''t know where.
Any help will be appreciated.

推荐答案

作为一个开始 - 抛弃Oracle并获得一个全能的数据库

互连............ oracles可怕的......


如果失败了（并不总是令人遗憾的选择） - 如果它可以从你的桌面运行，那么
尝试在你的应用程序中运行应用程序作为同一个命名帐户

web.config并看看会发生什么


< identity impersonate =" true"

userName =" domain \ user"

密码="密码" />


-

问候


John Timney

ASP。 NET MVP

微软区域总监


" Chris Botha" < CH *********** @ AThotmail.com>在留言中写道

新闻：％2 **************** @ TK2MSFTNGP12.phx.gbl ...

as a start - throw away Oracle and get a database that alllows
interconnectivity............oracles awful for it...

Failing that (not always an option sadly) - if it works from your desktop,
try running the application as the same named account in your applications
web.config and see what happens

<identity impersonate="true"
userName="domain\user"
password="password" />

--
Regards

John Timney
ASP.NET MVP
Microsoft Regional Director

"Chris Botha" <ch***********@AThotmail.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...

机器正在运行带有所有最新服务包等的XP专业版。我必须访问Oracle数据库，所以我安装了Oracle客户端的东西。我可以从Windows应用程序查询Oracle，没问题。使用完全相同的代码
（复制和粘贴）到Web应用程序中我收到以下错误错误，而
尝试检索错误ORA-01019的文本。安全性我想，所以我在网站上使用模拟，然后aspnet_wp.exe在''什么''引用内存的''
指令处崩溃。无法读取内存

我认为安全性是这里的一个问题，ASP.NET用户或Internet Guest
帐户可能需要访问Oracle目录而且我不喜欢不知道在哪里。
任何帮助都将不胜感激。

The machine is running XP Pro with all the latest service packs, etc. I
must access an Oracle database so I installed the Oracle client stuff. I
can query Oracle from a Windows app, no problem. Using the exact same code
(copy and paste) into a Web app I get the following error "Error while
trying to retrieve text for error ORA-01019". Security I thought, so I use
Impersonation on the Web site, then the aspnet_wp.exe crashes with "The
instruction at ''whatever'' referenced memory at ''whatever''. The memory
could not be read"

I guess security is one issue here, the ASP.NET user or Internet Guest
account may need access to an Oracle directory and I don''t know where.
Any help will be appreciated.

嗨John，Oracle不是我的选择，我不打电话它周围的甲骨文，但是它不会用于发布。

感谢您的回答，但如果您在我的帖子末尾阅读，请参阅

那就是我所做的（冒充）然后它崩溃了

aspnet_wp.exe。

所以我希望...，实际上我不喜欢我不知道我希望的是什么，但是

谢谢。


" John Timney（MVP）" < TI ***** @ despammed.com>在消息中写道

新闻：uA ************* @ TK2MSFTNGP11.phx.gbl ...

Hi John, Oracle is not my choice, I don''t call it Oracle around here, but it
is not for publication.
Thanks for your answer, but if you read towards the end of my post, see
that''s what I did (impersonation) and that it then crashes the
aspnet_wp.exe.
So I was hoping ..., actually I don''t know what I was hoping for, but
thanks.

"John Timney ( MVP )" <ti*****@despammed.com> wrote in message
news:uA*************@TK2MSFTNGP11.phx.gbl...

作为一个开始 - 扔掉甲骨文并得到一个全面的数据库互联互通............ oracles对它来说太可怕了......

失败了（并不总是遗憾地选择） - 如果它可以在您的桌面上运行，尝试在您的应用程序中运行应用程序作为相同的命名帐户
web.config，看看会发生什么

< identity impersonate =" true"
userName =" domain\user"
密码="密码" />

-
问候

John Timney
ASP.NET MVP
微软区域总监
Chris Botha < CH *********** @ AThotmail.com>在消息中写道
新闻：％2 **************** @ TK2MSFTNGP12.phx.gbl ...

as a start - throw away Oracle and get a database that alllows
interconnectivity............oracles awful for it...

Failing that (not always an option sadly) - if it works from your desktop,
try running the application as the same named account in your applications
web.config and see what happens

<identity impersonate="true"
userName="domain\user"
password="password" />

--
Regards

John Timney
ASP.NET MVP
Microsoft Regional Director

"Chris Botha" <ch***********@AThotmail.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...

机器正在运行XP专业版使用所有最新的服务包等。我必须访问Oracle数据库，以便安装Oracle客户端。我可以从Windows应用程序查询Oracle，没问题。使用完全相同的代码（复制和粘贴）到Web应用程序中，我在尝试检索错误ORA-01019的文本时收到以下错误错误
。安全性我想，
所以我在网站上使用模拟，然后aspnet_wp.exe崩溃
与''什么''的指令在''什么''引用内存。无法读取
内存

我认为安全性是这里的一个问题，ASP.NET用户或Internet Guest
帐户可能需要访问Oracle目录而我不要不知道在哪里。
任何帮助都将不胜感激。

The machine is running XP Pro with all the latest service packs, etc. I
must access an Oracle database so I installed the Oracle client stuff. I
can query Oracle from a Windows app, no problem. Using the exact same
code (copy and paste) into a Web app I get the following error "Error
while trying to retrieve text for error ORA-01019". Security I thought,
so I use Impersonation on the Web site, then the aspnet_wp.exe crashes
with "The instruction at ''whatever'' referenced memory at ''whatever''. The
memory could not be read"

I guess security is one issue here, the ASP.NET user or Internet Guest
account may need access to an Oracle directory and I don''t know where.
Any help will be appreciated.

不确定为什么错误文本不能显示..


ASPNET帐户应该读取并执行对oracle bin目录的访问权限

（其中有oci.dll）和tnsnames目录。 ora文件（？ - 不确定这个

是否需要）


还建议在oracle安装后重启机器&

更改dir权限..


我已经成功完成了本文中提到的步骤..（同样适用于asp&

..net）
http ：//support.microsoft.com/default...55084& LN = EN-US


" Chris Botha"写道：

not sure why the error text cannot be displayed..

ASPNET account should get read and execute access to the oracle bin dir
(where ever oci.dll is) and directory of tnsnames.ora file (? - not sure this
is required)

Also it is adviced to reboot the machine after oracle installation &
changing dir permissions..

I have had success with steps mentioned in this article.. (same for asp &
..net)
http://support.microsoft.com/default...55084&LN=EN-US

"Chris Botha" wrote:

该机器正在运行带有所有最新服务包等的XP专业版。我必须访问Oracle数据库，以便安装Oracle客户端。我可以从Windows应用程序查询Oracle，没问题。使用完全相同的代码（复制
和粘贴）到Web应用程序中我收到以下错误尝试
检索错误ORA-01019的文本时出错。安全性我想，所以我在网站上使用模拟，然后aspnet_wp.exe在''什么''引用内存的''
指令处崩溃。内存可能无法读取

我认为安全性是这里的一个问题，ASP.NET用户或Internet Guest
帐户可能需要访问Oracle目录而我不要我们不知道在哪里。
任何帮助都将受到赞赏。

The machine is running XP Pro with all the latest service packs, etc. I must
access an Oracle database so I installed the Oracle client stuff. I can
query Oracle from a Windows app, no problem. Using the exact same code (copy
and paste) into a Web app I get the following error "Error while trying to
retrieve text for error ORA-01019". Security I thought, so I use
Impersonation on the Web site, then the aspnet_wp.exe crashes with "The
instruction at ''whatever'' referenced memory at ''whatever''. The memory could
not be read"

I guess security is one issue here, the ASP.NET user or Internet Guest
account may need access to an Oracle directory and I don''t know where.
Any help will be appreciated.

这篇关于Oracle Adventures的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！