• Postgresql Native Provider Connection String

2014 PGNP Native OLE DB Provider for PostgreSQL, Greenplum, Redshift Developer s Manual This document contains description of various PGNP features, use cases and programming techniques.

PostgreSQL Native Provider (PGNP) is an OLEDB Provider for PostgreSQL database. The provider is a thin layer between Microsoft ADO and PostgreSQL API exposed via libpq library. 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. Its flexible architecture allows emulation of various databases SQL flavors (Enterprise edition) and saves customer from rewriting applications that originally developed for other databases. The Provider code is ATL based and it is compiled using Microsoft Visual Studio 2005.

1 2014 PGNP Native OLE DB Provider for PostgreSQL, Greenplum, Redshift Developer s Manual This document contains description of various PGNP features, use cases and programming techniques. It is written for professional developers. Konstantin Izmailov Copyright All Rights Reserved. 5/9/2014 2 This document is property of PGNP team. Neither a part nor the entire document can be reproduced, changed, distributed or published without prior written permission of owners. 7 2 Installation and Product Activation To install the PGNP OLEDB Provider launch the installation module. The Module name may vary depending on the provider variant/edition: Module name PGNP-Postgres-DE exe PGNP-Postgres-SE exe PGNP-Greenplum-DE exe PGNP-Greenplum-SE exe PGNP-Redshift-SE exe Description OLEDB Provider for Postgres, Desktop Edition OLEDB Provider for Postgres, Server Edition OLEDB Provider for Greenplum, Desktop Edition OLEDB Provider for Greenplum, Server Edition OLEDB Provider for Redshift Note: Evaluation module name includes word trial, e.g.: PGNP-Postgres-DE-Trial exe.

Supported in Windows platforms such as Windows 98, 2000, NT, Me, and XP versions; you can avail this tool as a free to use software application. Once you pick up the basic nuances, there are also advanced lessons you can opt for that will help you gain a confident typing speed. Computer hindi typing software download. This is a bi-lingual tool; it offers touch typing sessions in both Hindi and English. This is a product that has been designed and developed by CK Technologies.

First page of the installation application is shown below. Click Next through the wizard pages. Please read the License Agreement carefully. Specify the installation folder. By default, the Postgres and Greenplum providers are installed into C: Program Files (x86) intellisoft pgnp folder, and the Redshift into C: Program Files (x86) intellisoft rsnp folder.

Postgresql Native Provider Connection String

8 Enter the Product Key (License Key). The installation module will automatically activate the product on the computer. This step requires an Internet connection.

If Internet connection is not available, or you prefer to activate the product later, select the check box on the bottom of the page (Register the product later using PGNPUpdate utility). Please refer to PGNP Update utility guide below, specifically to section Working in Activation Mode.

Note: If the provider was previously activated on the computer the installation will not require entering the product key. In that case the above page is not displayed, and installation proceeds to the next step. Click Next in following dialogs. 11 3 Provider s Features This chapter contains information about various features and use cases of the Provider. 3.1 Database Transformation MS DTS/SSIS tools allow copying databases between various OLE DB sources. PGNP Provider can be used to transform a non-postgresql database into a PostgreSQL database and vice versa Transforming MS SQL 2000 database into a PostgreSQL database using DTSWizard 1.