Creating an ODBC connection manually.

Foreword: This example uses the Microsoft Access database, but with ODBC you can connect to any existing database that has an ODBC driver installed on your computer.

1. In case there is none, create an empty database for MS Access, with extension .MDB (Office 2003 or lower) or .ACCDB (Office 2007 or higher), and save in a directory of your choice.

2. Open the Control Panel.

3. Open the Administrative Tools option.

4. Open the item Data Source ODBC. The ODBC Data Source Administrator will then open. On tab System DSN, click Add to add a new ODBC connection.

5. A window will open. On it, select the MS Access driver installed on your machine and click Finish.

6. The next step is setting up the connection:

a. In Data Source Name, write the name you want to call your ODBC connection;
b. In Description, enter a description;
c. In Select button, select the directory and file of the database previously created (dbTeste.mdb). If you do not have a database and want to create one now, click Create;
d. Click OK.

7. Now you have already configured your OBDC connection and can access it either via Elipse SCADA or Elipse E3.

Note (1): Elipse E3 has NATIVE access to Oracle, Microsoft SQL Server, and Microsoft Access databases. Therefore, for these banks, it will not be necessary to create an ODBC connection.

Note (2): this article does not go into further details on how to use ODBC connections inside SCADA and E3.

Leave a Reply Cancel reply