To create DSN
In order to use odbc driver in application we need to use dsn created for those odbc driver in our application.
- There are possibility of creating 3 types of dsn ie., user dsn, system dsn and file dsn
- Procedure to create dsn for odbc driver for oracle
Click add button and select Microsoft odbc for oracle and press finish
Now give the values
Data source name | oradsn |
Description | Use your own text(optional) |
User name | Scott |
Server | Optional for personal oracle/local host |
Then click ok ok
-