|Summary||This article describes how to create ODBC drivers on the CCA server|
|Written for||System administrators|
|Keywords||odbc; ado; connection string; sql; access; ms access; dsn; askiafield ; cca; supervisor ; sample list; 64bit ; 32bit|
When creating sample lists with Supervisor, you have two possibilities to import the sample list data. Either from a .lst file, or from an External database.
If you chose the latter, an "External Data Details" menu will be prompted. In this menu, a prompt will ask which SQL Database shall be used.
Sometimes, the desired database is not listed. This usually happens when CCA cannot find the matching ODBC driver, which can happen on a 64-bit machine, if the ODBC drivers have been created as 32-bit drivers, while CCA was launched as a 64-bit application, or vice versa. To resolve things:
- Connect to the machine that is hosting CCA.
- If CCA is running as a 32bit application, navigate to C:\Windows\SysWOW64\odbcad32.exe.
If CCA is running as a 64bit application, navigate to C:\Windows\System32\odbcad32.exe
- Create the ODBC driver.
- It will now appear in the dropdown list of Supervisor.