Navigation:  Data Source Configuration > Pervasive SQL >

EDL Product Supporthome

ODBC Connections

Previous pageReturn to chapter overviewNext page

Setting Up An ODBC Connection

 

ExWeb can connect to multiple Exchequer Pervasive companies. Each company must have a separate ODBC connection setup.

 

To setup up ODBC, click on the ODBC Setup button on the main ExWeb toolbar:-

 

clip0089

 

The ODBC Administrator control panel opens.

 

clip0003

Select the 'System DSN' Tab:-

 

clip0004

The select 'ADD'

 

clip0005

Choose the 'Pervasive ODBC Client Interface' then click 'Finish'

 

clip0006

Give the 'Data Source Name' a unique name:

 

clip0007

The fill in the server name/ipaddress. This can be 'LocalHost' If this is the Pervasive server, or the Hostname of the Pervasive server or the IP Address.

 

clip0009

Next, click the 'get DSN List' button to enumerate the Pervasive database objects.

 

clip0010

Select the Pervasive database from the list:

 

clip0011

Click 'OK' and that is it. You now need to configure ODBC within ExWeb