TNS error when connecting ASP to Oracle

Author：Eve Cole Update Time：2009-06-24 17:25:38

The operating system is Windows 2000 sp4

installed with IIS5.0 and Oracle 8i.

Symptoms: I can connect to the database using Oracle's own tools, and everything operates normally.

Using ASP's ADODB and MSADORA to connect to the oracle database prompts a TNS error or the TNS adapter cannot work.

But the program using VB will work.

It was not until later that I suspected that the IIS user did not have enough permissions. During the check, I found that the user name did not match the machine name. It turned out that the machine had been renamed.

So I changed it to a name that matches the current machine name, and everything passed~~

About asp.net HttpUtility.UrlDecode decoding problem
2013-03-21
Collection of frequently asked questions in the process of switching from ASP to ASP.NET
2011-04-26
Using object-oriented method to encapsulate cookie operation in ASP
2011-04-26
Shared code folders in ASP.NET sites
2011-04-26
Using ASP to call COM components written in C#
2011-04-26
Summary of asp.net user controls and custom controls
2011-04-26
Confusion among asp programmers when using server controls in asp.net
2011-04-26
Using tracking functionality in asp.net
2011-04-26
How to automatically generate name pinyin in asp.net program
2010-07-14
How does the asp.net marquee read pictures from the folder and how to implement it?
2010-07-12
How can I maintain the security of an ASP website? What details should I pay attention to or are there any techniques?
2010-07-12
Asp.Net 4.0 SEO enhanced UrlRouting
2010-05-26