Yesterday, I edited a blog post for the connection to MySQL, today we’ll see how to connect to PostgreSQL from NBi by using both the ODBC and the OleDB connectors. At the opposite of MySQL, PostgreSQL has at least one ODBC driver and at least one OleDB provider still maintained (and even actively developed). Hi all, i have downloaded from pgoledb.com-download-PGNP OLEDB Providers for Postgres, Greenplum and Redshift-Intellisoft OLEDB Provider for PostgreSQL, Desktop Edition.
I often receive questions such as “Does NBi work with PostgreSQL?” or “Is it possible to use another database than SQL Server?”. The answer is definitively: YES! NBi is working with all databases supporting OleDB or ODBC connections.
Yesterday, I edited a blog post for the connection to MySQL, today we’ll see how to connect to PostgreSQL from NBi by using both the ODBC and the OleDB connectors. At the opposite of MySQL, PostgreSQL has at least one ODBC driver and at least one OleDB provider still maintained (and even actively developed).
I’ll start by the ODBC driver for PostgreSQL. You can find the binaries on the official PostgreSQL website. Download them and install this driver. You can check that the ODBC driver has been correctly installed in the “Program and Features” panel:
Another great way to check that the ODBC drivers are installed is to user PowerShell and the cmdlet
This method returns the following list where you should find something related to PostgreSQL.
This method will also give you the exact name of the driver, something where my google-fu usually miserably fails. In this case I’ve two drivers named PostgreSQL ANSI(x64) and PostgreSQL Unicode(x64). Be sure to use these exact names in your connection strings!
When these connectors are successfully installed, edit your test-suite and define the connection string to your PostgreSQL server as:
That’s it!
For the OleDB provider, I’ll use the commercial version provided by Intellisoft and available on this page. This product comes with a free trial. Once downloaded and installed, you can check that it has correctly been registered by running the following PowerShell cmdlet:
and it should contain the following result:
Pgnp Oledb Provider For Postgresql Data
Unfortunately, this method doesn’t return the nickname of the provider that we must use in our connection string. In this specific case, this name is PNGP.1.
Because this OleDB provider is not pre-registered by NBi, we need to map it to the OleDb namespace as explained in the documentation of NBi. The config file must be updated with:
Once it’s done, you can safely edit your connection string into your test-suite.
We could move this connection string to the settings (references or defaults) or to the config file.
You can now configure a connection to a PostgreSQL instance without any problem!
PGNP OLEDB Provider
The PGNP provider is a thin layer between Microsoft ADO and PostgreSQL database. It implements most of the OLEDB interfaces and uses libpq to access a PostgreSQL database. The provider can be used from 32-bit and 64-bit applications both native and .NET.
- Publisher: PGNP
- Home page:www.pgoledb.com
- Last updated: December 27th, 2011
SQLite ADO.NET Provider
ADO.NET 2.0/3.5 Provider for SQLite is an easy to use software tool with a friendly interface that supports full and compact framework, eEntity framework, complete with full Visual Studio 2005/2008 design-time support. SQLite ADO.NET Provider is free to download and use.
- Publisher: rmsimpson
- Home page:sourceforge.net
- Last updated: March 5th, 2012
Devart dotConnect for SQLite Professional
dotConnect for SQLite is an enhanced ORM enabled data provider for SQLite that builds on ADO.NET technology to present a complete solution for developing SQLite-based database applications. It introduces new approaches for designing application architecture, boosts productivity, and leverages database applications.
- Publisher: Devart
- Home page:www.devart.com
- Last updated: April 29th, 2014
WinDev
WINDEV allows you to develop major projects easily in Windows, Linux, .NET, Java, and other technologies. It works with various databases, including MySQL, PostgreSQL, xBase, and SQLite. WINDEV is also linked to all the databases that include an ODBC driver of an OLEDB provider.
- Publisher: PC SOFT
- Home page:www.windev.com
- Last updated: October 2nd, 2017
OleDb Express
OleDb Express is dbExpress driver for MS SQL Server, MS Access, MS Excel and other OLEDB providers. It works with not all oledb providers. To work with OLEDB Express OLEDB provider must be able to determine command parameters from command text and support convertion of string data to/from BSTR.
- Publisher: Vassiliev V.V.
- Home page:www.oledbdirect.com
- Last updated: January 22nd, 2009
MACL
The MACL Interop API Extensions tool uses features found in the .NET Framework 2.0 for now in the Alpha Version and its to be oriented to Framework 3.5 in the Beta Version. MACL Wraps the Access object model providing a more productive environment for the VBA developer.
- Publisher: jlivio
- Home page:macl.codeplex.com
- Last updated: November 14th, 2011
Query Tool 2008
Created originally by and for our development team to improve productivity while developing software solutions, Query Tool 2008 is a database management tool used to simplify SQL database access, maintain connections, run SQL commands, edit data, and export results across a wide-variety of SQL database platforms.
- Publisher: Vertical Systems Inc
- Last updated: October 6th, 2009
MySharpCode
Learn how to use C# with ADO.NET Data Provider for SQLite to create a program that keeps a database of C# code snippets. The SQLite database included with the free program contains C# programming tips and techniques.
- Publisher: ICT eBooks by Yeoh HS
- Last updated: February 5th, 2010
Devart dotConnect for SQLite Standard
dotConnect for SQLite is an enhanced data provider built over ADO.NET architecture and a development framework with a number of innovative technologies. With state of the art ORM solutions such as Entity Framework and LINQ to SQL, it introduces new approaches for designing applications and boosts productivity of database application development.
- Publisher: Devart
- Home page:www.devart.com
- Last updated: August 2nd, 2021
dotConnect for SQLite
dotConnect for SQLite is an enhanced data provider built on ADO.NET architecture and a development framework with a number of innovative technologies. With state of the art ORM solutions such as Entity Framework and LinqConnect it introduces new approaches for designing applications,boosts productivity, and leverages database applications.
- Publisher: Devart
- Home page:www.devart.com
- Last updated: August 2nd, 2021
LinqConnect Express
LinqConnect Express is a free fast and easy to use ORM solution, developed closely to the Microsoft LINQ to SQL technology, and supporting SQL Server, Oracle, MySQL, PostgreSQL, and SQLite.
- Publisher: Devart
- Home page:www.devart.com
- Last updated: May 7th, 2013
Internet Download Manager
Internet Download Manager supports proxy servers, FTP and HTTP protocols, firewalls, redirects, cookies, authorization, MP3 audio and MPEG video content processing. IDM integrates seamlessly into Microsoft Internet Explorer, Netscape, MSN Explorer, AOL, Opera, Mozilla, Mozilla Firefox, Mozilla Firebird, Avant Browser, MyIE2, and all other popular browsers to automatically handle your downloads.
- Publisher: Tonec Inc.
- Home page:www.internetdownloadmanager.com
- Last updated: July 15th, 2021
PostgreSQL OLE DB Provider
The PGNP provider is a thin layer between Microsoft ADO and PostgreSQL database. It implements most of the OLEDB interfaces and uses libpq to access a PostgreSQL database. The provider can be used from 32-bit and 64-bit applications both native and .NET.
- Publisher: PostgreSQL Application Installer Team
- Home page:www.pgoledb.com
- Last updated: September 25th, 2011
HughesNet Download Manager
HughesNet Download Manager (HDM) is a download manager that allows you to schedule different downloads. HughesNet is a satellite Internet provider. Its subscribers can take advantage of the Hughes Download Zone (2 a.m.-7 a.m. Eastern time), an interval of time when they can freely make downloads without affecting the download threshold associated with their service plan.
- Publisher: HughesNet Service
- Home page:services.hughesnet.com
- Last updated: November 11th, 2009
Microsoft OLE DB Provider for Visual FoxPro
The Visual FoxPro OLE DB Provider (VfpOleDB.dll) exposes OLE DB interfaces that you can use to access Visual FoxPro databases and tables from other programming languages and applications. The Visual FoxPro OLE DB Provider is supported by OLE DB System Components as provided by MDAC 2.6 or later. The requirements to run the Visual FoxPro OLE DB Provider are the same as for Visual FoxPro 9.0.
- Publisher: Microsoft
- Last updated: March 20th, 2008
HP SoftPaq Download Manager
HP SoftPaq Download Manager provides a simple way to download software updates for the HP client PC models in your environment. The program lists the updates available based on your search criteria on a single screen. You can easily find the updates that are most important to you and your users, avoid the cumbersome task of downloading updates individually, and more.
- Publisher: Hewlett-Packard Company
- Home page:support.hp.com
- Last updated: June 29th, 2020
Download Navigator
It is an application designed to update your Epson devices to the latest version. It support the next devices:- Epson Expression Home XP-102.- Epson Expression Home XP-103.- Epson Expression Home XP-202.- Epson Expression Home XP-203.- Epson Expression Home XP-207.
- Publisher: SEIKO EPSON Corporation
- Home page:esupport.epson-europe.com
- Last updated: June 27th, 2013
Good Download Manager
Good Download Manager is an application which helps you download files from torrent websites. When you start downloading, a new window appears which shows the loading level of the file. The program offers you the means to check the download and the upload speed.
- Publisher: GoodDownloadManager Team
- Home page:www.GoodDownloadManager.com
- Last updated: November 6th, 2020