Basically SQL Server As long as you're dealing with a lot of data , Such as INSERT INTO A SELECT * FROM B When there's a lot of data , It's easy to happen Timeout , That is, common 「 Overdue 」 error .
SQL Server For this machine Enterprise Manager It's easy to handle if it's implemented , Just change the settings .( Tools -> Options -> Advanced , Increase the timeout seconds ).
But most of it is in Remote Next SQL Command , Just a little bit more , such 「 Overdue 」 The probability of occurrence also increases .
The best solution is to increase SQL Server Remote Command Of Timeout Time , As long as SQL Queryer Inside down :
EXEC sp_configure 'remote query timeout', 6000
6000 It's the number of seconds , That is to say 6000 second (SQL Server The default is 600 second ,).
The other is to use external programs to deal with , But it may still be limited to SQL Server The limitation of , especially ADODB There are serious problems in this part Bug, See :
PRB: CommandTimeout Does Not Inherit From Connection Timeout
Program setting CommandTimeout Examples of processing :
Dim conn As New ADODB.Connection
conn.CommandTimeout = 600 ' second
conn.Execute("INSERT INTO A SELECT * FROM B")
conn = Nothing
It should be noted that ADODB 2.6 before ,CommandTimeout It can't be set to 0 ( Unlimited time ), If you have to use it , You have to use ADODB.Command, See :
FIX： Use Connection Object CommandTimout Attribute problem
- With the SQL Server A network related or instance specific error occurred while establishing the connection
stay visual studio When adding a database application to , Report errors , The tips are as follows : With the SQL Server A network related or instance specific error occurred while establishing the connection . Server not found or unreachable . Verify that the instance name is correct and SQL ...
- With the SQL Server A network related or instance specific error while establishing a connection
The customer has a problem , use “ Server name \ Instance name ” Remote connection to another named instance failed , newspaper “ With the SQL Server A network related or instance specific error while establishing a connection , Server not found or unreachable . Please verify that the instance name is correct ...
- SQL SERVER 2008 Cannot be called on control during installation Invoke or BeginInvoke error resolvent
perhaps SQL SERVER 2008 Restart required during installation , However, it is still required to restart after restart . You can use this method . Of the registry "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet ...
- And SQL Server A network related or instance specific error occurred while establishing the connection .
Today, my classmates asked me why the database could not be opened , open SQL Server 2008 Of SQL Server Management Studio, Input sa My password discovery , Can't log in to the database ? Here are some mistakes : " stay ...
- Use SQL Server 2014 Memory database need to pay attention to the place
author Wang Feng published in 2014 year 7 month 4 Japan From the perspective of product design and architecture, this article shares Microsoft Experience in using in memory database , I hope you can understand these new objects after reading this article . Concept , To better design your architecture . In-memory database , Refers to ...
- Restore or delete sql server 2008 Database time , It often comes out ： “ Because the database is in use , So you can't get exclusive access to the database ”, The final solution
Restore or delete sql server 2008 Database time , It often comes out : “ Because the database is in use , So you can't get exclusive access to the database ”, The final solution is as follows The key SQL sentence : ALTER DATABASE [dateba ...
- encounter sql server How to find out the problems of
The First Things I Look At On A SQL Server and Page2 It introduces how to meet sql server How to check the problem when solving the problem ,Display Code Lists sql Code . Includes the following ...
- Remote connection SqlServer The database prompts " With the SQL Server A network related or instance specific error occurred while establishing the connection " resolvent
Preface Because in my previous career , Whether it's a database or a development environment , It's all done by predecessors , Just use it yourself . I don't know that there will be all kinds of errors in the installation process . After contacting the server recently , All aspects of the development environment and configuration are installed from scratch to configuration ...
- Sql server On another server , stay Visual Studio No problem ,IIS in Tips “ With the SQL Server A network related or instance specific error occurred while establishing the connection ....”
Maybe question one : To be exact, it is in IIS 7.5 There's a problem with it Is in the visual studio It's all well used in the classroom , But loading into IIS I made a mistake when I was on the Internet “ With the SQL Server When establishing a connection, network related or real specific ...
---------2016-5-9 18:56:39-- source:OS.ENVIRON() Detailed explanation
- oracle Query database table space size and remaining space
dba_data_files: Database data file information table . You can count the table space size ( Total space size ). dba_free_space: You can count the size of the remaining table space . Adding a table space means adding data files to the table space , The table space size is the data file ...
- modelsim(2) - vcd (dump, see , Format understanding )
Two vcd dump because VCD It can be used for power analysis , So it needs to be dump come out . in addition VCD As a result , It can also be used as an incentive , But actually see less ! VCD yes verilog Standards for , So there are system functions $dumpvar ...
- 【HDOJ】4056 Draw a Mess
This problem is solved by using line segment tree MLE. The idea is reverse thinking , Then each segment is removed by using and searching the set , The average complexity is O(n*m). /* 4056 */ #include <iostream> #include &l ...
- ORM query language （OQL） Introduction advanced
ORM query language (OQL) brief introduction -- Advanced : Thoroughly remould oneself Before writing this article , I've been thinking about how to get the title of the article . In the writing <ORM query language (OQL) brief introduction -- Concept >.<ORM query language (OQL) brief introduction -- Case study ...
- Talk about Nancy What people love and hate Diagnostics【 Part 1 】
Preface stay Nancy There is a very good function in -Diagnostics, It can be said that this function makes people love and hate . Maybe we've all tried the following : Record the relevant technical information used in a function Record the visit records of the website Global configuration of certain boxes ...
- ABP From entry to mastery （6）： Quick rename solution
SolutionRenamer SolutionRenamer Is a solution quick rename tool . After testing, rename a brand new asp.net zero core project (ABP asp.net zero,.net c ...
- Fiddler Grab and modify WebSocket data , Support wss
Record it with Fiddler Yes WebSocket Send and receive data packet capture analysis and tamper with data , There's only one way , Just use it . Time :2019-3-29 Environmental Science : win7 + Fiddler 5.0 Fiddler Catch ...
- iptables Addition, deletion and modification of
iptables yes linux The firewall of the system , Powerful , It takes a while to learn , Here are some habits iptables A record of the time when I was a child . If iptables If you are not familiar with it, you can use apf, It's based on iptables The firewall of , ...
- One a day linux command ：scp command
scp yes secure copy Abbreviation , Used in Linux Under the command to copy files remotely , Similar orders are cp, however cp It's just that copying on the local machine can't cross servers , and scp The transmission is encrypted . It may affect the speed a little . When you're on the server ...