Stata 16 ODBC Connection to Postgres Database in Ubuntu

[James Anderson]

Hello,

I have been working to connect Stata to my local Postgres database via an ODBC connection on a Ubuntu machine. I have already confirmed that my odbc connection is working via isql, however when I use the command "odbc list" within stata I get the error "r(680)".

Relevant Details:
Ubuntu release 20.04
Postgres 12
Stata 16

Based on what I have read in other form post I believe the following information will be helpful:

. about

Stata/IC 16.1 for Unix (Linux 64-bit x86-64)
Revision 06 Apr 2021
Copyright 1985-2019 StataCorp LLC

Total usable memory: 125.74 GB

Stata license: Single-user , expiring 20 Aug 2021
Serial number: ***********************  Licensed to: James Anderson
               Michigan State University

. !uname -a

Linux gonzo 5.4.0-80-generic #90-Ubuntu SMP Fri Jul 9 22:49:44 UTC 2021 x86_64 x86_64 x86_64 GNU/Linux

. query other
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Other settings
      set type             float      may be float or double
      set maxiter          300        max iterations for estimation commands
      set searchdefault    all        may be local, net, or all
      set varabbrev        on
      set emptycells       keep       may be keep or drop
      set fvtrack          term       may be term or factor
      set fvbase           on
      set processors       1
      set odbcmgr          unixodbc   may be iodbc or unixodbc
      set odbcdriver       unicode    may be unicode, ansi, or default
      set fredkey          

. !odbcinst -q -d

[ODBC Data Sources]
[ODBC_Dissertation]
[PostgreSQL ANSI]
[PostgreSQL Unicode]