64-bit Win7 ASP. NET project Connection Oracle times ORA-6413: No connection Open exception

At that time, the younger brother encountered this problem, also looked for a long answer, but the answer is ambiguous because () of the problem, but did not give a specific solution, here the younger brother with a relatively stupid method to solve the problem.

The first: the use of a local iisweb server, as shown in:

，

However, I do not know whether it is my vs reason or itself vs there is this problem. After I set this up, I did not have a problem when I connected to the database, but when I wanted to do F5 debugging, there was "no more startup debugging on the Web server" as shown in:

Also, debugging methods that use attach to process cannot be implemented. This way, although the database can be accessed, but can not debug this is not the way, so I chose the second method.

The second: As many great gods say, there is a problem with the path (), but my system does not exist in the VS installation directory, the Oracle client directory, the project directory, and so on. Finally, in a great God's article found the answer: Because the VS start debugging mode, will call C:\Program Files (x86) \common Files\Microsoft shared\devserver\10.0 this address, And because it is 64 for the system, so there is a "(x86)" This parenthesis, the cause of the problem found. So here's the workaround:

1. VS when debugging, the call is WebDev.WebServer.exe this execution program (if the computer has the. NET Framework 4.0), the name of the executable file is WebDev.WebServer40.exe

2. Enter the WebDev.WebServer40.exe address, which is the "C:\Program Files (x86) \common Files\Microsoft shared\devserver\10.0" written above, At this point we need to change this address, copy the contents of the 10.0 folder, copied to the place without parentheses, such as d:\1 below

3. At this point, we have to be able to access the Oracle database, but also to debug. So we're going to create the Web server ourselves, then what? is to create a debugger server through WebDev.WebServer.exe.

4. Method of Creation: (1): Enter cmd mode, (2): Go to the place where we copy the 10.0 files, (3): Execute the following statement Webdev.webserver/port: Port number/path: Project location/vpath: "/", enter run ( Webdev.webserver is the debug EXE file, if there are 40, you need to webdev.webserver40 ...), as my statement is this: Webdev.webserver40/port:8899/path: "E:\ Myproject\gpsclient\forecaststationmanager_jquery\forecaststationmanager "/vpath:"/"(The file address is best located in the directory of the SLn file, So vpath just set/)

5. The VS debugger is created in the taskbar, as shown in:

, and the same effect as before, directly pressing F5.

6. At this point, we are going to set up our web project, right-click Web Project, Properties---Web tab, select "Use custom Web Server", set the server Url:http://localhost: Set the port number/as shown in:

　　　

7. OK, this is done, press F5 to debug the time, did not appear: The connection is not open problems, there is no debugging problems. Euler.

Defects of this method:

(1): This is a stupid method, but the younger brother did not find other solutions to solve my problem, and so on.

(2): It is troublesome to open a custom Web server every time before debugging or running the project, so you can make the custom Web server into a bat execution program.

Well, the blog has been written here, you God if there is any better way, please contact me ah ...

[Email protected], this is my mailbox, please the gods to take me to take me to fly

64-bit Win7 ASP. NET project Connection Oracle times ORA-6413: No connection Open exception