.NET Components for .NET 4.0 Framework Http 9.2.0 serial key or number

How do I work around the following fatal error:  AccessViolationException<\/P>

<\/P>

Steps to reproduce the error:<\/P>

1.  In MS VisualStudio 2008, Create a Windows Form Application, add a Panel and a Button components to the form.<\/P>

2.  Add a Reference to the Acrobat COM component for AxAcroPDFLib<\/P>

3.  Add the following code to the main form:<\/P>

<\/P>

    private AxAcroPDFLib.AxAcroPDF ax = new AxAcroPDFLib.AxAcroPDF();<\/P>

<\/P>

    private void button1_Click(object sender, EventArgs e)
    {
      panel1.Controls.Add(ax);<\/P>

      ax.LoadFile(@\"c:\\temp\\myfile.pdf\");
      ax.setView(\"Fit\");     
    }<\/P>

<\/P>

4.  Run the application<\/P>

5.  Click the Button<\/P>

6.  Press the TAB key on the keyboard.<\/P>

Result:  The application crashes with an AccessViolationException:  Memory Corrupted error.<\/P>

<\/P>

Note:  I had been working on an application for about a month now, but had Never pressed the Tab key while the application was running until today!!<\/P>

Although I did not yet test EVERY key, all other keys and activities inside and outside of the Acrobat component, application, and OS seem to work ok.  I can't deploy an application to production if it will crash on Tab keypress.<\/P>

<\/P>

Platform:<\/P>

Windows 7, 32bit, all current updates<\/P>

Acrobat 9 Standard, all current updates<\/P>

Microsoft Visual Studio 2008 Professional, all current updates<\/P>

<\/P>

I'm not an Acrobat SDK developer expert, so this may be some simple configuration setting.<\/P>

Any assistance is greatly appreciated.<\/P>

<\/P>

Arnold<\/P><\/BODY><\/HTML>

1.   Introduction
2.   Available .NET Framework Data Providers
3.   Setup of the .NET Framework
4.   Transactions using SqlClient Data Provider to access SQL Server 2000
5.   Transactions using Oracle .NET Data Provider to access Oracle 9i

More Information:

Oracle and SQL Server DB Access with SqlNet, OleDb and Odbc Data Provider using .NET Framework and C#

Summary

Implementing a basic transaction using ADO.NET in an application can be fairly straightforward. The most common sequence of steps that would be performed while developing a transactional application is as follows:

• Open a database connection using the Open method of the connection object.
• Begin a transaction using the BeginTransaction method of the connection object. This method provides us with a transaction object that we will use later to commit or rollback the transaction. Note that changes caused by any queries executed before calling the BeginTransaction method will be committed to the database immediately after they execute.
• Set the Transaction property of the command object to the above mentioned transaction object.
• Execute the SQL commands using the command object. We may use one or more command objects for this purpose, as long as the Transaction property of all the objects is set to a valid transaction object.
• Commit or roll back the transaction using the Commit or Rollback method of the transaction object.
• Close the database connection.

A data provider in the .NET Framework serves as a bridge between an application and a data source. A .NET Framework data provider enables you to return query results from a data source, execute commands at a data source, and propagate changes in a DataSet to a data source. This article includes tips on which .NET Framework data provider is best suited for your needs.

Which .NET Framework Data Provider to Use?

To achieve the best performance for your application, use the .NET Framework data provider that is most appropriate for your data source. There are a number of data provider options for use in your applications. The following table provides information about the available data providers and which data sources a data provider is most appropriate for.

Provider	Details
SQL Server .NET Data Provider	Found in the System.Data.SqlClient namespace. Recommended for middle-tier applications using Microsoft SQL Server version 7.0 or later. Recommended for single-tier applications using the Microsoft Data Engine (MSDE) or Microsoft SQL Server 7.0 or later.
OLE DB .NET Data Provider	Found in the System.Data.OleDb namespace. Recommended for middle-tier applications using Microsoft SQL Server 6.5 or earlier, or any OLE DB provider that supports the OLE DB interfaces listed in OLE DB Interfaces Used by the OLE DB .NET Data Provider in the .NET Framework SDK. For Microsoft SQL Server 7.0 or later, the .NET Framework Data Provider for SQL Server is recommended. Recommended for single-tier applications using a Microsoft® Access database. Use of an Access database for a middle-tier application is not recommended.
ODBC .NET Data Provider	Found in the Microsoft.Data.Odbc namespace. The ODBC .NET Data Provider is available for download. Provides access to data sources that are connected to using an ODBC driver.
Oracle .NET Data Provider	Found in the System.Data.OracleClient namespace. The .NET Framework Data Provider for Oracle, unlike the Microsoft OLE DB provider for Oracle, also supports new Oracle 9i datatypes, as well as ref cursors (useful for running Oracle stored procedures that return result sets). This provider, System.Data.OracleClient, is similar to the .NET Framework Data Provider for SQL Server, System.Data.SqlClient. The Oracle .NET Data Provider is available for download

The Microsoft® .NET Framework is the infrastructure for the overall .NET Platform. The common language runtime and class libraries (including Microsoft Windows® Forms, ADO.NET, and ASP.NET) combine to provide services and solutions that can be easily integrated within and across a variety of systems.

The .NET Framework provides a fully managed, protected, and feature-rich application execution environment, simplified development and deployment, and seamless integration with a wide variety of languages.

Microsoft .NET Framework Software Development Kit

The Microsoft® .NET Framework Software Development Kit (SDK) includes the .NET Framework, as well as everything you need to write, build, test, and deploy .NET Framework applications - documentation, samples, and command-line tools and compilers.

Download and Installation

Goto:

http://msdn.microsoft.com/downloads/

Select:

-> Software Development Kits
-> Microsoft .NET Framework SDK

You'll get the whole framework and a C# command line compiler. Run the downloaded setup.exe if you haven't installed yet Microsoft .NET and follow the installation steps. You will be asked for Server Components which you don't need. If the installation asks for Microsoft Data Access Components MDAC you may continue or quit the installation. Anyway, you need to install MDAC 2.7 or higher prior ODBC data access is going to work.

The SqlClient provider ships with ADO.NET and resides in the System.Data.SqlClient namespace. It should be used to access SQL Server 2000. The classes within SqlClient provider all begin with "Sql", so the connection class is SqlConnection, the command class is SqlCommand, and so on. Lets look at an example to update SQL Server 2000.

using System;
using System.Data;
using System.Data.SqlClient;

namespace TranDemoSqlClient
{
 class TranDemoSqlClient
 {
  static void Main(string[] args)
  {
  
   string connectionString = "server=localhost;"
     + "database=Northwind;uid=sa;pwd=manager";
   SqlConnection cnn;
   SqlCommand cmd;
   SqlTransaction tran;

  
   cnn = new SqlConnection(connectionString);
   cnn.Open();

  
   tran = cnn.BeginTransaction();

  
   cmd=new SqlCommand();
   cmd.Connection=cnn;
   cmd.Transaction=tran;

  
   try
   {
   
    cmd.CommandText = "INSERT INTO Orders " +
      "(CustomerID,OrderDate,RequiredDate) " +
      "VALUES('ALFKI',GetDate(),DATEADD(d,15,GetDate()))";
    long rows = cmd.ExecuteNonQuery();
    Console.WriteLine("Rows inserted in Orders: {0} ", rows);

   
    cmd.CommandText = "SELECT @@identity";
    string id = cmd.ExecuteScalar().ToString();

   
    cmd.CommandText = "INSERT INTO [Order Details] " +
      "(OrderID,ProductID,UnitPrice,Quantity) " +
      "VALUES(" + id + ",1,18,25)";
    rows = cmd.ExecuteNonQuery();
    Console.WriteLine("Rows inserted in [Order Details]: {0} ", rows);

   
    string customerid = args[0];
    decimal freight = decimal.Parse(args[1]);

    string query="UPDATE Orders SET freight = "
    + freight + " WHERE customerid = '" + customerid + "'";
    cmd.CommandText = query;
    rows = cmd.ExecuteNonQuery();
    Console.WriteLine("Rows updated in [Orders]: {0} ", rows);

   
    tran.Commit();
    Console.WriteLine("Commit complete");
   }
  
   catch(Exception e)
   {
    tran.Rollback();
    Console.WriteLine("Transaction failed - Rolled Back!");
    Console.WriteLine(e.Message);
   }
  }
 }
}

This file is called TranDemoSqlClient.cs, we can compile it from the command line simply by typing cscTranDemoSqlClient.cs. There is no need to add any references.

Introduction

If you are building applications using Microsoft® .NET against an Oracle backend database, you will want to take a close look at the new .NET Framework Data Provider for Oracle released on MSDN in June 2002. The goal of the provider is to boost the performance and scalability of .NET applications with Oracle databases by providing a native .NET interface to Oracle databases that bypasses the need to use an OLE DB provider.

The .NET Framework Data Provider for Oracle, unlike the Microsoft OLE DB provider for Oracle, also supports new Oracle 9i datatypes, as well as ref cursors (useful for running Oracle stored procedures that return result sets). This provider, System.Data.OracleClient, is similar to the .NET Framework Data Provider for SQL Server, System.Data.SqlClient.

Using ADO.NET with Oracle

Until recently, the primary mechanism developers used to access Oracle databases from .NET application was OLE DB, channeling database requests through the System.Data.OleDb data classes. However, developers writing .NET data-driven applications against SQL Server have been able to take advantage of the super-fast System.Data.SqlClient data classes, which provide data access to SQL Server via a SQL Server provider written in managed .NET code. This provider communicates to SQL Server via the native SQL Server client libraries, and derives very fast speeds. While OLE DB provided an adequate data access mechanism for .NET applications to communicate with Oracle backends, certainly developers have been asking for a faster, more scalable Oracle data access mechanism to get better performance for the .NET applications. The new .NET Framework Data Provider for Oracle, recently released on MSDN, provides just this.

Basically, developers now have a much faster database access mechanism for ADO.NET in the form of new System.Data.OracleClient framework classes that work in much the same way as the System.Data.SqlClient classes. In both cases, the fastest database read mechanism will be ADO.NET Data Readers, as opposed to Data Sets, although both are fully functional using the new Oracle Managed Provider. The good news is the new OracleClient classes should provide significant performance improvements for .NET applications, and migrating code between OLE DB data classes and OracleClient data classes is not very difficult, although some work is required. However, the performance boost can be dramatic.

Where Is the Performance Boost Coming From?

The OLE DB client classes are designed to provide a database-independent layer for accessing generic databases. While the value of a generic layer is nearly universal access, it is difficult to deliver database-specific optimizations in this generic access layer. Also, the OLE DB layer is implemented as a COM library, so the System.Data.Oledb namespace works through COM interop. To achieve the significant performance boost described here, the .NET Framework Data Provider for Oracle avoids the cost of COM interop, and also employs Oracle-specific optimizations.

Installation and Configuration

The Microsoft® .NET Framework Data Provider for Oracle is an add-on component to the Microsoft .NET Framework that provides access to an Oracle database using the Oracle Call Interface (OCI) as provided by Oracle Client software. Oracle 8i Release 3 (8.1.7) Client or later must be installed for this provider to function.

The Oracle .NET Data Provider is available for download

The following files are installed by Setup:

File name	Description
Eula.rtf	.NET Framework Data Provider for Oracle end-user license agreement.
Oracleref.chm	.NET Framework Data Provider for Oracle documentation.
Oracleref.chi	Index file that accompanies Oracleref.chm (.NET Framework Data Provider for Oracle documentation).
Readme.txt	Additional product information that is not contain in Oracleref.chm (.NET Framework Data Provider for Oracle documentation).
System.Data.OracleClient.dll	The .NET Framework Data Provider for Oracle.
Mtxoci8.dll	DLL that provides distributed transaction support.

All of these files, except Mtxoci8.dll, are installed in C:\Program Files\Microsoft.NET\OracleClient.Net by default (assuming that C:\Program Files is your default Program Files folder location). Mtxoci8.dll is installed in the windows system directory (for example, C:\Windows\System32 on a Windows 2000 computer on which C: is the system drive).

As part of Setup, the System.Data.OracleClient namespace is added to the global assembly cache.

The classes that compose the provider are in the System.Data.OracleClient namespace and all have the prefix "Oracle".   Lets look at an example to update Oracle 9.2.0.

using System;
using System.Data;
using System.Data.OracleClient;

namespace TranDemoOra
{
  class TranDemoOra
  {
    static void Main(string[] args)
    {
     
      string connectionString = "Data Source=ARK2;"
      + "User ID=scott; Password=tiger";
      OracleConnection cnn;
      OracleCommand cmd;
      OracleTransaction tran;

     
      cnn=new OracleConnection(connectionString);
      cnn.Open();

     
      tran=cnn.BeginTransaction();

     
      cmd=new OracleCommand();
      cmd.Connection=cnn;
      cmd.Transaction=tran;

     
      try
      {

       
        int  empno=int.Parse(args[0]);
        string job=args[1];

        string query="UPDATE emp SET job = '"
        + job + "' WHERE empno = " + empno;
        cmd.CommandText=query;
        long rows = cmd.ExecuteNonQuery();

       
        tran.Commit();
        Console.WriteLine("Commit complete, {0} ", rows + " Rows updated");
      }

     
      catch(Exception e)
      {
        tran.Rollback();
        Console.WriteLine("Transaction failed - Rolled Back!");
        Console.WriteLine(e.Message);
      }
    }
  }
}

This file is called TranDemoOra.cs, we can compile it from the command line by typing csc /r:System.Data.OracleClient.dll TranDemoOra.cs. The reference to the System.Data.OracleClient.dll is needed.

Crystal Reports Version

Assembly Version

MSM & MSI Files

URL or Hard Drive Location

Supported OS

Framework

CR 9.1 (VS .NET 2002)

9.1.3300.0

Database_Access.msm,Database_Access_enu.msm, Managed.msm, Regwiz.msm

NA

WIN XP, WIN 2000, WIN 2003

1.1

CR 9.1 (VS .NET 2003)

9.1.5000.0

Crystal_Database_Access2003.msm, Crystal_Database_Access2003_enu.msm, Crystal_Managed2003.msm, Crystal_regwiz2003.msm

NA

WIN XP, WIN 2000, WIN 2003

1.1

Crystal Reports 9.2.x

9.2.3300.0

Reportengine.msm, Crnetruntime.msm, Mapping.msm, License.msm,

NA

WIN XP, WIN 2000, WIN 2003

1.1

Cr9redist.msi

NA

WIN XP, WIN 2000, WIN 2003

1.1

Crystal Reports 10.0.x

10.0.3300.0

CrystalReports10_NET_EmbeddedReporting.msm, CrystalReports10_NET_RemoteReporting.msm, CrystalReports10_NET_WebServiceReporting.msm

NA

Win XP, WIN 2000, WIN 2003

1.1

CrystalReports10_NET_EmbeddedInstall.msi

NA

Win XP, WIN 2000, WIN 2003

1.1

CR 10.2 (VS .NET 2005)

10.2.3600.0

CRRedist2005_IA64.msi (64 bit Itanium) #

C:\Program Files\Microsoft Visual Studio 8\Crystal Reports\CRRedist\IA64

WIN XP, WIN 2000, WIN 2003 

2.0

CRRedist2005_X64.msi (64 bit Intel) #

C:\Program Files\Microsoft Visual Studio 8\Crystal Reports\CRRedist\X64

WIN XP, WIN 2000, WIN 2003,

2.0

CRRedist2005_x86.msi (BootStrapper) #

C:\Program Files\Microsoft Visual Studio 8\sdk\v2.0\Bootstrapper\Packages\Crystal Reports

WIN XP, WIN 2000, WIN 2003

2.0

CRRedist2005_x86.msm

NA

WIN XP, WIN 2000, WIN 2003,

2.0

CRRedist2005_x86.msi #

c:\program files\microsoft visual studio 8\sdk\v2.0\bootstrapper\packages\crystal reports

WIN XP, WIN 2000, WIN 2003

2.0

cr_net_2005_mm_mlb_ia64.zip

NA

WIN XP, WIN 2000, WIN 2003

2.0

cr_net_2005_mm_mlb_ia64.zip

NA

WIN XP, WIN 2000, WIN 2003

2.0

CR 10.5 (VS .NET 2008)

10.5.3700.0

CRRedist2008_ia64.msi (64 bit Itanium)
CRRedist2008_x64.msi (64 bit Intel)
CRRedist2008_x86.msi (BootStrapper)

NA

WIN XP, WIN 2003, WIN 2008, WIN Vista, WIN 7

2.0, 3.5

CR XI R1

11.0.3300.0

Crystal11_Net_EmbeddedReporting.msm
CrystalReports11_NET_EmbeddedInstall.msi

NA

WIN XP, WIN 2000, WIN 2003

1.1

CR XI R2 (SP 6)

11.5.3300.0

CrystalReports11_5_NET.msm (.NET 2003)
CrystalReports11_5_NET_2005.msm (.NET 2005)
CrystalReports11_5_maps.msm

Download Link

WIN XP, WIN 2000, WIN 2003, WIN Vista, WIN 7

1.1, 2.0

CrystalReports11_5_NET.msi (.NET 2003)
CrystalReports11_5_NET_2005.msi (.NET 2005)

Download Link

WIN XP, WIN 2000, WIN 2003, WIN Vista, WIN 7

1.1, 2.0

CrystalRedist115_X86.msi (BootStrapper)

c:\program files\microsoft visual studio 8\sdk\v2.0\bootstrapper\packages\crystal reports

WIN XP, WIN 2000, WIN 2003, WIN Vista, WIN 7

1.1, 2.0

CR 2008 (SP 7)

12.0.1100.0 (framework 1.1), 12.0.2000.0 (framework 2.0, 3.5)

CRRuntime_12_5_mlb.msi,
CRRuntime_12_5_mlb.exe
CRRuntime_12_5.msm

WIN XP, WIN 2003, WIN 2008, WIN Vista, WIN 7, WIN 2012

1.1, 2.0, 3.0, 3.5

CRVS2010

13.0.2000.0

CRRuntime_32bit_16_0_x.msi
CRRuntime_64bit_16_0_x.msi
CRRuntime_16_0_x.msm

WIN 2003, WIN 2008, WIN Vista, WIN 7, WIN 8 / 8.1, WIN 2010, WIN 2012^

2.0, 3.0, 3.5, 4.0, 4.5

CR 2011 SP 5+

14.0.x

N/A*

NA

WIN 3.1, WIN 2003, WIN 2008, WIN Vista, WIN 7, WIN 8.x, WIN 2012

N/A

CR 2013 SP 3+

WIN 2008, WIN 7, WIn 8.x, WIN 2012