Filter
Top Products
8
- 7
8.2 Setting ODBC to the Database
8
DB CONNECTION SERVICE AND SETTING TOOL
(From the previous page)
3 Double clicking [Data Sources (ODBC)] displays
[ODBC Data Source Administrator] dialog box.
*4*5
Select the [System DSN] tab, then click the
button.
*4 For use of the 64-bit version of Oracle, install the 32-bit
version of Oracle Client and then start the "ODBC Data
Source Administrator".
*5 For use of a 64-bit version operating system, type the
following at the command prompt to start the "ODBC Data
Source Administrator".
%SystemRoot%\SysWOW64\odbcad32.exe
4 The [Create New Data Source] dialog box is
displayed, then select [Oracle in OraHome92].
5 The [Oracle ODBC Driver Configuration] dialog
box is displayed, then set the following.
• [Data source name]: SAMPLEDS
• [TNS Service Name]: SAMPLETNS
• Enable Closing Cursors: Select the checkbox.
6 Clicking the button displays the
[Oracle ODBC Driver Connect] dialog box. Enter
the user name and password, then click the
button.
7 If the connection is normal, the confirmation dialog
box appears.
8 Click the button in the [Oracle ODBC
Driver Configuration] dialog box.
9 Click the button in the [ODBC Data
Source Administrator] dialog box.
(End)
Add
Connection test
OK
OK
OK