RMP Resource - ODBC Setup
Microsoft's Open Database Connectivity (ODBC) application programming Interface
(API) was one of the first members of the Windows Open Services API (WOSA) to be
released as a commercial product. The ODBC API consist of Windows dynamic link libraries
(DLLs) that include sets of functions to provide services for all database type
for which ODBC drivers are available.
- Installing, setting up, and removing ODBC data source. A
data source is a named connection to a database. know as data source name (DSN).
ODBC uses the odbcinst.dll library to set up and remove data sources. Odbcad32.exe
is a standalone, executable application (ODBC Administrator) for setting up ODBC
data source.
- Managing the communication of quires and other SQL statement
from client ends to databases back ends and the transfer query result sets or confirmation
of the execution of action queries (INSERT, UPDATE and DELETE queries) in the reserve
direction.
32-bit Odbcad32.exe creates or deletes entries in the two ODBC initialization files
in \Windows folder and the registry. There are 3 types of DSN available.
- User DSN are specific to the individual logged on
to the server or workstation. DSN information is located in the HKEY_CURRENT_USER
registry path.
- System DSN are available to all workstation
users and , when installed on the server, are accessible by all server-side applications.
DSN data appears in the HKEY_LOCAL_MACHINE path.
- File DSN (filename.dsn) are text file defining a
DSN. File DSNs may be stored locally or on a networks share. File DSN don't use
registry entries. File DSN are ODBC's equivalent to ADO's data Link files (filename.udl)
Follow this step to create File DSN for SQL Server.
STEP 1 : Type Odbcad32.exe in run menu
and click OK.
STEP 2 : Click on file DSN Tab in ODBC Data
source administration.
STEP 3: Click Add.. button and select SQL Server
from list available data source
STEP 4: Click Next and type the file DSN name.
STEP 5: Click Next and click Finish,
it shows the newly created DSN details.
.
STEP 6: Type or Select the MS SQL server name
and click Next.
STEP 7: Select the SQL server authentication mode
as per security setting. and click on Next button.
STEP 8: Change the default database to your
database. and click Next.
STEP 9: Click Finish to complete the process.
STEP 10: It will show you the newly created data source
name (DSN) property, click Test Data Source to check whether it creates properly
or not.
