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.
Course Of The Month
Become a Premium Member and unlock a new, free course in leading technologies each month.
Solved
How to modify paradox table from asp pages
Posted on 2011-03-08
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=MSD
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.
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=MSD
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.
[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
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)
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)
for details check
http://msdn.microsoft.com/en-us/library/ms133428.aspx
http://msdn.microsoft.com/en-us/library/ms133428.aspx
Featured Post
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.
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.
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month3 days, 17 hours left to enroll
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.