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.
