Using postgres thru ODBC in python 2.7
Question:   * I have installed Postgres.app and started it.
  * I have pip installed pypyodbc
  * I have copied the hello world lines from the Pypyodbc docs, and received the error below. any ideas what the issue might be?

Here is my code

    
    
      from __future__ import print_function
      import pypyodbc
      import datetime
      conn = pypyodbc.connect("DRIVER={psqlOBDC};SERVER=localhost") 
    

And I receive this error:

    
    
    File "/ob/pkg/python/dan27/lib/python2.7/site-packages/pypyodbc.py", line 975, in ctrl_err
      err_list.append((from_buffer_u(state), from_buffer_u(Message), NativeError.value))
    File "/ob/pkg/python/dan27/lib/python2.7/site-packages/pypyodbc.py", line 482, in UCS_dec
      uchar = buffer.raw[i:i + ucs_length].decode(odbc_decoding)
    File "/ob/pkg/python/dan27/lib/python2.7/encodings/utf_32.py", line 11, in decode
      return codecs.utf_32_decode(input, errors, True)
    UnicodeDecodeError: 'utf32' codec can't decode bytes in position 0-1:   truncated data
    

what am I doing wrong?

Do I need to somehow initialize the DB / tables first? it is a weird error if
that is the issue.


Answer: I copied your code on my Fedora machine and it started when I changed connect
string to something like:

    
    
    conn = pypyodbc.connect("Driver={PostgreSQL};Server=IP address;Port=5432;Database=myDataBase;Uid=myUsername;Pwd=myPassword;")
    

You can find more connect strings for PostgreSQL and ODBC at:
<https://connectionstrings.com/postgresql-odbc-driver-psqlodbc/>

