Tag Archives: The server

SQL 2005 remote connection error (provider: SQL network interface, error: 28 – the server does not support the requested protocol

Solution: On the server side: Open SQL2005 SQL Server Management Studio program
(1) to connect to the database,
(2) trying to choose the registered under the menu Server
if there are no things out of the window, to update the local Server database engine right click on the select register
(3) on the local hope remote access database, right click on the select SQL Server configuration manager
(4) in the window, Select SQL Server 2005 network configuration in the left tree, select the appropriate database in the sub-set,
(5) and right click on TCP/IP in the right protocol to enable it
I followed this method to do first, and then found that it was still unable to connect to the server, finally use the following method to solve: start — “program –” Microsoft SQL Server 2005–& GT; SQL Server 2005 Peripheral Application Configurator select “Peripheral Application Configurator for Services and Connections” in this SQL server instance select Database Engine -& GT; For remote connections, select both TCP/IP and Named Pipes in the box on the right for local and remote connections

socket error 10035

The server got stuck when I was doing the test yesterday. I found that the server did not return the message when it called the send function. As a result, the thread of message processing was stuck there.
Based on the online data, I can probably tell that either the sender is out of cache or the receiver is out of cache.
And my socket is not set to non-blocking mode, so it’s stuck here with no return.
 
The solution is to change the socket to non-blocking mode

 
In this way, if the send fails, it can return immediately, and the server won’t be stuck there.
At this time, if the send is unsuccessful, the return value of the send is error 10035.
 
Then I checked the test client and realized that my client did not receive at all.
That’s weird.

Version problem of SQL Server


Recently, SQL Server 2005 has been installed on the computer. It works normally on this computer. Everything is OK.

When connected to the server operation Database, however, you Unspecified error when creating the table:

The details of the error are as follows:

===================================


Unspecified error
 (MS Visual Database Tools)


------------------------------
Program Location:


   at Microsoft.VisualStudio.DataTools.Interop.IDTTableDesignerFactory.NewTable(Object dsRef, Object pServiceProvider)
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.TableDesignerNode.CreateDesigner(IDTDocToolFactoryProvider factoryProvider, IVsDataConnection dataConnection)
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDataDesignerNode.CreateDesigner()
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDataDesignerNode.Open()
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VirtualProject.Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ISqlVirtualProject.CreateDesigner(Urn origUrn, DocumentType editorType, DocumentOptions aeOptions, IManagedConnection con)
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ISqlVirtualProject.CreateDesigner(Urn origUrn, DocumentType editorType, DocumentOptions aeOptions, IManagedConnection con)
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ScriptFactory.CreateDesigner(DocumentType editorType, DocumentOptions aeOptions, Urn parentUrn, IManagedConnection mc)
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDocumentMenuItem.CreateDesignerWindow(IManagedConnection mc, DocumentOptions options)

=========================================

checked on the Internet, the original problem was between SQL Server versions: SQL Server 2005 Management Studio could not operate SQL Server 2008, so this error occurred.

The solution is to replace 2005 with 2008.

“Permission denied” error in Oracle10g installation

Reason: Before the software was uploaded to the Linux server, it was unzipped and then uploaded in the Windows environment. When it was uploaded, it was already the folder after decompression, so the execution permission of those three files was lost.
Solutions:
1, enter database folder
2, chmod 755 runInstaller(grant permissions)
3, enter install LLL a(view files)
4, chmod 755. Oui (solve install/. Oui this hidden file does not have permissions to execute)
5, chmod 755 unzip(solve unzip permissions)
6, then execute in the Database folder./runInstaller

Solution to msxml3.dll error ‘800c0008’ the system cannot locate the resource specified

msxml3.dll ?펳 ‘800 c0005’

The system always locate The resource specified.

/plugins. Asp??А 165

this is usually used when collecting information or statically updating a web page with XMLHTTP, and I’ve used similar errors before

set objXmlHttp = server.createobject (” microsoft.xmlhttp “) ‘is generally used in versions below msxml2.6

‘ set objXmlHttp = server.createobject (” msxml2.xmlhttp “) ‘supported by msxml3.dll+

is used instead of
, but now every error is reported.

has searched all the technical forums and search engines I know on the Internet, and there may be a variety of situations that could cause such a problem. Here is a summary:

(a) that is the most basic, your server does not support XMLHTTP or component version low, you need to download the corresponding component. This is not required by the average server, and XMLHTTP is supported in most cases, so this is a rare case.

(2) msxml3.dll file may be corrupted or the file is not authorized enough (this case is less likely), if the file is corrupted, you can download the corresponding system environment’s msxml3.dll file to replace (2003 system seems to be under c:// Windows /system32), need to close the corresponding service such as iis and so on to overwrite.

(three) fireproof or anti-virus software has disabled the corresponding port, the specific how to set it depends on different software, you can try to close the firewall or anti-virus software and then test to determine whether it is the problem.

(4) try re-registering the component. Start & gt; > Run: RegsvR32 MSxml3.DLL

(5) DNS resolution error, check your network Settings or correct DNS access

(6) check your IP filter Settings (this is not very clear)

(7) resource failure of the other party. For example, when collecting some information, the other party does not have the error that leads to program termination, which may also be the case. This error occurs when the XMLHTTP component’s Open method is called, followed by the Send method. An 8000005 error occurs when the URL parameter of the open method is not accessible. And if such an error occurs, the application terminates and cannot continue. Most programs are written like this:

Function functionName(pararm …)

Dim Http

= Set Http Server. CreateObject (” MSXML2. XMLHTTP. 4.0 “)

With Http

.open “GET”,HttpUrl,False

.Send

End With

If Http.Readystate< > 4 then

Set Http=Nothing

……

Exit function

End if

End Function

most programs use the XMLHTTP Readystate property to determine the return status from the server. This is not always the case, and many times using the ReadyState property does not actually detect errors in the program flow. When an error is encountered, the program will still be terminated. In fact, modify the above code, it is possible to achieve the process of skipping the execution of the program encountered errors, so that the program continues to run. The modified code is as follows:

Function functionName(pararm …)

Dim Http

= Set Http Server. CreateObject (” MSXML2. XMLHTTP. 4.0 “)

With Http

.open “GET”,HttpUrl,False

.Send

End With

On Error Resume Next

If Http.Status< > 200 then

Set Http=Nothing

……

Exit function

End if

End Function
When the
Send method produces an error, the ReadyState value may be 4, but the Status value must not be 200. Well, I’ve tracked ReadyState and Status’s worth to previous results many times. There may be mistakes. I haven’t found them so far.

hope the above program solution can help you!! If you have a better solution, please let me know.

, which I illustrate with msxml2.xmlhttp.4.0, is also suitable for other versions of the XMLHTTP component. To check which versions of the XMLHTTP component you have installed on your system, look under HKEY_CLASSES_ROOT in the registry.

(8) go to the server and set your IE security options (try setting the level to medium or low). Just add the domain name you want in the trusted website.

(9) I have tried all of the above methods after looking at them, but none of them worked out. So I went to Microsoft and downloaded MSXML4.0 Service Pack 2 (Microsoft XML Core Services) and Hotfix for MSXML4.0 Service Pack 2 – KB832414 – Simplified Chinese (KB832414_MSxml4.0_x86.exe) and installed it. The problem was finally solved!!

(10) if your case, I can solve the above methods, it is back, you continue to look for other possible to online, if you don’t want to continue to find you reinstall your iis or simply reshipment system (do this before you can try to restart the system to see, may probably as if lucky can use again

Windows encountered 1152 when installing software: error extracting files to the temporary location

Today met 1152: when installing the software Error extracting files to the temporary location Error. There are not too many relevant methods on Baidu. After solving the problem, I will sort out the methods to solve the problem. Hope to be of help to a friend who has the same problem.

if some “bad” temporary files are extracted from previous failed installations, the error of extracting the files to a temporary location usually occurs. Clean that folder and try again is the right way. This means that if you unzip a file into the same folder over and over again, it could cause problems, or corrupted files in the Windows temporary folder could be the problem. What you can do is :
1. Clear Windows temporary folder
2. Clear extract folder or use other location
3. Check folder permissions
4. Clear failed boot of program installation.
First, clear the Windows temporary folder

Windows provides a built-in tool to clean up temporary storage. You can use it to remove all bad or corrupted files that could have prevented the extraction of these files. Any installer can use the Windows temporary folder, so you’ll find lots of files in that location. Storage sense will clear other folders along with a temporary folder, but you can choose which one to clear last.
enter setting > System & gt; Storage & gt; Configure storage awareness or run immediately. If your storage space is low, this tool will also fix the problem.
can delete everything in the Windows temporary folder directly, but if any files are locked, they will not be deleted. Storage sense or disk cleanup tool or any other garbage file cleanup application will ensure that the problem is overridden.
Clear the extract folder or use another location
If you are unzipping the ZIP file into another folder and are receiving the same error, it is best to delete everything in it. Sometimes damage can result if the previous installation is not completed. You can also use different locations to extract the file and see if it works.
if it is possible that the temporary file location already has a bad copy from a previous installation, it is a good idea to redownload the program and try it.
Three, check the folder permissions

you will not be able to extract files into this folder when you temporarily lose access to it. If for some reason you lose access to the folder you are unzipping, it will fail. So here’s what you should do :
• right-click folder > Property
• switch to the Security TAB and check if you are listed under the user group. Select your username and check to see if you have read, write, and execute permissions.
• click the edit button, suggest removing all permissions, and then add again. It will make sure you get the right permissions in the end.
once completed, manually copy the file to the folder and delete the file to check if it is working.
Four, clear the program installation failed boot
If all else fails, the last resort is to use a clean boat. If the problem is caused by something other than storage space or a corrupted temporary file, it will be fixed here.

Vsftpd: 500 oops: vsftpd: refusing to run with writable root inside chroot() error

This error is often encountered when using the user to log in to FTP after we have restricted the user from jumping out of his/her home directory:
 

500 OOPS: vsftpd: refusing to run with writable root inside chroot ()

 
This problem occurs in the latest update due to the following update:
 

- Add stronger checks for the configuration error of running with a writeable root directory inside a chroot(). This may bite people who carelessly turned on chroot_local_user but such is life.

 
Since 2.3.5, VSFTPD has enhanced security checks so that if a user is restricted to his or her home directory, the user’s home directory can no longer have write permissions! If the check finds that write permissions are still available, the error is reported.
To fix this error, remove write permissions from the user’s home directory with the command chmod A-w /home/user, and replace the directory with your own. Or you can add one of the following two items to the VSFTPD profile:
allow_writeable_chroot=YES

Notes on flex RSL application

FLEX publishing size is known to every FLEX developer as

because when FLEX is published it comes with a frame file that contains all the FLEX built-in classes…
the file size is about 500 K, so it’s an empty FLEX project. There are over 500 K

so FLEX provides the RSL(runtime Shared library).
lets the user download the same version of the frame file only once and store it in the cache directory specified by FlashPlayer.
the next time you browse the FLEX project that applies the RSL, you do not need to download again.. Thus speeding up the loading speed.

… Theories don’t express much… Something like this… Let’s actually do it…

to apply RSL, we perform the following steps :
1. Right-click in the project folder, and select “properties”-“Flex BuildPath”-“Library Path”
2. On the TAB, we see “FrameWork Linkage “. By default, “Merged into Cdoe “is selected. 3. Click “runtime Shared library(RSL)”, click “OK”

so that our project is already using the RSL~ to separate the frame files…
let’s open the bin(bin-debug) folder of our project.
will see that we have generated framework_3.0.0.477. SWF and framework_3.0.0.477. SWZ two files (0,0,447 is the version number). Has become around 50k (only two or three components)

when we publish the project..
just need to framework_3.0.0.477. SWF and framework_3.0.0.477. SWZ
and project SWF in the same directory to the server…

ps: here to talk about two noteworthy problems..

the first one is RSL error after the release of the project.. There are two main reasons :
1. Using FLASH PLAYER less than version 9.0.115,
2. Framework_3.0.0.477. SWF and framework_3.0.0.477. SWZ did not upload to the server.. So that the library cannot be downloaded…

say the second question before.. First introduce the framework_3.0.0.477. SWF and framework_3.0.0.477. SWZ,
where framework_3.0.0.477. When the load is successful.. It will be placed in the Flash Player cache directory.
while framework_3.0.0.477. SWZ download failed.. Flashplayer will automatically download framework_3.0.0.477.swf. The file can only be downloaded to ie cache..

very much from friends reflection.. While browsing locally.. Framework_3.0.0.477. SWZ can be loaded into the player’s cache directory.
but when placed on the server.. That will load unsuccessful.. Can only run by loading SWF..

occurs in this case.. Because server IIS does not support SWZ suffix file download..
(this has happened before before FLV was not prevalent),
if it is your own server. All we need to do is configure IIS. Add a MIME type…

detail operation will not say.. The MIME type is as follows..

Solution to Dell server system halted

A company server from Dell1950,
xeon@5130
,2G memory, 146*2 SAS hard disk, reinstalled system, dosa boot, PCI error, prompt:

PCIe Degraded Link Width Error:
Embedded I/O Bridge Device6
Excepted Link Width Is X4
Actual Link Width Is X1
System Halted! , and is not into the BIOS.
it indicates that the internal bandwidth requirement is x4, but it is actually x1 at the moment. There are several ways: 1. You need to reset the BIOS to see, or just restore the BIOS default.
2: Try unplugging all peripherals PCI
3: Take off the motherboard battery before entering the BIOS
I used the third method to solve the problem that had been bothering me all day, without making any mistakes, and successfully installed the system. Also tell me a little bit of experience, think more before doing more hands, I think problems like similar problems such as server solution will be faster.

The original reference: http://blog.sina.com.cn/s/blog_4c2401cb0100a6pv.html