Differences

This shows you the differences between two versions of the page.

--- create_dsn_database_through_odbc [2020/04/06 16:24 (4 years ago)] – kevin
+++ create_dsn_database_through_odbc [2021/07/07 16:43 (3 years ago)] (current) – jege
@@ Line 1: / Line 1: @@
 ====== Create a DSN via ODBC32 bit ======
-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.
+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.
 <note important>SystemFive is a 32bit application, the ODBC Connection will also need to be configured 32bit .</note>
@@ Line 44: / Line 46: @@
   * Then click on "OK" button until FINISH
+====== PSQL v12: Creating DSN Database======
+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**.
-===== System Five Configuration =====
+The 64bit engine will not work for with Windward System Five.
+<note tip>This article was written with Pervasive SQL version 12 in mind. This still pertains to Actian Zen PSQL 14 which was a rebrand by Actian Software. Note this rebrand has renamed the PCC to ZenCC.
+</note>
+===== Create a DSN Database via PCC  =====
+Search "PSQL Control Center & Documentation" from Windows Or you can simply RUN --> PCC and it will load the same \\
+{{:employee:dsn-run.png|}} \\
+Once you have PCC loaded, expand the Computer Name. This is always the machine name of the server. \\
+{{:employee:dsn-database.png|}} \\
+Right-click on "Databases" \\
+Select "NEW" --> "Databases" \\
+You will then have the screen below \\
+{{:employee:dsn-fields.png|}}
+  * Database Name: give this any name
+  * Location: point to the _datafiles
+  * Database Options: Long metadata (V2 metadata) needs to be enabled
+  * DSN Options: enable "Create 32-bit Engine DSN"
+Click FINISH button
+====== System Five Configuration ======
 {{ ::odbc-s5-setup.jpg?500|}}
-To configure the DNS in System Five you will require security access to the setup wizard.
+To configure the DSN in System Five you will require security access to the setup wizard.
   - From the Menu choose Setup Tools
   - Select Setup Wizard (You will require Master File Maintenance security [1.2] to modify settings)
@@ Line 59: / Line 90: @@
 <note tip>You will need to configure this for each terminal in your network.</note>