Verification of System DSN entries for ETAP - Local DB ODBC Setup

Verification of System DSN entries for ETAP - Local DB ODBC Setup

BACKGROUND: ETAP installations will automatically configure the ODBC (Open Database Connectivity) and DSN (Data Source Name) necessary for opening ETAP projects on your PC.

ISSUE: In rare instances, the ODBC setup may be misconfigured or missing resulting in the error "There is no Local DB ODBC Setup for ETAP" when attempting to open a project.


To address this error, please refer to the below listed steps for the applicable ETAP version.
ETAP 14.0 - ETAP 22.0
Description:  Verification of DSN for ETAP 14.0.0 to ETAP 22.0.0

ODBC Data Source Administrator paths:

  1. C:\Windows\System32\odbcad32.exe                       for 32-bit
  2. C:\Windows\SysWow64\odbcad32.exe                     for 64 bit
Verify ETAP DSNs 
Your PC System DSN must include the following entries.

 

 


If any of the four (4) entries are missing do the following:
  1. With administrative access privileges, go to the Control Panel.
  2. Select System and Security. 
     
  3. Select Administrative Tools 
     
  4. Open ODBC Data Sources (64-bit). Go to System DSN tab and select Add. 
      
  5. Select SQL Server Native Client 11.0 then click on Finish.
      
  6. Enter the following information then click Finish. 
     
      
  7. Select Test Data Source to confirm ODBC setup was successful. 
  8.  Once the test is successful click ok.
     
  9.  Click Ok to finish setting up the ODBC. 
     
  10.  Close ODBC Data Sources (64-bit) and open ODBC Data Sources (32-bit). Repeat steps 4-9. 


 

 

 

 


ETAP 22.5 - ETAP 24.0

Description:  Verification of DSN for ETAP 22.5 to ETAP 24.0


Verify Driver and Local DB are installed:
From Windows Control Panel > Programs and Features, check if the following applications are listed: 
  1. Microsoft ODBC Driver 17 for SQL Server
  2. Microsoft SQL Server 2019 LocalDB
If not, please run the corresponding .MSI files from the ETAP Installer within ETAPSETUP > REDIST

a)      ETAP####EN\ETAPSETUP\REDIST\MSODBCSQL.MSI

b)      ETAP####EN\ETAPSETUP\REDIST\SQLLOCALDB.MSI


 

 


Verify System DSN:

From your Windows Start menu, open ODBC Data Sources (64-bit) as Administrator.


On the System DSN page, verify the following entries are listed for both 64-bit and 32-bit Platforms:
NAME
DRIVER
otilocaldb19
ODBC Driver 17 for SQL Server
otireportldb19
ODBC Driver 17 for SQL Server

 

  

 

If any of these four (4) entries are missing, please do the following to add:

  1. With administrative access privileges, go to the Control Panel.

  2. Select ‘System and Security’ and Select ‘Administrative Tools’ 

  3. Open ODBC Data Sources 64-bit.  Go to ‘System DSN’ tab and select Add.   
  4. Select ‘ODBC Driver 17 for SQL Server’ then click on Finish.
     
  5.      Enter the following information then click Finish. 
    NAMESERVER
    otilocaldb19(localdb)\etaplocaldb19
    otireportldb19(localdb)\etaplocaldb19
  6. Select ‘Test Data Source’ to confirm ODBC setup was successful.   
  7. Once the test is successful click OK to close each window. 
  8. Click OK to finish setting up the ODBC Test and close ODBC Data Sources 64-bit.
  9. Open ODBC Data Sources 32-bit and Repeat steps 4-8. For reference, the ODBC Data Source Administrator paths are as follows:

C:\Windows\System32\odbcad32.exe for 32-bit
C:\Windows\SysWow64\odbcad32.exe for 64-bit.


ETAP 26.0 and Higher

Description:  Verification of DSN for ETAP 26.0 and higher


Verify Driver and Local DB are installed:
From Windows Control Panel > Programs and Features, check if the following applications are listed: 
  1. Microsoft ODBC Driver 18 for SQL Server
  2. Microsoft SQL Server 2022 LocalDB
If not, please run the corresponding .MSI files from the ETAP Installer within ETAPSETUP > REDIST

a)      ETAP####EN\ETAPSETUP\REDIST\MSODBCSQL.MSI

b)      ETAP####EN\ETAPSETUP\REDIST\SQLLOCALDB.MSI


 

 


Verify System DSN:

From your Windows Start menu, open ODBC Data Sources (64-bit) as Administrator.


On the System DSN page, verify the following entries are listed for both 64-bit and 32-bit Platforms:
NAMEDRIVER
otilocaldb22ODBC Driver 18 for SQL Server
otireportldb22ODBC Driver 18 for SQL Server

 

  

 

If any of these four (4) entries are missing, please do the following to add:

  1. With administrative access privileges, go to the Control Panel.

  2. Select ‘System and Security’ and Select ‘Administrative Tools’ 

  3. Open ODBC Data Sources 64-bit.  Go to ‘System DSN’ tab and select Add.   
  4. Select ‘ODBC Driver 18 for SQL Server’ then click on Finish.
     
  5.      Enter the following information then click Finish. 
    NAMESERVER
    otilocaldb22(localdb)\etaplocaldb22
    otireportldb22(localdb)\etaplocaldb22
  6. Select ‘Test Data Source’ to confirm ODBC setup was successful.   
  7. Once the test is successful click OK to close each window. 
  8. Click OK to finish setting up the ODBC Test and close ODBC Data Sources 64-bit.
  9. Open ODBC Data Sources 32-bit and Repeat steps 4-8. For reference, the ODBC Data Source Administrator paths are as follows:

C:\Windows\System32\odbcad32.exe for 32-bit
C:\Windows\SysWow64\odbcad32.exe for 64-bit.