Data provider internal error("-3000")

Question

Sometime i get this error from OracleDataReader. I'm using asp.net and oracle DB 9.2 with Oracle Data Provider for .NET 9.2.0.2.102 I couldn't find any descriptive and logical cause for this error. Im using datareader to retrive a largea amount of records from the DB (sometime 400.000 records), but i can not see why this could be a problem, the whole operation takes 10-12h to finish, but sometimes it is succesfull. Memory consumption is low. I retrieve data and write them to a text file. Can anyone has some clue what coulb be the cause for this problem. Thanks in advance.

Answer 1

It all depends on your application, if these values are user specific and your application will be used by the same user from a different machine then storing in the DB would make sense as these information can be accessed by that user from any where. If these values should only be used from his machine then you might as well store it in the AppSettings of the application.

I am assuming that it is a winform application installed on users machine.

Answer 2

yes that would work only if you share the exe file, if for any reason if you need to change any other information in the config file that requires redeployment then you need to make sure that your code creates the same settings file for each user, or other options are user registry or a file in users folder.

Answer 3

Hi Javeed

Thanks for the help. I got the idea..

But, I have a question, If I want to send my exe file to another user so that he can work on it also, will this work on his computer as well? lets say if I create in my project/form 3buttons, one for the default settings, one for the store settings and one for resetting. Those buttons work fine with me, because I'm the one who developed this app, but what if I need to send it to some one else?

Answer 4

In your project's property pages, go to the Settings page, and define your settings. For example you created settings with the same Settings1, so this is how you use in your application:

// Read settings

textBox1.Text = Properties.Settings.Default.Settings1;

// Write settings

Properties.Settings.Default.Settings1 = TextBox2.Text;

// Save settings

Properties.Settings.Default.Save();

these will be saved in the application settings file present on the users machine for that user.

Answer 5

Hi Javeed


it is Windows form application and the values are user  specific. Lets assume that I need to save the setting in my machine, how to use the appSettings of the application to achieve this? I found some articles and answers when I googled it, but still couldn't get the idea. ...