Solved

How to modify paradox table from asp pages

Posted on 2011-03-08
5
741 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 5

Expert Comment

by:mayankagarwal
ID: 35068413
The first problem might be "Mode=Read"

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

Author Comment

by:starbase2
ID: 35068619
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
ID: 35068672
mode=ReadWrite
0
 
LVL 5

Expert Comment

by:mayankagarwal
ID: 35068812
0
 

Author Closing Comment

by:starbase2
ID: 35069010
Thanks a lot.
0

Featured Post

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently I was talking with Tim Sharp, one of my colleagues from our Technical Account Manager team about MongoDB’s scalability. While doing some quick training with some of the Percona team, Tim brought something to my attention...
Q&A with Course Creator, Mark Lassoff, on the importance of HTML5 in the career of a modern-day developer.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

630 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