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...
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.