- #Postgresql odbc driver configuration file windows 7 how to
- #Postgresql odbc driver configuration file windows 7 install
The database name is the name used with the createdb command, Swi_prolog is a database name in the PostgreSQL database Localhost is the server ( hostname) that refers to the current computer. The servername property is optional but included here to ensure it is set correctly. The servername value uses the format server, e.g. The other section name from the example above is PostgreSQL ANSI. PostgreSQL Unicode is one of the section names from /etc/odbcinst.ini. SWI-Prolog Discourse example is just free text used with some of the tools to display a meaningful description. It is also an ini section name.ĭescription = SWI- Prolog Disc ourse example This example has a space and mixed case letters. is a user created Data Source Name ( DSN). ĭescription = SWI-Prolog Discourse example Odbc.ini contains user-specified access information for the psqlODBC driver. With privileges elevated to root the file can be edited, e.g. etc/odbc.ini - is owned by root with only root having write access, e.g. Ini files are text files and can be edited with any text editor such as nano, vim, etc. Odbc.ini files have a specific format ( semantics) ( ref) Odbc.ini needs to be in directory /etc, e.g. ( ref) cat /etc/odbcinst.iniĭescription=PostgreSQL ODBC driver (ANSI version)ĭescription=PostgreSQL ODBC driver (Unicode version) etc/odbcinst.ini - Configuration file containing all the database drivers specifications. Verify /etc/odbcinst.ini entries for PostgreSQL
#Postgresql odbc driver configuration file windows 7 install
Install PostgreSQL ODBC driver $ sudo apt-get install odbc-postgresqlĥ. Install unixodbc $ sudo apt install unixodbcĤ.
(If not currently installed) $ sudo apt install net-toolsģ.
(If not currently installed) $ sudo apt update Wiki Discussion: SWI-Prolog connecting to PostgreSQL via ODBC SWI-Prolog connecting to PostgreSQL via ODBC Ubuntu Installation Instructions Language agnostic steps 1. Note: Do not reply to this topic questions, concerns, comments, etc. If you have Trust level: Basic you can edit this by clicking on the edit icon in the lower right.
#Postgresql odbc driver configuration file windows 7 how to
Note: This is a topic for learning how to connect SWI-Prolog to PostgreSQL via ODBC.
0 kommentar(er)
