Creating a new DSN record
 

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 plans.

Creating a new DSN Record:
 

1.

Click the ODBC icon on your home page control panel, and the list of available ODBC drivers will show.
 

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).  

4.

Click Create.