User Tools

Site Tools


Sidebar

Get the Most Out of Your ERP

The Windward Professional Services Catalog

Our catalog of services has topic-based, role-based, or technical plans that can help you maximize your software investment.




Follow Windward Software



New Feature Round-up
create_dsn_database_through_odbc

This is an old revision of the document!


Create a DSN via ODBC

A way of creating a Data Source Name (DSN) is via the ODBC button in System5. Follow the steps below.

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

Switch to “System DSN” tab and click on ADD button

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.

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.
  • 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

  1. go to Control Panel
  2. Administrative Tools
  3. ODBC Data Sources (32/64) bit
  4. 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”

Steps:

  1. Once you have ODBC 32bit loaded
  2. Switch to “System DSN” tab
  3. Click on “ADD” button
  4. Scroll down and select “Pervasive ODB Client Interface”
  5. Click on “Finish” button

You will then get the Window above

  • Data Source Name = the actual DSN name you create in PCC. This 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

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
create_dsn_database_through_odbc.1545175572.txt.gz · Last modified: 2018/12/18 15:26 (3 years ago) by fgabiana