User Tools

Site Tools


create_dsn_database_through_odbc

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
create_dsn_database_through_odbc [2019/03/04 17:33]
kevin
create_dsn_database_through_odbc [2020/06/30 11:14] (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,​ 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>​
  
-<note important>​SystemFive is a 32bit application,​ so ODBC Connection should also need to be a 32bit one.</​note>​ 
-<note tip>This is a Windows 10 & PSQL V12 compatible. This is an updated version of the article, old versions have [[http://​wiki.wws5.com/​doku.php?​id=create_dsn_database_through_odbc&​rev=1545175572|instructions for older operating systems]].</​note>​ 
  
-===== This setup or steps is done from the Client Workstation ​=====+===== OBDC setup (32bit) ​===== 
 +{{ ::​odbc-find.jpg?​350|}}
  
 +These instructions are for a Windows 10 or newer operating system & PSQL Version 12. Click here for [[http://​wiki.wws5.com/​doku.php?​id=create_dsn_database_through_odbc&​rev=1545175572|instructions for older operating systems]].
  
-In Windows 10, the quickest way to load/open ODBC 32bit is through searching it via the Windows Icon, bottom left of the screen. + 
-{{:​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 17: 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 "​c:​\Windows\SysWOW64\odbcad32.exe"​ Run "​c:​\Windows\SysWOW64\odbcad32.exe"​
  
-Steps:+**To Add a System DSN (Data Source Name)**
   - Once you have ODBC 32bit loaded   - Once you have ODBC 32bit loaded
   - Switch to "​System DSN" tab   - Switch to "​System DSN" tab
Line 26: Line 30:
   - Scroll down and select "​Pervasive ODB Client Interface"​   - Scroll down and select "​Pervasive ODB Client Interface"​
   - Click on "​Finish"​ button   - Click on "​Finish"​ button
 +
 {{:​odbc32.jpg|}} {{:​odbc32.jpg|}}
  
 You will then get the Window above You will then get the Window above
-  * Data Source Name = the actual ​DSN name you create in PCC. This must be the same name+  * 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 ​the Server HostName ​or IP Address +  * Server Name/IP = Enter the Server HostName 
-  * Transport Hint = leave it as is+  * Transport Hint = leave as "Try TCP/IP First, then SPX"
  
 Under "​Database Name" Under "​Database Name"
-  * 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 "​OK"​ button until FINISH   * 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**.
 +
 +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 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.</​note> ​
  
create_dsn_database_through_odbc.1551749638.txt.gz · Last modified: 2019/03/04 17:33 by kevin