8 - 8
8.2 Setting ODBC to the Database
8
DB CONNECTION SERVICE AND SETTING TOOL
(4) For Microsoft
®
SQL Server
®
, MSDE 2000, and Wonderware
®
Historian 9.0
(The following shows a setting example using Microsoft
®
SQL Server
®
2012 with
Microsoft
®
Windows
®
7 Professional Operating System.)
Set the following conditions.
• Data source name
*1
: SAMPLE
• Server name
*2
: SAMPLESRV
*1 Data source name can be set as desired.
For [Data source name] in [Server service settings], use the name set with this setting.
*2 The server name is the name for accessing a Microsoft
®
SQL Server
®
2012 database.
This name is entered when installing Microsoft
®
SQL Server
®
2012.
This can be checked with the SQL Server service manager server.
(Start)
1 Start the ODBC Data Source Administrator.
1 Section 8.2 (2) To start the ODBC Data
Source Administrator
2 Select the [System DSN] tab and click the
button.
3 Select "SQL Server Native Client 11.0", and
click the button.
(To the next page)
Finish
To Next Page
Loading...
