User Tools

Site Tools


create_dsn_database_through_odbc

This is an old revision of the document!


Create a DSN via ODBC32 bit

SystemFive is a 32bit application, so ODBC Connection should also need to be a 32bit one.
This is a Windows 10 & PSQL V12 compatible. This is an updated version of the article and the old one had been overwritten.

In Windows 10, the quickest way to load/open ODBC 32bit is through searching it via the Windows Icon, bottom left of the screen.

OR

  1. go to Control Panel
  2. Administrative Tools
  3. ODBC Data Sources 32bit
  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.1547062542.txt.gz · Last modified: 2019/01/09 11:35 (5 years ago) by fgabiana