The host name or IP address of the machine where the PostgreSQL server is running ( Server).To configure a PostgreSQL data source, in your odbc.ini file, you need to specify: For Easysoft ODBC-PostgreSQL Driver data sources therefore, you need to include a Driver = Easysoft ODBC-PostgreSQL entry. When the Easysoft ODBC-PostgreSQL Driver is installed into unixODBC, it places an Easysoft ODBC-PostgreSQL entry in odbcinst.ini. The Driver attribute identifies the ODBC driver in the odbcinst.ini file to use for a data source. You can either edit the sample data source or create new data sources.Įach section of the odbc.ini file starts with a data source name in square brackets followed by a number of attribute=value pairs.Īttribute names in odbc.ini are not case sensitive. To display the directory where unixODBC stores SYSTEM and USER data sources, type odbcinst -j.īy default, you must be logged in as root to edit a SYSTEM data source defined in /etc/odbc.ini.

If you accepted the default choices when installing the Easysoft ODBC-PostgreSQL Driver, USER data sources must be created and edited in $HOME/.odbc.ini. If sysconfdir was not specified when unixODBC was configured and built, it defaults to /usr/local/etc. If you built unixODBC yourself, or installed it from some other source, SYSTEM data sources are stored in the path specified with the configure option -sysconfdir= directory. If you are using the unixODBC included in the Easysoft ODBC-PostgreSQL Driver distribution, the SYSTEM odbc.ini file is in /etc. Create a USER data source, which is only available to the user who is currently logged on to this Unix machine.īy default, the Easysoft ODBC-PostgreSQL Driver installation creates a SYSTEM data source named.Create a SYSTEM data source, which is available to anyone who logs on to this Unix machine.There are two ways to set up a data source to your PostgreSQL data: Refer to the section relevant to your platform to continue: The section assumes you are, or are able to consult with, a database administrator. This section describes how to configure the Easysoft ODBC-PostgreSQL Driver to connect to a PostgreSQL database by using a data source or a DSN-less connection string. Configuring the Easysoft ODBC-PostgreSQL Driver.This chapter describes how to create data sources, use DSN-less connections and configure the Easysoft ODBC-PostgreSQL Driver.īefore setting up a data source, you must have successfully installed the Easysoft ODBC-PostgreSQL Driver.įor Easysoft ODBC-PostgreSQL Driver installation instructions, see Installation. The data source tells the Driver Manager which ODBC driver to load, which PostgreSQL server to connect to and how to connect to it. ODBC applications access ODBC drivers through the ODBC Driver Manager and a data source. The Easysoft ODBC-PostgreSQL Driver is installed on the computer where your applications are running. Easysoft ODBC-PostgreSQL Driver User's Guide - ConfigurationĬonfiguring the Easysoft ODBC-PostgreSQL Driver

Postgresql odbc windows