Moreover, you can enable the use of NULL strings in the metadata. SmDisable, smRequire, smPrefer and smAllow are supported. of the driver as it can be seen in the DSN configuration, for the 32 bit of the. You may specify the timeout duration, IP version (IPv4, IPv6, both) and the preferred protocol (pv20 or pv30).Īdditionally, you can also configure an SSL connection if required, by specifying the CA certificate, cipher list, key and the mode. This configuration file can be used for different Denodo and ODBC driver. PostgreSQL ODBC Driver supports advanced connection options, such as enabling the use of Unicode characters or a custom set of symbols. You can even test the connection before saving the settings. PostgreSQL ODBC Driver can easily be installed and configured with the help of ODBC Data Source Administrator, in the System DSN tab.Īfter installing the driver, you need to specify a Data Source name, a short description and the server details: name, port, database, schema and login credentials. The tool can ensure the connection to several PostgreSQL editions, 7.1 and higher. Moreover, the utility works with some of the common ODBC interfaces, including ODBC Data Types and API functions. You'll have your choice of 32-bit or 64-bit. It is also supported by cross-platform applications. Database Drivers Chances are that you're not using PostgreSQL in a vacuum.
Open the 64 bit ODBC Administrator: Windows 10 (64 bit version) supports 32 and 64 bit ODBC sources always use the 64 bit ODBC Administrator. Run the msi installer and accept the defaults.
PostgreSQL ODBC Driver is compatible with several editions of the Windows and Linux operating systems, with both 32-bit and 64-bit architectures. Install the latest PostgreSQL ODBC drivers: Download the latest 64 bit driver installer (zipped msi file) from the psqlodbc download site. The tool is designed to improve the performance of your applications, as well as the deployment process, thanks to the direct connection. This way, you can avoid the rerouting of the data to third party applications and enjoy the speed and stable transfers. The utility ensures a direct connection between your ODBC interface application and the PostgreSQL, via TCP/IP. The tool is compatible with various operating systems and can ensure the access to several editions of PostgreSQL. PostgreSQL ODBC Driver offers you the means to build a fast, high-performance connection between your applications and the selected PostgreSQL database. Bug with executing the "call" macro with a stored procedure in PostgreSQL 11 and later is fixed.MSI installer for deploying through GPO is added.
What's new in PostgreSQL ODBC driver 4.1.1: