SQL Server
The following shows the setting example of ODBC setting in the environment written below.
Item
Operating system
Relational database
*1
Data source name
*2
Server name
*1 A data source name can be set arbitrary.
The name set above is used in the "Data Source Name" in the "Target Server Individual Settings" on the "Target Server Settings".
*2 The server name is for accessing to the database of Microsoft SQL Server 2012.
It is the one entered when installing Microsoft SQL Server 2012.
It can be checked in SQL Sever Management Studio.
Description
Microsoft Windows 7 Professional Operating System
Microsoft SQL Server 2012
SAMPLE
SAMPLESRV
1.
Start the ODBC Data Source Administrator.
Page 101 To start the ODBC Data Source Administrator
2.
Select the [System DSN] tab and click the [Add] button.
3.
Select "SQL Server Native Client 11.0", and click the
[Finish] button.
4.
Set the following items and click the [Next] button.
• Data source name: SAMPLE
• Server name: SAMPLESRV
5.
Select "With SQL Server authentication using a login ID
and password entered by the user.", enter the login ID
and password, and click the [Next] button.
6.
Click the [Next] button.
APPX
103
Appendix 2 ODBC Setting
A