First, use Microsoft OLE DB Provider for ODBC link to MySQL
Install MySQL-driven ODBC driver MYODBC
1, for MySQL to establish an ODBC system data sources, such as: Select the database test, the data source name called
MyDSN
2, establish the link database
EXEC sp_addlinkedserver @server = ' mysqltest ', @srvproduct = ' MySQL ',
@provider = ' Msdasql ', @datasrc = ' MyDSN '
go
EXEC sp_addlinkedsrvlogin
@rmtsrvname = ' mysqltest ', @usesel
--
Script used to obtain the connection information of the SQL Server server (based on the original shard creation and writing)
Declare@ Dbname sysname,-- The name of the database to be queried (empty for all). The connection information of all databases is queried by default.@ Brief deip bit-- Whether to display the IP address (0 NO, 1 Yes). This control is added because the IP address query is time-consu
1. Stop the DNS service (Execute command in run: net stop DNS)
2, open regedit, find Hkey_local_machine\system\currentcontrolset\services\dns
3. Export this branch of DNS. Named Dns-1.reg
4, Find Hkey_local_machine\software\microsoft\windowsnt\currentversion\dnsserver
5, the DNSServer branch export, named Dns-2.reg
6, open%systemroot%\system32\dns\, all of which *.dns files copied out, and Dns-1.reg and Dns-2.reg saved together.
Back up the above and remember to turn on the DNS servi
The last time we introduced the DHCP server, this time to introduce you to the DHCP server backup, restore and transfer First, the backup and restore of DHCP Today's environment is: SERVER01 domain controller. SERVER02DHCP Server, server05 Client (user tests whether the DHCP server is working properly) Example: Backup
Varnish reverse proxy server introduction, varnish Proxy Server
First, we will introduce the cache system:Two logics for running the program: 1. run on a single host 2. run collaboratively on different hosts (1. transverse cut 2. vertical Cut ----> 1. only responsible for one level 2. server expansion: 1. up (scale up) 2. scale out: a business can be divided into
Article Related software:
Webalizer
http://www.mrunix.net/webalizer/
Cronolog
http://www.cronolog.org/
Apache
http://www.apache.org/
First, the preface
With the development of Web services on the Internet, almost every government department, company, University, Scientific Research Institute and so on are constructing or building their own websites. At the same time, in the construction of the site in various units will encounter a vari
Environment: Windows server R2+SP1, SQL Server R2, SharePoint Server 2013, front end server separate from database serverSteps:1. Resetting the administrator's password in the domain control2. Enter the following command in the SharePoint front-end server SharePoint Mangemen
Abstract In embedded development, there are two types of host machines: Host machines are computers that compile and link embedded software, and target machines are hardware platforms that run embedded software. As a host software, the TFTP server mainly provides download of the main image files of the target machine. Solution 1. Use the following command to install the TFTP server. You can see that the TFT
SQL Server uses scripts to create updatable subscriptions for distribution services and transaction replication, and SQL server scripts
[Create a local distributor]
/************************ [Use local distribution server configuration release ]******* */-- SqlServer 2008 R2 -- https://technet.microsoft.com/zh-cn/library/ms151860 (v = SQL .105 ). aspxuse masterg
1. Admin Server and Manager server memory allocation defect DescriptionWebLogic servers typically design one or more domains (domain) for each business system, and each domain service principal must consist of two types of server, admin server and manage server. Both types o
Network Time Protocol (NTP) is used to synchronize the system time of different hosts on the network. All hosts you manage can synchronize their time with a specified time server called an NTP server. On the other hand, an NTP server synchronizes its time with any public NTP server, or the
Save the following text as: windows2000-2003 server Security and Performance registry automatic configuration file. Reg runs
Copy Code code as follows:
Windows Registry Editor Version 5.00
[Hkey_current_user/software/microsoft/windows/currentversion/policies/explorer]
"NoRecentDocsMenu" =hex:01,00,00,00
"NoRecentDocsHistory" =hex:01,00,00,00
[Hkey_local_machine/software/microsoft/windows Nt/currentversion/winlogon]
"DontDisplayLast
How to use PHP to implement a dynamic Web server and a php dynamic web server. How to use PHP to implement a dynamic Web server. if a php dynamic web server is actually a web server, you need to understand the operating principle of the web
1. RDA Introduction2. Requirements and Configuration3. RDA object Method4. RDA sample code======================================1. RDA Introduction------------In Microsoft SQL Server 2005 mobile edition (SQL Server mobile ),Remote Data Access (RDA) allows applications to access data from remote SQL Server database tables,And store the data in the local SQL
PHP implementation of Server Status monitoring method, PHP implementation of server monitoring
This paper describes the method of implementing server state Monitoring by PHP. Share to everyone for your reference. The specific analysis is as follows:
PHP Server Status Monitoring for many friends do not do, only to see
Overview:
The difference between roles and functions
What can I do with Server Manager
Using wizards
Managing roles and features from the command line
One of the themes that runs through Windows Server 2008 is simplicity. This does not mean removing some functionality unnecessarily. Instead, this is a strategy to simplify and clarify roles and tools so that you can install only what you need, and not i
A. Change the terminal default port number
Steps:
1. Run regedit 2. [HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Terminal Server\wds \rdpwd\tds \tcp], see Portnamber value? The default value is 3389, modified to the desired port, such as 12345 3. [Hkey_local_machine\system\currentcontro1set\control\tenninal server\winstations\ RDP\TCP], Modify the value of PortNumber (default is 3389) to Port 1234
The big environment for this experiment is the DHCP server for Windows Server 2003, which is directly upgraded to Windows Server 2012, a solution that is more used in today's real-world production environments, and has previously done Server 2003-to-server 2012
: This article mainly introduces how to obtain the current url path and server path by PH (obtain the server path of the current path by url). If you are interested in the PHP Tutorial, refer to it. The following are some of the information. I hope to help you with the small knowledge of getting paths in php!
1, $ _ SERVER ["QUERY_STRING"] description: query st
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.