User Tools

Site Tools



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 [2016/04/18 09:02]
dcartwright [Another way of doing this is through CONTROL PANEL]
create_dsn_database_through_odbc [2019/03/04 17:33] (current)
Line 1: Line 1:
-====== Create a DSN via ODBC ======+====== Create a DSN via ODBC32 bit ======
-<note tip>A way of creating ​Data Source Name (DSN) is via the ODBC button in System5Follow the steps below.</​note>​+<note important>​SystemFive is a 32bit application,​ so ODBC Connection should also need to be a 32bit one.</​note>​ 
 +<note tip>This is Windows 10 & PSQL V12 compatible. This is an updated version of the article, old versions have [[http://​​doku.php?​id=create_dsn_database_through_odbc&​rev=1545175572|instructions for older operating systems]].</​note>​
-Make sure you are at the server with Administrative Rights. +===== This setup or steps is done from the Client Workstation =====
-  * Login to System5 +
-  * Go to Setup Wizard / Network Settings / Pervasive.SQL Database +
-  * On the right side, click on ODBC button+
-Switch ​to "​System DSN" tab and click on ADD button\\ +In Windows 10, the quickest way to load/open ODBC 32bit is through searching it via the Windows Icon, bottom left of the screen. 
-Select the driver “Pervasive ​ODBC Engine Interface” and click FINISH button below.\\ +OR 
-{{:​dsndriver.jpg?​500|}}+  - go to Control Panel 
 +  - Administrative Tools 
 +  - ODBC Data Sources 32bit 
 +  - Then follow the steps above to create the DSN Database
-Give the connection a name and click CREATE button below and leave everything else as is.\\ +OR  
-{{:liveconnection.jpg?​500|}} +If you can't find the (32 bit) from the Control Panel\\ 
-<​note>​This is not the actual name of the DSN Database but the name of the connection we are creating. The next step will be the part where we give our DSN database a name.</​note>​+Run "c:\Windows\SysWOW64\odbcad32.exe"
-  * Give the DSN a name +Steps: 
-  ​* Enable “Long Metadata (V2 metadata) +  - Once you have ODBC 32bit loaded 
-  ​* Locate the dataset under the “Dictionary Location” field +  - Switch to "​System ​DSN" tab 
-  ​Click OK button ​(3x) until you are completely out of the ODBC window +  ​- Click on "​ADD"​ button 
-{{:dsnname.jpg?500|}}+  ​- Scroll down and select "​Pervasive ODB Client Interface"​ 
 +  ​Click on "​Finish" ​button 
-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.+You will then get the Window above 
 +  * Data Source Name = the actual DSN name you create in PCCThis must be the same name 
 +  * Description = leave it as is 
 +  * Server Name/IP = is either the Server HostName or IP Address 
 +  * Transport Hint = leave it as is
-Now you can enable DSN as either Pervasive.SQL ​Database ​connection or Pervasive.SQL DSN-Less Connection.+Under "Database ​Name"​ 
 +  * click on "Get list" button 
 +  * then from the drop-down selection box, select the DSN Database you create via PCC 
 +  * Then click on "​OK"​ button until FINISH
-====== Another way of doing this is through CONTROL PANEL ====== 
-  - go to Control Panel 
-  - Administrative Tools 
-  - ODBC Data Sources (32/64) bit 
-  - Then follow the steps above to create the DSN Database 
-Or if you can't find the (32 bit) from the Control Panel\\ 
-Run "​c:​\Windows\SysWOW64\odbcad32.exe"​ 
create_dsn_database_through_odbc.1460995373.txt.gz · Last modified: 2016/04/18 09:02 by dcartwright