Use Oracle 6 from ASP.NET application

Use Oracle 6 from ASP.NET application

把回忆走一遍 发布于 2021-11-24 字数 645 浏览 806 回复 3 原文

I have an ASP.NET 2.0 web application. It uses "System.Data.OracleClient, Version=" to access an oracle database.
I get the following exception on connection:
System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
I looked it up and found several articles/posts that say that the error is misleading and it is caused by some security issues of ASP.NET user trying to access oracle HOME folder.
However in my case my client's oracle client is indeed older that 8.1.7. In fact it is version 6! I know this is very old but you understand that this cannot change.
What other alternatives do I have?

如果你对这篇文章有疑问,欢迎到本站 社区 发帖提问或使用手Q扫描下方二维码加群参与讨论,获取更多帮助。



需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。


夜雨飘雪 2022-06-07 3 楼

You can try to install a more recent version of Oracle which is supported by .Net, and CREATE a DATABASE LINK to your current installation.

允世 2022-06-07 2 楼

Find another job? Seriously, version 6?!

I think you'd be better off recommending converting to MySQL (it's free). This is just one example of why your software should at least be from the current decade. You're just not going to find software that supports stuff that old. Your client is going to find it harder and harder to get people who know anything about it (or want to), and they'll pay more and more for it. How much are they going to spend trying to solve this problem? What about the next one? I think you owe it to your client to make a very strong case to upgrade somehow.

Good luck...

野鹿林 2022-06-07 1 楼

You might be confusing the Oracle Forms version numbering with the Oracle Database Server numbering. Oracle server version 6 was released back in '88 and I doubt that it would run under any current OS. Oracle Forms 6.0 was more recent (maybe ten years old) and runs quite happily on Windows XP as I recall.

That said, Forms 6.0 would have used the SQL*net 8.0 client which would still give the problem. If you type tnsping on the command line, that might give you a version number.

You can download a (free) InstantClient from the oracle web site. This can be unzipped on the same machine as another Oracle client. You may have to play a bit with path settings to make sure that the correct client is picked up by the .Net