Admin-Ahead Community

Windows => Control Panels => WebsitePanel => Topic started by: Leo.Prince on November 03, 2013, 08:36:37 pm

Title: How to create new ODBC driver from website panel
Post by: Leo.Prince on November 03, 2013, 08:36:37 pm
Hi,

ODBC drivers (Open Database Connectivity) is a standard programming language middleware application programming interface (API) for accessing database management systems (DBMS). By using ODBC drivers, developer can program the software or application independently with respect to the current database system and operating system. The main advantage is that the program will be easy portable and can be work out from another machine with less changes in the data access code.

In order to create ODBC drivers from website panel, You can follow these steps

1, Login to websitepanel

2) Select Databases >> ODBC DSNs

3) You will view a page with the title – ODBC Data Sources

(http://blog.arvixe.com/wp-content/uploads/2013/09/Figure_1_DSN.png)

4) Select ODBC Data DSN button

5) You will view a page with the caption – ODBC DSN Properties

6) Provide a data source name and select an appropriate ODBC driver.

(http://blog.arvixe.com/wp-content/uploads/2013/09/Figure_2_DSN.png)

7) As soon as you select a driver name, the relevant options will be displayed on the screen. For instance, if you select SQL Server, you will be able to view options for selecting database name and user.

(http://blog.arvixe.com/wp-content/uploads/2013/09/Figure_3_DSN-300x222.png)

8 ) Click "save". Done...!!!  8)

Thanks  8)