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