Changing/Setting ODBC Connections

The instructions for locating the 32-bit ODBC Data Sources are for machines running Windows 8 and higher. If your machine is running Windows 7 64-bit, contact Support for assistance in locating the 32-bit ODBC.

1. While logged into the machine with an administrative user, from the Start menu, type control.
2. Select Control Panel.
3. From the Control Panel, select Administrative Tools.
4. Select ODBC Data Sources (32-bit). PrismCore is a 32-bit program so only the 32-bit ODBC needs to be set.
   Image Removed
   
   
   Image Added
   
   
5. Choose the System DSN tab. If WinPrism is not a data source, choose Add and continue to step #6. If WinPrism is a data source, highlight it and press Configure and skip to step #7.
   
   

6. If adding a new data source, choose SQL Server Native Client 10.0.

...

10. The only box to be checked should be the “Use ANSI nulls, paddings, and warnings” checkbox. Uncheck any other active checkboxes. Press Next.
Image Removed
Image Added

11. The only box to be checked is the “Perform translation for character data”. Uncheck all other active checkboxes. Then click Finish.

Image RemovedImage Added

12. Click Test Data Source. The result should be “Test Completed Successfully!” Press OK. If the test failed, call PrismCore Support.

Image RemovedImage Added

13. Press OK.

14. Click OK to close the ODBC Data Source Administrator dialog boxboxes.

15. Log into PrismCore. If there are any problems or errors, call PrismCore Support.

...