System Five Add-Ons & Integrations help simplify the way you do things.
Our catalog of services has topic-based, role-based, or technical plans that can help you maximize your software investment.
Copyright © 1984-present
Windward Software Systems Inc.
All Rights Reserved.
Privacy Policy
Please see: https://support.windwardsoftware.com/a/solutions/articles/66000491310
A database DSN (Data Source Name) allow System Five to access the database using SQL. This has both performance improvements, as well as some features, work only with an ODBC connection. ODBC (Open Database Connectivity) is a standard way for programs to access a database. Using the ODBC utility in Windows allows us to configure this technology.
These instructions are for a Windows 10 or newer operating system & PSQL Version 12. Click here for instructions for older operating systems.
The quickest way to load/open ODBC 32bit is through searching it via the Windows Icon, bottom left of the screen.
OR
If you can't find the (32 bit) from the Control Panel Run “c:\Windows\SysWOW64\odbcad32.exe”
To Add a System DSN (Data Source Name)
You will then get the Window above
Under “Database Name”
Windward System5 is a 32bit application, so should your DSN Database. When you create a DSN “either via PCC or ODBC 32bit”, you should always choose a 32bit engine.
The 64bit engine will not work for with Windward System Five.
Search “PSQL Control Center & Documentation” from Windows Or you can simply RUN –> PCC and it will load the same
Once you have PCC loaded, expand the Computer Name. This is always the machine name of the server. Right-click on “Databases” Select “NEW” –> “Databases”
You will then have the screen below
Click FINISH button
To configure the DSN in System Five you will require security access to the setup wizard.