Solved

How to modify paradox table from asp pages

Posted on 2011-03-08
5
732 Views
Last Modified: 2012-05-11
Hello,

I'm working in ASP and I need to modify contents on a Paradox table. I'm able to connect to list contents with this string connection:

odbc_paradox="Provider=MSDASQL;Persist Security Info=False;Mode=Read;Extended Properties='DSN=Paradox;DBQ=f:\accesoparadox\db;DefaultDir=f:\accesoparadox\db;DriverId=538;FIL=Paradox 7.X;MaxBufferSize=2048;PageTimeout=600;';Initial Catalog=f:\accesoparadox\db;"

As I say, I can read from the tables, but when I try to update some content:

  SQL = "UPDATE NAMES SET "
  SQL = SQL & "name='name' WHERE id_NAME='00000'"        
  SET rec = Bb.Execute(SQL)

I get this error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][Controlador ODBC Paradox] La operación debe usar una consulta actualizable.
(that translated says that the operatin must use a updatable query)

Can anyone tell me how can I convert my connection string in a updatable way to modify the table?
Thanks a lot and Kind Regards.
0
Comment
Question by:starbase2
  • 3
  • 2
5 Comments
 
LVL 5

Expert Comment

by:mayankagarwal
Comment Utility
The first problem might be "Mode=Read"

Second give the write permission to f:\accesoparadox folder.
0
 

Author Comment

by:starbase2
Comment Utility
Thanks, when I set "Mode=Write" the error changes to:

Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

I'm going to re-assign write permission to folder (there was, but I'm going to take it out and reassign again)
0
 
LVL 5

Accepted Solution

by:
mayankagarwal earned 500 total points
Comment Utility
mode=ReadWrite
0
 
LVL 5

Expert Comment

by:mayankagarwal
Comment Utility
0
 

Author Closing Comment

by:starbase2
Comment Utility
Thanks a lot.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
Any business that wants to seriously grow needs to keep the needs and desires of an international audience of their websites in mind. Making a website friendly to international users isn’t prohibitively expensive and can provide an incredible return…
This tutorial demonstrates how to identify and create boundary or building outlines in Google Maps. In this example, I outline the boundaries of an enclosed skatepark within a community park.  Login to your Google Account, then  Google for "Google M…
The viewer will get a basic understanding of what section 508 compliance can entail, learn about skip navigation links, alt text, transcripts, and font size controls.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now