Solved

How to modify paradox table from asp pages

Posted on 2011-03-08
5
733 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
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Read about achieving the basic levels of HRIS security in the workplace.
Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
This video teaches users how to migrate an existing Wordpress website to a new domain.
The viewer will learn how to count occurrences of each item in an array.

920 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

16 Experts available now in Live!

Get 1:1 Help Now