Up
ODBC Setup
Drivers for Windows and *nix
These drivers enable client PCs to retrieve datasets from the PostgreSQL database via the ODBC protocol. All available versions can be found here.
Windows
Select a driver from here. Select a 32-bit driver for 32-bit applications or a 64-bit driver for 64-bit applications. For a new installation save to desktop, extract and open the msi file and follow instructions. There is also a batch file for upgrading the driver. Configuration details are shown below for a connection in MapInfo.
Navigate to Control Panel / Administrative Tools / Data Sources (ODBC) / Create New Data Source (add).
Select the PostgreSQL Unicode driver and make the following settings.
| Data Source |
MAPINFO-POSTGRES |
| Database |
postgres |
| Server |
192.168.1.68 |
Port |
5432 |
| User Name |
MAPINFO |
Password |
MAPINFO |
Then in Configure / Options / Datasource, set Updatable Cursors (off).
For 32-bit applications on 64-bit Windows you must run 'C:\windows\sysWOW64\odbcad32.exe' as administrator to manage DSNs.
Up