ODBC - Open DataBase Connectivity is a standard database access method developed by Microsoft Corporation. ODBC makes it possible to access any data from any application by means of ODBC drivers - one for each database format. You can create DSN (Date Source Name) records based on ODBC drivers to access databases of different formats under Windows plan. free killing me softly clip

• Creating a new DSN record
• Editing DSN records
• Deleting DSN records

 free killing me softly clip

Creating a new DSN Recordfree killing me softly clip

To create a new DSN Record, do the following:free killing me softly clip

1. Select ODBC Service in the ODBC menu, and the list of available ODBC drivers will show.

free killing me softly clip

2. Click the Add icon next to the DB driver you need.
3. Fill the form that appears. Forms are different depending on the DSN type:
• Enter the second part of your full DSN name in the DSN field. Note: The first part of your full DSN name is your Windows login. In the applications/scripts you run on your server, you must use the full DSN name, e.g. testvi0-mydatabase as in the below example.
• Directories and file names must include paths relative to your home dir root, (the SourceDB field should include the name of the database and the extension).

free killing me softly clip

4. Click Create.

 free killing me softly clip

Editing DSN Recordsfree killing me softly clip

Here you will learn how to edit your DSN records.

Note: For more details on each driver's parameters, please refer to the driver specification. E.g. you can find all information about MS SQL DSN configuration on the Microsoft Web Site at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbcsql/od_odbc_c_99yd.asp. free killing me softly clip

To edit DSN records, do the following:free killing me softly clip

1. Select ODBC Service in the ODBC menu.
2. On the page that shows, in the Your DSN section, click the Edit icon next to the DSN record you need.

free killing me softly clip

3. Edit the DSN records in the form that appears.
4. Click Update

 free killing me softly clip

Deleting DSN Recordsfree killing me softly clip

To delete a DSN record, do the following:free killing me softly clip

1. Select ODBC Service in the ODBC menu. This will open a page similar to the one above
2. In the Your DSN section, click the Delete icon next to the existing DSN.