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
Next revisionBoth sides next revision
create_dsn_database_through_odbc [2016/03/03 16:12 (8 years ago)] – [Another way of doing this is through CONTROL PANEL] fgabianacreate_dsn_database_through_odbc [2019/01/09 11:35 (5 years ago)] fgabiana
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 System5. Follow 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 and the old one had been overwritten.</note>
  
-Make sure you are at the server with Administrative Rights. +In Windows 10, the quickest way to load/open ODBC 32bit is through searching it via the Windows Icon, bottom left of the screen
-  * Login to System5 +{{:odbc32-2.jpg|}}
-  * Go to Setup Wizard Network Settings / Pervasive.SQL Database +
-  * On the right side, click on ODBC button+
  
-{{:pervasivesql.jpg?800|}}+OR 
 +  - go to Control Panel 
 +  - Administrative Tools 
 +  - ODBC Data Sources 32bit 
 +  - Then follow the steps above to create the DSN Database
  
-Switch to "System DSN" tab and click on ADD button\\ +OR  
-{{:systemdsn.jpg?500|}}+If you can't find the (32 bit) from the Control Panel\\ 
 +Run "c:\Windows\SysWOW64\odbcad32.exe"
  
-Select the driver “Pervasive ODBC Engine Interface” and click FINISH button below.\\ +Steps: 
-{{:dsndriver.jpg?500|}}+  - Once you have ODBC 32bit loaded 
 +  - Switch to "System DSN" tab 
 +  - Click on "ADD" button 
 +  - Scroll down and select "Pervasive ODB Client Interface" 
 +  - Click on "Finish" button 
 +{{:odbc32.jpg|}}
  
-Give the connection a name and click CREATE button below and leave everything else as is.\\ +You will then get the Window above 
-{{:liveconnection.jpg?500|}} +  * Data Source Name = the actual DSN name you create in PCCThis must be the same name 
-<note>This is not the actual name of the DSN Database but the name of the connection we are creatingThe next step will be the part where we give our DSN database a name.</note>+  * Description = leave it as is 
 +  * Server Name/IP = is either the Server HostName or IP Address 
 +  * Transport Hint = leave it as is
  
-  * Give the DSN a name +Under "Database Name" 
-  * Enable “Long Metadata (V2 metadata) +  * click on "Get list" button 
-  * Locate the dataset under the “Dictionary Location” field +  * then from the drop-down selection box, select the DSN Database you create via PCC 
-  * Click OK button (3x) until you are completely out of the ODBC window +  * Then click on "OKbutton until FINISH
-{{:dsnname.jpg?500|}}+
  
-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 ====== 
- 
- 
-  - 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 fine the (32 bit) from the Control Panel\\ 
-Run "c:\Windows\SysWOW64\odbcad32.exe" 
create_dsn_database_through_odbc.txt · Last modified: 2021/07/07 16:43 (3 years ago) by jege