Generate Database to Postgres 14.1 failed. pls help.

my ERStudio is in Windows 10, 64bit.

I have DB in PostgresSQL 14.1 server (Debian 10.2.1-6), 64 bit.  I am able to use GUI connecting to Postgres and execute SELECT version(), which allowed me to find the version.

I'm trying to Generate Database.

In Page 1 of 3 of DDL Gen Wiz PostgreSQL window,

I selected Generate Objects with Database Connection, clicked Connect

In DB conn window,

I type in User Name and Password

I picked the ODBC DataSource of Postgres

In ODBC Data Src Admin (64 bit) I picked the User Data Sources created for PostgresSQL ANSI(x64).

In Postgres ANSI ODBC Driver Setup, Test button  says Connection Successful.

I click next

In Page 2 of 3 of DDL Gen Wiz PostgreSQL window, 

I clicked Finish

Window ER/Studio Data Architect 18.3 pop up saying:

Data source name not found and no default driver specified.

Then next window says, Unable to Connect to Datasource.

How to fix this issue?

Parents Reply Children
No Data