create_dsn_database_through_odbc
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
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 ====== | ====== 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, | + | Please see: https:// |
+ | |||
+ | A database DSN (Data Source Name) allow System Five to access the database using SQL. This has both performance improvements, | ||
<note important> | <note important> | ||
Line 44: | Line 46: | ||
* Then click on " | * Then click on " | ||
+ | ====== PSQL v12: Creating DSN Database====== | ||
+ | Windward System5 is a 32bit application, | ||
- | ===== 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. | ||
+ | </ | ||
+ | |||
+ | ===== Create a DSN Database via PCC ===== | ||
+ | |||
+ | Search "PSQL Control Center & Documentation" | ||
+ | {{: | ||
+ | |||
+ | Once you have PCC loaded, expand the Computer Name. This is always the machine name of the server. \\ | ||
+ | {{: | ||
+ | Right-click on " | ||
+ | Select " | ||
+ | |||
+ | You will then have the screen below \\ | ||
+ | {{: | ||
+ | |||
+ | * Database Name: give this any name | ||
+ | * Location: point to the _datafiles | ||
+ | * Database Options: Long metadata (V2 metadata) needs to be enabled | ||
+ | * DSN Options: enable " | ||
+ | |||
+ | |||
+ | Click FINISH button | ||
+ | |||
+ | |||
+ | ====== System Five Configuration | ||
{{ :: | {{ :: | ||
- | 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 | - From the Menu choose Setup Tools | ||
- Select Setup Wizard (You will require Master File Maintenance security [1.2] to modify settings) | - 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 tip>You will need to configure this for each terminal in your network.</ | ||
- | |||
create_dsn_database_through_odbc.1586215489.txt.gz · Last modified: 2020/04/06 16:24 (4 years ago) by kevin