Extended syntax for parameters ‘:’ and ‘?’) and support for IN, OUT and INOUT parameters.Partial support for T-SQL statements syntax.Support for PostgreSQL syntax with POSIX and other extensions.Unicode (UTF8) and various languages support.Command cancel, prepare and column information on a prepared command.Schema support for tables, views, provider types, columns, primary/foreign keys, indexes, etc.Distributed transactions (two phase commit protocol).Transactions support: standard OLEDB, and “nested” PostgreSQL transaction using savepoints.SQL Server Linked Servers and Replication support.Database conversion with DTS Wizard (MSSQL 2000) or SSIS Wizard (MSSQL 2005/2008/2012).The provider can be used from 32-bit and 64-bit applications both native and. It implements most of the OLEDB interfaces and uses libpq to access a PostgreSQL database. The PGNP provider is a thin layer between Microsoft ADO and PostgreSQL database. Intellisoft OLE DB Provider for PostgreSQL, Server Edition