Skip to main content

Related Articles

Loading...

Failed to open a rowset. Details: 42000:[IBM][iSeries Access ODBC Driver]Statement violates access rule: Connection is set to read only. Failed to open a rowset.

Failed to open a rowset. Details: 42000:[IBM][iSeries Access ODBC Driver]Statement violates access rule: Connection is set to read only. Failed to open a rowset.

This is very common error when you try to deploy your Crystal Report reports in production environment. But most of the time people doesn't have proper solution. This error can be raised due to various reasons. But as I feel Crystal report gives very generic errors rather giving specic error message. So that most of the time we need to spend lot of time to figure out the exact issue. As of my experience this error gives when your crystal report unable to retrive data from your database properly. Here in this case iSeries Acess ODBC Driver has used. You might use some other driver to communicate with your database. But you will get very similar error with respect to your driver. Whether you are using stored procedure to retive data or directly access the database table; doesn't matter this error might occur.

First thing that you can try out is check whether you have configured "AllowProcCalls" registry entry. You can check this, go to start button, then run. In run dialog box type "regedit" and enter. In the RegEdit you need to locate HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI. Then find your ODBC data source that your crystal report retrive data from. Verify that there is an entry called "AllowProcCalls" with a value of "1". If AllowProcCalls entry doesn't exists you can create it by right click on your ODBC data source, then select New : String Value. Enter in AllowProcCalls and enter. If AllowProcCalls entry has value other than 1 you can change its value by double clicking on that entry or right click on the entry and select modify. Enter 1 and press "OK".


Fig 1. AllowProcCalls entry in RegEdit window

Then load your Crystal Report again and check whether your problem solved. If you are getting further errors please let me know so that I will look in to them separatly.

More references:

Crystal Reports 2008 For Dummies
Crystal Reports 2008: The Complete Reference (Osborne Complete Reference Series)
Crystal Reports XI: The Complete Reference (Osborne Complete Reference Series)
Upgrade Crystal Reports 2008 Win Nul
Crystal Reports 10 For Dummies

Comments

  1. Anonymous7 December 2011 at 08:04

    it did'nt solve my problem

    ReplyDelete
  2. Aamir27 December 2011 at 22:51

    I am having the same problem after doing all you said above, please help me. My email is aamiransari111@gmail.com

    ReplyDelete
  3. nan28 December 2011 at 18:59

    Aamir: Please give me more details about your issue. I have not tested this solution for Windows 7, for previous versions this is working.

    ReplyDelete
  4. Ayyappa27 April 2012 at 04:55

    Failed to open a rowset. Details: 42000:[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '`'. Failed to open a rowset. Error in File C:\Users\Ayyappa\AppData\Local\Temp\temp_c9927171-6cfd-459c-bcd9-92d546270802 {3C9B0FA8-B40C-4202-916B-90405B5DEF13}.rpt: Failed to open a rowset.

    ReplyDelete

Post a Comment

Popular posts from this blog

The Power of ChatGPT and Whisper Models

A Deep Dive into Natural Language Processing Natural Language Processing (NLP) has seen a significant boost in recent years due to advancements in artificial intelligence and machine learning. Two models that have shown remarkable success in NLP are ChatGPT and Whisper. In this article, we will delve into the power of these models and their applications in the field of NLP. ChatGPT is a transformer-based language model developed by OpenAI that uses unsupervised learning to predict the next word in a sentence based on the context of previous words. ChatGPT is a generative model that is trained on large datasets of text, such as books and articles, and can be fine-tuned for specific tasks, such as question-answering or dialogue generation. ChatGPT is known for its ability to produce human-like text, making it an ideal tool for applications such as chatbots, content creation, and language translation. Whisper, on the other hand, is a paraphrasing model developed by Google that is based on...
Post a Comment
Read more

SMPP protocol library for fast and easy SMSC(Short Message Service Centre) client development even for non-telecom guys

SMS sending through .NET C# is really easy. But most of the guys face many issues with SMSC client developments. SMPP protocol has many parameters to configure, but for simple SMPP gateway application you need very few of them to configure correctly. This article will cover how to implement SMSC client application using EasySMPP library. EasySMPP is a free SMPP library used by many people to implement SMS sending applications. There are many SMPP libraries but EasySMPP library is very easy to use and relatively stable. EasySMPP library mainly contain five class library projects. KernelParameters, SMPPClient, SMSClient, SMSService and Tools are the library projects and you only need to use SMSClient library to implement SMPP client application. First download EasySMPP library and add class library project to your .NET C# solution.  1. public bool SendSms( string from, string to, string text)
Post a Comment
Read more

Setting up the react native development environment

  This tutorial I am going to focus on how to install and build your first React Native application. There are two methods you can follow to develop React Native app. If you are very new to mobile development and not familiar with setting up mobile development environment, I would suggest to start with Expo CLI. Expo is a set of tools to build React Native application. It has may features; you have to select suitable features to develop your app in minutes. You need only a recent version of Node.js and a phone or emulator. If you want to test your React Native application on your web browser before installing any tools, you may use Snack.   If you are familiar mobile developer from other languages and want to try out React Native, you may try out React Native CLI. For that you need to install either Xcode for iOS or Android Studio for Android OS.   If you are a beginner, my personal suggestion is to go for Expo CLI and familiar with the React Native features and...
Post a Comment
Read more