User Tools

Site Tools


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 fine the (32 bit) from the Control Panel
Run “c:\Windows\SysWOW64\odbcad32.exe”

create_dsn_database_through_odbc.1457050361.txt.gz · Last modified: 2016/03/03 16:12 (8 years ago) by fgabiana