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 revisionPrevious revision
Next revision
Previous revision
Last revisionBoth sides next revision
create_dsn_database_through_odbc [2019/01/09 11:37 (5 years ago)] fgabianacreate_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, 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 and the old one had been overwritten.</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.txt · Last modified: 2021/07/07 16:43 (3 years ago) by jege