ms+sql+server+2000链接服务器位置,sql-server – SQL Server 2000 – 链接服务器

Download the MysqL ODBC driver from MysqL.com

Install MysqL ODBC driver on Server where sql Server resides -Double Click Windows Installer file and follow directions.

Create a DSN using the MysqL ODBC driver Start-> Settings -> Control Panel -> Administrative Tools -> Data Sources (ODBC) -Click

on the System DSN tab -Click Add -Select the MysqL ODBC Driver

-Click Finish On the Login Tab: -Type a descriptive name for your DSN. -Type the server name or IP Address into the Server text Box.

-Type the username needed to connect to the MysqL database into the user text Box. -Type the password needed to connect to the MysqL

database into the password text Box. -Select the database you’d like

to start in. On the Advance Tab: Under Flags 1: -Check Don’t Optimize

column width. -Check Return Matching Rows -Check Allow Big Results

-Check Use Compressed protocol -Check BIGINT columns to INT -Check Safe Under Flags 2: -Check Don’t Prompt Upon Connect -Check Ignore #

in Table Name Under Flags 3: -Check Return Table Names for

sqlDescribeCol -Check Disable Transactions Now Test your DSN by

Clicking the Test button

Create a Linked Server in SSMS for the MysqL database SSMS (sql Server Management Studio -> Expand Server Objects -Right Click Linked

Servers -> Select New Linked Server On the General Page: -Linked

Server: Type the Name for your Linked Server -Server Type: Select

Other Data Source -Provider: Select Microsoft OLE DB Provider for

ODBC Drivers -Product name: Type MysqLDatabase -Data Source: Type

the name of the DSN you created On The Security Page -Map a login to

the Remote User and provide the Remote Users Password -Click Add

under Local server login to remote server login mappings: -Select a

Local Login From the drop down Box -Type the name of the Remote User

-Type the password for the Remote User

Change the Properties of the Provider MSDAsql Expand Providers -> Right Click MSDAsql -> Select Properties -Enable Nested queries

-Enable Level zero only (this one’s the kicker) -Enable Allow inprocess -Enable Supports ‘Like’ operator

Change settings in sql Server Surface Area Configuration for Features -Enable OPENROWSET and OPENDATASOURCE support.

Change settings in sql Server Surface Area Configuration for Services and Connections -Enable Local and Remote connections via

TCP/IP and named pipes

Stop sql Server and sql Server Agent

Start sql Server and sql Server Agent