Hello,
Switching from SQL Server to PostgreSQL.
Installed Postgresql 11.8 successfully.
Need to install ODBC to connect from front end. When I install ODBC using
stack builder <after installing PG>, I see the ODBC name < in ODBC data source
administrator>
PostgresSQL ODBC Driver(ANSI)PostgresSQL ODBC Driver(UNICODE)
When I download psqlodbc from
https://www.postgresql.org/ftp/odbc/versions/msi/and install ODBC I get the
following names
PostgreSQL ANSIPostgreSQL Unicode
1. Is there any difference between two ?2. Since I dynamically construct DSN
from front end, I need to get the same name in all machines. Is there any way
to get the same name, < PostgreSQL ODBC Driver(ANSI) or PostgreSQL ODBC
Driver(UNICODE), while installing from ODBC Driver downloaded from the above
mentioned site ?
Happiness AlwaysBKR Sivaprakash