Cassandra Oledb Provider Sample crashes

Using PGNP with MS SQL Server, Data Transformation Services (DTS), SQL Server Integration Services (SSIS), Linked Servers, Snapshot and Transactional Replication and more.

Cassandra Oledb Provider Sample crashes

Postby eugeneng » Mon Apr 28, 2014 12:29 am

HI, recently I downloaded and installed the trial version of Cassandra Oledb Provider. when I try to run the C# sample, it crashes at :

file : 02_SimpleQuery.cs
line 24
public static int Sample02_SimpleQuery(OleDbConnection conn)
{
ConsoleWriteSampleHeader("[Sample 2.1] Getting records from database using OleDbDataReader.");
String lastStmt = "";

try
{
// Read records from pgnp_samples.contact table.
OleDbCommand cmd = conn.CreateCommand();
cmd.CommandText = lastStmt = "SELECT \"FirstName\",\"LastName\",active,\"HireDate\" FROM \"CasoTestEmployee\" LIMIT 5;";
OleDbDataReader reader = cmd.ExecuteReader(); <------Crashes here!!


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?
eugeneng
 
Posts: 4
Joined: Mon Apr 28, 2014 12:14 am

Re: Cassandra Oledb Provider Sample crashes

Postby Moderator » Mon Apr 28, 2014 9:48 am

No, probably not. What is Cassandra version you use?
User avatar
Moderator
Site Admin
 
Posts: 306
Joined: Wed Oct 29, 2008 11:27 pm

Re: Cassandra Oledb Provider Sample crashes

Postby eugeneng » Sun May 04, 2014 9:24 pm

[cqlsh 4.1.0 | Cassandra 2.0.4 | CQL spec 3.1.1 | Thrift protocol 19.39.0]
eugeneng
 
Posts: 4
Joined: Mon Apr 28, 2014 12:14 am

Re: Cassandra Oledb Provider Sample crashes

Postby Moderator » Fri May 09, 2014 1:28 am

We have fixed the Cassandra provider and updated C# Samples (http://www.pgoledb.com/index.php?option ... &Itemid=68)
User avatar
Moderator
Site Admin
 
Posts: 306
Joined: Wed Oct 29, 2008 11:27 pm


Return to SQL Server/DTS/SSIS/Linked servers/Replication

Who is online

Users browsing this forum: No registered users and 1 guest