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 [2016/04/18 09:02 (8 years ago)] – [Another way of doing this is through CONTROL PANEL] dcartwright | create_dsn_database_through_odbc [2021/07/07 16:43 (3 years ago)] (current) – jege | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== Create a DSN via ODBC ====== | + | ====== Create a DSN via ODBC32 bit ====== |
+ | Please see: https:// | ||
- | <note tip>A way of creating a Data Source Name (DSN) is via the ODBC button | + | A database DSN (Data Source Name) allow System Five to access the database using SQL. This has both performance improvements, |
+ | <note important> | ||
- | Make sure you are at the server with Administrative Rights. | ||
- | * Login to System5 | ||
- | * Go to Setup Wizard / Network Settings / Pervasive.SQL Database | ||
- | * On the right side, click on ODBC button | ||
- | {{:pervasivesql.jpg?800|}} | + | ===== OBDC setup (32bit) ===== |
+ | {{ ::odbc-find.jpg?350|}} | ||
- | Switch to " | + | These instructions are for a Windows 10 or newer operating system & PSQL Version 12. Click here for [[http://wiki.wws5.com/ |
- | {{:systemdsn.jpg?500|}} | + | |
- | Select the driver “Pervasive ODBC Engine Interface” and click FINISH button below.\\ | ||
- | {{: | ||
- | Give the connection a name and click CREATE button below and leave everything else as is.\\ | ||
- | {{: | ||
- | < | ||
- | |||
- | * Give the DSN a name | ||
- | * Enable “Long Metadata (V2 metadata) | ||
- | * Locate the dataset under the “Dictionary Location” field | ||
- | * Click OK button (3x) until you are completely out of the ODBC window | ||
- | {{: | ||
- | |||
- | YOU"RE DONE!!! You will need to exit out of the Setup Wizard and back in to reload before you can see the connection you have just created. | ||
- | |||
- | Now you can enable DSN as either Pervasive.SQL Database connection or Pervasive.SQL DSN-Less Connection. | ||
- | |||
- | ---- | ||
- | ====== Another way of doing this is through CONTROL PANEL ====== | ||
+ | The quickest way to load/open ODBC 32bit is through searching it via the Windows Icon, bottom left of the screen. | ||
+ | OR | ||
- go to Control Panel | - go to Control Panel | ||
- Administrative Tools | - Administrative Tools | ||
- | - ODBC Data Sources | + | - ODBC Data Sources |
- Then follow the steps above to create the DSN Database | - Then follow the steps above to create the DSN Database | ||
- | Or if you can't find the (32 bit) from the Control Panel\\ | + | OR |
+ | |||
+ | If you can't find the (32 bit) from the Control Panel\\ | ||
Run " | Run " | ||
+ | |||
+ | **To Add a System DSN (Data Source Name)** | ||
+ | - Once you have ODBC 32bit loaded | ||
+ | - Switch to " | ||
+ | - Click on " | ||
+ | - Scroll down and select " | ||
+ | - Click on " | ||
+ | |||
+ | {{: | ||
+ | |||
+ | You will then get the Window above | ||
+ | * Data Source Name = Use the DSN name you create in PCC. | ||
+ | * Description = leave it as is | ||
+ | * Server Name/IP = Enter the Server HostName | ||
+ | * Transport Hint = leave as "Try TCP/IP First, then SPX" | ||
+ | |||
+ | Under " | ||
+ | * Click on "Get list" button | ||
+ | * From the drop-down selection box, select the DSN Database you create via PCC | ||
+ | * 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.1460995373.txt.gz · Last modified: 2016/04/18 09:02 (8 years ago) by dcartwright