 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. Main features are: - Database conversion with DTS Wizard (MSSQL 2000) or SSIS Wizard (MSSQL 2005/2008).
- SQL Server 200X Linked Servers and Replication support.
- Error reporting and execution tracing.
- Transactions support: standard OLEDB, and "nested" PostgreSQL transaction using savepoints.
- Distributed transactions (two phase commit protocol).
- Schema support for tables, views, provider types, columns, primary/foreign keys, indexes, etc.
|
|
Read more...
|
| | PGNP 1.2.8 *
| PGNP 1.3.0 | PGNP 1.4.0** | | PostgreSQL 8.x Support | Yes | Yes | Yes | | OLE DB Connection Pooling | Yes | Yes | Yes | | OLE DB Error Reporting | Yes | Yes | Yes | | OLE DB Command Prepare and Cancel | Yes | Yes | Yes | | OLE DB Columns Information | Yes | Yes | Yes | | Database Transformation in SQL Server DTSWizard | Yes | Yes | Yes | | Local Transaction Support | Yes | Yes | Yes | | Distributed Transactions and Two Phase Commit Protocol (DTC enlistment) | No | Yes | Yes | | SQL Server 2000, 2005 and 2008 Linked Servers Support | Yes | Yes | Yes | | SQL Server 2000, 2005 and 2008 to PostgreSQL Replication Support | Yes | Yes | Yes |
|
|
Read more...
|
|
August 23, 2010 Ver 1.3.0.2180
Fixed bug when a linked server connected to Postgres catalog A and user is querying table from catalog B: SELECT * FROM PGNP_TEST.B.[public].tbl. Previously the error returned "Undefined table tbl". After the fix data is returned correctly.
Fixed bug "The
select list for the INSERT statement contains more items than the
insert list. The number of SELECT values must match the number of INSERT
columns. [SQLSTATE 07008] (Error 121)". Added code to analyze DBPROP_UNIQUEROWS property on command. If the property is not set to TRUE, do not insert hidden key column.
Fixed memory leak during DTS transformation (introduced in build 2171).
Fixed bugs in the Expression Type Evaluation engine for complex expressions using functions calls and the numeric type.
Fixed bug in parsing statements using cast to "timestamp without time zone".
|
|
Read more...
|
|
|
The new generation of PGNP provider 1.3 is released! Here is the list of new features in 1.3: - Ability to work with multiple databases via single Linked Server connection.
- Support for SSL and SSPI.
- Arrays support added.
- Enhanced expression types evaluator.
- Added support for nested transactions.
- Added support for distributed transactions (two phase commit protocol).
- Enhancements in internal profiling and tracing.
- Optimizations for insertion of large amounts of data into database.
- Added support for Command Timeout.
- Redesigned "Data Link Properties" pages for easier configuration of connection string.
|
|
Read more...
|
|
|