In order for successful interoperability of certain Council systems ODBC/DNC connectors are necessary.
The two main systems that Council require connectivity in this fashion are:
- Civica Authority
- Conquest
These DSN connectors allow for transmission of information between their respective back end data bases in order to be consumed by the destination system.
In order for these connectors to work they must first be configured using their respective odbcad.exe runtime which comes in both x86 (32 Bit) and x64 (64 Bit). The setup is identical apart from the .exe file you run to configure the DSN.
In order to configure these connectors, follow these steps:
ADDING X86 (32Bit) or X64 (64 Bit) Authority Connector
- 32 Bit - Open Folder C:\Windows\SysWOW64
- Find odbcad32.exe
- 64 Bit - Open Folder C:\Windows\System32
- Find odbcad32.exe
- Shift + Right click and choose "Run as Different User"
- login using ADMINISTRATOR
- Then navigate to the System DSN Tab and select ADD
Then in the Create New Data Source Window Select SQL Server and Select Finish
- Then complete Create New Data Source to SQL Server dialog as follows
- Then in the next screen just click next
- Then in the next screen check the Change the Default database to option and select the database wou are wanting to connect to in this instance authlive from the drop down. This could also be Conquest if we are setting up a DSN connector to the Conquest database.
- Do not change anything in the next screen just hit Finish
- In this screen ODBC Microsoft SQL Server Setup screen confirms the connection. Now to test the connection is active and working please click the Test Data Source button.
- You should now get a Test Results Screen letting you know the connectivity status SUCCESS or FAILURE
