Creating an ODBC data source

<< Click to Display Table of Contents >>

Navigation:  Technical Documentation > Administrator > Program Installation >

Creating an ODBC data source

Before installing Administrator, it is necessary to create 2 ODBC data sources to be able to connect to the database servers.

 

To do so, go to Task bar > Start Menu > Execute > Open: type odbcad32 and click on Ok3 to run the ODBC data sources administrator.

 

odbcad32

 

Select the "System DSN" tab, and then click on AddB.

 

Sources_Données

 

Select the “SQL Server” pilot, and then click on Finish.

 

AddB2

 

To create a new data source pointing to SQL Server, in the "Name" field, type the name of your ODBC data source. In the "Server" field, type the IP address of your database server.

 

ConfigureSetupRA

 

Tick the option “With SQL Server authentication using a login ID and password entered by the user” and then, in the "Login ID" field, type SYSADM. In the Password field, enter the password SYSADM.

 

Ecran5

 

If the default database is not ABC8 yet, open the combo box and select ABC8.

 

Ecran6

 

Click on FinishZ.

 

When your ODBC data source is created, click on “Test Data Source”.

 

Ecran8

 

Once the test has been successfully achieved, the following window appears. Then, click on OK.

 

Ecran9

 

Click on OK to end the ODBC data source creation.

 

To create a new ODBC data source, in order to be able to connect to the second database server containing the backup database, start the operation all over again without forgetting to use a different name to reference this data source.