Postgresql odbc driver x32 windows 10

Devart ODBC Driver for PostgreSQL provides a high-performance and feature-rich connectivity solution for ODBC-compliant applications to access PostgreSQL databases from Windows, macOS, and Linux, both 32-bit and 64-bit. Apple Silicon M1 is supported. Full support for standard ODBC API functions and data types implemented in our driver makes interaction of your application with PostgreSQL fast, easy and extremely handy.
Available in both installer formats, MSI and EXE.

Key Features

Direct Connection

Our connectivity solution enables various ODBC-aware applications to establish a direct connection to PostgreSQL via TCP/IP to eliminate the need for PostgreSQL libraries or clients. Direct connection increases the speed of data transmission between an external application and PostgreSQL, which is crucial for data analysis in real time. It also streamlines the deployment process, since there is no need to distribute any additional libraries or client tools with the driver.

Картинка с сайта: marketplace.visualstudio.com

Cost-Effective Deployment

Our ODBC driver is a standalone installation file that doesn’t require the user to deploy and configure any additional software such as a database client or a vendor library. Deployment costs are reduced drastically, especially when using the silent install method with an OEM license in large organizations that have hundreds of machines.

Secure Connection

Work with PostgreSQL securely using SSL connection options provided in our driver along with the support for SSL protocol. You can also connect to PostgreSQL securely via SSH tunnel. SSH protocol is one of the most reliable protocols for data encryption.

Advanced Data Conversion

We have implemented advanced Data Conversion mechanisms that provide bi-directional mapping between any PostgreSQL and ODBC data types.

ODBC Conformance

The driver provides full support for common ODBC interface:

• ODBC API Functions support
• ODBC Data Types support
  Additionally, we support Advanced Connection String parameters to allow desktop or web applications to connect to PostgreSQL from various environments and platforms that support ODBC.

Bulk Updates

Moreover, with our driver you can perform bulk updates to PostgreSQL database by combining SQL statements into batches, thus simplifying and speeding up large data modification to PostgreSQL.

PostgreSQL Compatibility

Our driver is compatible with the latest server versions, up to PostgreSQL 13. We also provide compatibility with Microsoft Azure Database for PostgreSQL, Amazon Aurora and Google Cloud for PostgreSQL.

High Performance

Every operation with PostgreSQL becomes significantly faster using such capabilities of our driver as local data caching, connection pooling, and much more.

Support

Visit our Support page to get instant support from experienced professionals, fast and detailed responses, user engagement and interaction, frequent builds with bug fixes, and much more.

PSQL ODBC is an Open Database Connectivity (ODBC) driver for the PostgreSQL database. The driver was developed by PostgreSQL Global Development Group and is available for use on Windows, Linux, and Mac OS X. It provides a powerful and reliable connection to PostgreSQL databases and is easy to use.

psqlODBC provides a single, easy-to-use interface for accessing PostgreSQL databases from multiple languages and platforms.

Features:

Data Access: PSQL ODBC provides access to data stored in PostgreSQL databases. It supports all data types, including the popular JSON and XML data types. It also provides support for multiple database connections, allowing users to access data from more than one database at a time.

Database Administration: PSQL ODBC provides a comprehensive set of tools to help manage and administer PostgreSQL databases. These include an administrative console, an SQL editor, a query builder, and a user manager.

Data Security: PSQL ODBC provides robust security features to protect data, including encryption, authentication, and access control. It also supports secure connections over the Internet, ensuring that data is protected while in transit.

Platform Support: PSQL ODBC is available for use on Windows, Mac OS X, and Linux. It supports all major versions of PostgreSQL, including the latest version.

Performance: PSQL ODBC is designed to provide fast and reliable access to PostgreSQL databases. It is optimized for speed and performance, and can be used to handle large datasets with minimal latency.

Support: PSQL ODBC provides a comprehensive support system, including technical support, user forums, and online documentation.

Compatibility: PSQL ODBC is compatible with all major programming languages, including C, C++, Java, and .NET. It can also be used with popular development frameworks such as Entity Framework and Hibernate.

Usability: PSQL ODBC is easy to use, with an intuitive user interface and a comprehensive set of features. It is designed to simplify database administration and reduce complexity.

• Introduction
• Connect to PostgreSQL Server
• Setup ODBC
• Troubleshooting
• More Information

Introduction

This article explains how to connect to PostgreSQL with the official PostgreSQL ODBC driver psqlodbc, when using Windows 10.

It covers the following topics:

1. How to connect to postrgreSQL (with code samples).
2. How to setup ODBC:
   • Configure ODBC using the ODBC Data Source Administrator:

     We recommend using system DSNs (available to all users).

Connect to PostgreSQL Server [top]

We strongly recommend using connection objects to connect to databases, and this is what we demonstrate in the code samples.

Follow these steps to connect:

1. Create a new channel to try out the code:
   • Create a channel like this:
     • Name: DB PostgreSQL Connection (or similar)
     • Source: From Translator
     • Destination: To Channel
   • Alternatively use an existing channel:

     Your channel will need a From/To Translator or a Filter component.

2. Connect to a database using ODBC:
   • Paste this code into the Translator:

     If your script uses connection object methods conn:query{} or conn:execute{}to connect to a remote PostgreSQL database, the location of the remote host is specified as part of the name parameter in the db.connect{ } command. If you use conn:merge{} to connect the remote host is specified as part of the name parameter in the conn:merge{} command itself.

     function main()
           local conn = db.connect{   
           api=db.POSTGRES,
           name='your_odbc_server_name',
           user='your_login',
           password='secret',
           use_unicode = true,
           live = true
        }
     
        conn:execute{sql='SELECT * FROM <your table>', live=true}
     end

   • The name is the name of an ODBC source that you create using the ODBC Administrator.
3. Adapt the code to your requirements.

Setup ODBC [top]

To set up a new ODBC data source for PostgreSQL:

1. Install the latest PostgreSQL ODBC drivers:
   • Download the latest 64 bit driver installer (zipped msi file) from the psqlodbc download site.
   • Unzip the file.
   • Run the msi installer and accept the defaults.
2. 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.

3. Open the System DSN tab and click Add:
   

   Картинка с сайта: help.interfaceware.com

4. Choose the latest PostgreSQL ODBC driver and click Finish:
   

   Картинка с сайта: help.interfaceware.com

5. Enter the ODBC credentials:
   • Use any Data Source and Description you prefer.
   • Optional: Choose your default Database.
   • Enter the Network Name of the PostgreSQL Server in the Server field:
     Note: If you are unsure of the name ask your DBA (database administrator).
   • Optional: Enter the Port number (default = 5432)
   • Enter the User name and Password:
     Note: If you are unsure of these ask your DBA (database administrator).
     

     Картинка с сайта: help.interfaceware.com

6. Test the data source connection:
7. If the connection does not work speak to your DBA (database administrator) about how to login to the database (user authentication).

Troubleshooting [top]

• Problems with connection settings:

  Speak to your DBA (database administrator) for general connection issues like: User name and password, Database Server network name etc.

• Iguana may not always support the very latest version of the psqlodbc ODBC drivers:

  Please contact us at support@interfaceware.com if you need to know the latest supported version of the psqlodbc ODBC drivers.

• Incorrect port number:

  SQL Server defaults to port 5432, but a different port can be used. Speak to your database administrator (DBA) or network administrator.

• Using integrated security:

  Using integrated security is the usual way to connect to a Microsoft SQL Server database. If this does not work speak to your DBA (database administrator).

If you need more help please contact us at support@interfaceware.com.

More Information [top]

• Using Database Connection Objects
• Forum thread on Windows ODBC
• Using Integrated Authentication, Microsoft SQL Server documentation (kerberos etc)
• Connect to PostgreSQL from Linux or Mac with ODBC