Samples

When installed, PGNP contains following samples under \samples\<language> folders.

C#:
01_GetRecords.cs demonstrates how programmatically connect to PostgreSQL database and get records from pgnp_samples.contact table.
02_SingleValue.cs demonstrates getting single value from database. It reads number of contacts with last name starting with 'S'.
03_InsertUpdateDelete.cs demonstrates creation of a temporary table, records insert, update and delete.
04_CommandParameters.cs demonstrates passing positional and named parameters to a command.
05_StoredProcedures.cs demonstrates how to call stored procedures returning a single result and multiple results.

10_Arrays.cs demonstrates how to query multidimentional arrays in .NET.
11_NestedTransactions.cs demonstrates how to work with nested transactions in .NET.
12_DistribTrans.cs demonstrates how to work with distributed transactions in .NET (TransactionsScope object).
Important: Make sure that "Distributed Transaction Coordinator" system service is running before launching this test.
13_SavePoints.cs demonstrates how to control transactions via PostgreSQL SAVE POINTs.

CPP:
ADOEvents demonstrates howto subscribe for ADO connection and recordset events.
OLEDBTemplates demonstrates:
* howto pass input parameters and get output parameters from stored procedure using OLEDB templates (StoredProcParams.cpp).
* howto select records from a table and insert data using OLEDB templates (SelectInsert.cpp).

Delphi:
TestGrid demonstrates howto populate grid with records from database.

HI, recently I downloaded and installed the trial version of Cassandra Oledb Provider. when I try to run the C# sample, it crashes at Sample02_SimpleQuery() function inside the file : 02_SimpleQuery.cs, line 24, with System Access Violation exception: {"Attempted to read or write protected memory. This is often an indication that other memory is corrupt."}

and I received similar error when I tried to use SSIS to import 10 rows of record into Cassandra database.

is this the limitation of the trial version?

I would like purchase the software provided it is error free.

Hi,
what version of Cassandra are you using? I will double check how the samples work, and will update this thread.

Thank you!

[cqlsh 4.1.0 | Cassandra 2.0.4 | CQL spec 3.1.1 | Thrift protocol 19.39.0]

We have published build 3248 with fixes for the Cassandra provider. Please obtain the latest module from link [url:3jyevict]http://www.pgoledb.com/index.php?option=com_filecabinet&view=files&id=1&Itemid=68[/url:3jyevict].