Forum Discussion

georgehalford22's avatar
georgehalford22
Frequent Visitor
8 years ago

Unable to connect to PostgreSQL database on 64 bit windows machine using ODBC connection

Error message: DataSource.Error: ODBC: ERROR [HY000] Error while executing the query Details: DataSourceKind=Odbc DataSourcePath=database=Travel_Information;driver={PostgreSQL Unicode(x64)};port=5...
jmleguedard's avatar
jmleguedard
New Member
8 years ago

Same error here.

And when I try to connect directly via "Get Data>Database>PostgreSQL database connection", I get this error.

Does anybody have an update about this ODBC issue?

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Was this issue ever resolved? I'm attempting to connect via ODBC and as above, I can see the tables, but if I then preview the data I get the error 

     

    DataSource.Error: ODBC: ERROR [HY000] Error while executing the query
    Details:
    DataSourceKind=Odbc
    DataSourcePath=database=**;driver={PostgreSQL ANSI(x64)};port=****;server=***.***.***.***
    OdbcErrors=Table

     

    and the data doesn't load.

    • jm_leguedard's avatar
      jm_leguedard
      New Member
      3 years ago

      Replacing the 32-bit version of Microsoft 365 by the 64-bit version solved that issue.