[Dbnetlib] [connectionopen (preloginhandshake ().] for general network errors, check the network documentation.

"/" Indicates a server error in the application. [Dbnetlib] [connectionopen (preloginhandshake ().] A general network error occurs. Check the network documentation. Note: An unhandled exception occurs during the execution of the current Web request. Check the stack trace information for details about the error and the source of the error in the code.

Exception details: system. Data. oledb. oledbexception: [dbnetlib] [connectionopen (preloginhandshake ().] General network error. Check the network documentation.

The following is a solution provided by Tsinghua Xiaofei. This error can be effectively solved through the test of IT Information Network!

Microsoft ole db provider for SQL Server (0x80004005)
[Dbnetlib] [connectionopen (preloginhandshake ().] A general network error occurs. Check the network documentation.

My ASP running environment: the operating system is Windows XP SP2, the IIS version is 5.1 by default, and the database is SQL Server 2005 (MDAC version is 2.8)

1. A general network error occurs in "Microsoft ole db provider for SQL Server (0x80004005) [dbnetlib] [connectionopen (preloginhandshake. Check the network documentation ." Error

When learning ASP, in my database connection function, the connection source data source is always set with the machine name, after changing the Connection source data source to the local IP address 127.0.0.1, "Microsoft ole db provider for SQL Server (0x80004005) [dbnetlib] [connectionopen (preloginhandshake ().] A general network error occurs. Check the network documentation ." This error occurs.

2. Fixed a general network error in "Microsoft ole db provider for SQL Server (0x80004005) [dbnetlib] [connectionopen (preloginhandshake. Check the network documentation ." Error

1. Run CMD and Ping 127.0.0.1.

2. Telnet 127.0.0.1 1433, failed. When the server starts the SQL Server service, it indicates that the server has not enabled the TCP/IP protocol.

3. Open the configuration tool SQL Server Configure Manager in SQL Server 2005.

Enable Named Pipe and TCP/IP protocol

Restart SQL Server (MSSQLServer)

4. Access the ASP page again without the general network error "Microsoft ole db provider for SQL Server (0x80004005) [dbnetlib] [connectionopen (preloginhandshake. Check the network documentation ." Error. Everything is normal.

Telnet can also enable the connection.

 

Microsoft ole db provider for SQL Server (0x80004005) [dbnetlib] [connectionopen (preloginhandshake ().] A general network error occurs. Check the network documentation ." Perfect solution to errors