Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

How to modify paradox table from asp pages

Posted on 2011-03-08
5
Medium Priority
?
745 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 2000 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

Without even knowing it, most of us are using web applications on a daily basis.  In fact, Gmail and Yahoo email, Twitter, Facebook, and eBay are used by most of us daily—and they are web applications. We generally confuse these web applications to…
Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

916 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