create_dsn_database_through_odbc
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
create_dsn_database_through_odbc [2020/04/06 08:18 (4 years ago)] – kevin | create_dsn_database_through_odbc [2020/06/30 11:14 (4 years ago)] – 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, | + | A database DSN (Data Source Name) allow System Five to access the database using SQL. This has both performance improvements, |
<note important> | <note important> | ||
- | ===== OBDC setup for System Five on Cloud ===== | ||
- | Contact techincal support to assist in configuring your System Five on Cloud DSN. | ||
- | ===== OBDC setup for Client Workstation | + | ===== OBDC setup (32bit) |
- | <note tip> | + | {{ ::odbc-find.jpg?350|}} |
- | In Windows 10, the quickest way to load/open ODBC 32bit is through searching it via the Windows Icon, bottom left of the screen. | + | These instructions are for a Windows 10 or newer operating system & PSQL Version 12. Click here for [[http:// |
- | {{:odbc32-2.jpg|}} | + | |
+ | |||
+ | The quickest way to load/open ODBC 32bit is through searching it via the Windows Icon, bottom left of the screen. | ||
OR | OR | ||
Line 20: | Line 20: | ||
OR | OR | ||
+ | |||
If you can't find the (32 bit) from the Control Panel\\ | If you can't find the (32 bit) from the Control Panel\\ | ||
Run " | Run " | ||
- | Steps: | + | **To Add a System DSN (Data Source Name)** |
- Once you have ODBC 32bit loaded | - Once you have ODBC 32bit loaded | ||
- Switch to " | - Switch to " | ||
Line 29: | Line 30: | ||
- Scroll down and select " | - Scroll down and select " | ||
- Click on " | - Click on " | ||
+ | |||
{{: | {{: | ||
You will then get the Window above | You will then get the Window above | ||
- | * Data Source Name = the actual | + | * Data Source Name = Use the DSN name you create in PCC. |
* Description = leave it as is | * Description = leave it as is | ||
- | * Server Name/IP = is either | + | * Server Name/IP = Enter the Server HostName |
- | * Transport Hint = leave it as is | + | * Transport Hint = leave as "Try TCP/IP First, then SPX" |
Under " | Under " | ||
- | * click on "Get list" button | + | * Click on "Get list" button |
- | * then from the drop-down selection box, select the DSN Database you create via PCC | + | * From the drop-down selection box, select the DSN Database you create via PCC |
* Then click on " | * Then click on " | ||
+ | ====== PSQL v12: Creating DSN Database====== | ||
+ | Windward System5 is a 32bit application, | ||
+ | |||
+ | 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 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) | ||
+ | - Choose Network Settings | ||
+ | - Select Pervasive.SQL Databases | ||
+ | - Check System Five DSN (Data Source Name) checkbox. | ||
+ | - Enter your Server Name and Click the "Get list" button | ||
+ | - Choose from the drop-down the DSN created | ||
+ | - Click the "Test DSN" button to confirm a successful connection. | ||
+ | <note tip>You will need to configure this for each terminal in your network.</ | ||
create_dsn_database_through_odbc.txt · Last modified: 2021/07/07 16:43 (3 years ago) by jege