Problem reading from database

Toco

Hello. I have app written in C# that we are testing. The executable is
shared on our network. The method we are testing is a call to a foxpro
table. The call is made to query the table, then fill a datable with the
resultset. All is fine when I run the executable from my machine. However,
when our test user runsthe same executable, the app errors out when
attempting to read from the foxpro table. I have logged where the user
connects to the database, but a rather unhelpfull error dialog is returned:
Attempted to read or write protected memory. This is often an indication
that other memory is corrupt. I have narrowed this error occuring at the
data-adapter.FILL method(data-table). What I'm at a loss is why the error
occurs while our user tests this method, yet does not fail when I test. I
have ensured that our user has .NET 2.0 and has READ permission for the fox
pro table.

Any thoughts or ideas, something missing that is required for foxpro or ADO?

Jul 3 '06 #1

Subscribe Reply

2163

Cor Ligthert [MVP]

Toco

I changed the subject and trying to make this visible to the FoxPro guys and
especially girls.

You can try this as well in a FoxPro newsgroup, there are very much people
active who know about Net programming.

Cor
"Toco" <To**@discussio ns.microsoft.co mschreef in bericht
news:A8******** *************** ***********@mic rosoft.com...

Hello. I have app written in C# that we are testing. The executable is
shared on our network. The method we are testing is a call to a foxpro
table. The call is made to query the table, then fill a datable with the
resultset. All is fine when I run the executable from my machine.
However,
when our test user runsthe same executable, the app errors out when
attempting to read from the foxpro table. I have logged where the user
connects to the database, but a rather unhelpfull error dialog is
returned:
Attempted to read or write protected memory. This is often an indication
that other memory is corrupt. I have narrowed this error occuring at the
data-adapter.FILL method(data-table). What I'm at a loss is why the error
occurs while our user tests this method, yet does not fail when I test. I
have ensured that our user has .NET 2.0 and has READ permission for the
fox
pro table.

Any thoughts or ideas, something missing that is required for foxpro or
ADO?

Jul 4 '06 #2

Cindy Winegarden

Thanks Cor!

Toco,

It really helps to post your connection string and the code you are using.
Also, be sure the user has the latest FoxPro and Visual FoxPro OLE DB data
provider, downloadable from msdn.microsoft. com/vfoxpro/downloads/updates .

If you write a really simple (console) app to access a single table do you
have this problem? Does it occur on any particular table or on all of them?
What is the data structure of your table? Does it happen if you make a
really simple DBF and work against that table? ( sqlCommand = "Create Table
MyTable (Field1 I, Field2 C(10))" )

This error appears to be a .NET error and is not limited to accessing FoxPro
tables. A Google search on "Attempted to read or write protected memory"
brought up a lot of threads, and if you go over these you may find something
that fits your situation. Among the suggestions is that .NET doesn't work
correctly with some data types and also that uninstalling/reinstalling the
..NET framework may help. I haven't seen a concrete answer that is a total
fix for the issue.

--
Cindy Winegarden MCSD, Microsoft Most Valuable Professional
ci***@cindywine garden.com
"Cor Ligthert [MVP]" <no************ @planet.nlwrote in message
news:O4******** ******@TK2MSFTN GP03.phx.gbl...

Toco

I changed the subject and trying to make this visible to the FoxPro guys
and especially girls.

You can try this as well in a FoxPro newsgroup, there are very much people
active who know about Net programming.

Cor
"Toco" <To**@discussio ns.microsoft.co mschreef in bericht
news:A8******** *************** ***********@mic rosoft.com...
>Hello. I have app written in C# that we are testing. The executable is
shared on our network. The method we are testing is a call to a foxpro
table. The call is made to query the table, then fill a datable with the
resultset. All is fine when I run the executable from my machine.
However,
when our test user runsthe same executable, the app errors out when
attempting to read from the foxpro table. I have logged where the user
connects to the database, but a rather unhelpfull error dialog is
returned:
Attempted to read or write protected memory. This is often an indication
that other memory is corrupt. I have narrowed this error occuring at the
data-adapter.FILL method(data-table). What I'm at a loss is why the
error
occurs while our user tests this method, yet does not fail when I test.
I
have ensured that our user has .NET 2.0 and has READ permission for the
fox
pro table.

Any thoughts or ideas, something missing that is required for foxpro or
ADO?

Jul 5 '06 #3

Similar topics

3020

Problem reading data out of MySQL db, PHP variables

by: Dariusz | last post by:

Below is part of a code I have for a database. While the database table is created correctly (if it doesn't exist), and data is input correctly into the database when executed, I have a problem when reading out the data into the PHP variables / array. It should be displaying the information out in the following way, using the PHP array: n_date, n_headline, n_summarytext, n_fulltext

PHP

2416

Upload Problem Using ASP

by: NohaKhalifa | last post by:

Dear All; I'm developing a web site and i need to make adminisration for this site it's a site for Real Estates . But I don't need the administration to be online .. I want them to fill data and images offline and then send them online... but i have a problem regarding the images i want it to be sent to the web site So i want if there is a possible way to fill data offline and

ASP / Active Server Pages

12652

Read-Only Problem with Access Database

by: Graham Taylor | last post by:

I've tried posting this in the 'microsoft.public.access' but I will post it here also, as I think it might be the webserver which is causing my problem. --------- I have an Access 2003 database which is in the "fpdb" folder of my webserver. Its located there so that I can use asp to build a web-based front-end for users to read the database - http://www.nist.ac.th/maths/test1.asp The MBD file is edited using Access (2003) and opening...

ASP / Active Server Pages

7347

Access database and web pages , nubie problem!

by: rob | last post by:

Hi to all. I am pretty new to using Access and am having a problem I hope someone can help me with. I want to access a MS-Access database from a web page. I have managed to get it "sort" of working using MS-Access's 'data access page' function as it were. This creates a web page that is linked to a database table. The problem that I have is that if data in the dbase is changed, it does not immediately reflect

Microsoft Access / VBA

2911

Problem with asp.net app only allowing 1 user at a time

by: jsale | last post by:

I'm currently using ASP.NET with VS2003 and SQL Server 2003. The ASP.NET app i have made is running on IIS v6 and consists of a number of pages that allow the user to read information from the database into classes, which are used throughout the application. I have made class collections which, upon reading from the DB, create an instance of the class and store the DB values in there temporarily. My problem is that if user1 looks at...

ASP.NET

1252

Uploading File Database and Postback Problem

by: needin4mation | last post by:

Hi, I am uploading a file and changing a record in a database. When the database is updated, I retrieve the last_insert_id() to get the latest row key. I also have a Page_Load event that populates controls on the form. The Page_Load gets the information from the database, including the field that has the latest key from my database (say product id). The problem is that my upload event is slower than the Page_Load event

ASP.NET

4313

ExecuteNonQuery - problem

by: b_r | last post by:

Hi, I'm trying to make a simple operation (insert into DB) in VB 2005 and SQL Server. The code is as follows: Dim sConnectionString As String = _ "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\DB.mdf....

Visual Basic .NET

5751

Problem: Performance difference between MSDE and SQL Express 2005

by: HC | last post by:

Hello, all, I started out thinking my problems were elsewhere but as I have worked through this I have isolated my problem, currently, as a difference between MSDE and SQL Express 2005 (I'll just call it Express for simplicity). I have, to try to simplify things, put the exact same DB on two systems, one running MSDE and one running Express. Both have 2 Ghz processors (one Intel, one AMD), both have a decent amount of RAM (Intel system...

Microsoft SQL Server

1705

MYSQL Problem

by: nrip | last post by:

Dear All, I am facing a very peculiar problem. I am reading a CSV file from my JSP code and trying to insert them into MYSQL database. the program first reads a line and then splits it into words using the split function and then inserts them into different fields of the database. But the problem is that the JSP ; token=line.split(" "); DateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd");

Java

1927

output problem

by: aljaber | last post by:

hi, i am facing a problem with my program output here is the program /*********************************************\ * CD Database * * * \*********************************************/

C / C++

8732

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8605

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

7330

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6166

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5632

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4155

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4306

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2726

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1615

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General