Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.
Course Of The Month
3 days, 4 hours left to enrollBecome 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
Suggested Solutions
| Title | # Comments | Views | Activity |
|---|---|---|---|
| Errror when importing data from Oracle to SQL | 6 | 68 | |
| ODBC failure when running MSACCESS query a second time. | 5 | 58 | |
| Wordpress - Updating All Posts on Website | 3 | 96 | |
| I really need your help with access query | 9 | 32 |
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
A company’s centralized system that manages user data, security, and distributed resources is often a focus of criminal attention. Active Directory (AD) is no exception. In truth, it’s even more likely to be targeted due to the number of companies …
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
Learn how to create flexible layouts using relative units in CSS. New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).
Suggested Courses
Course of the Month3 days, 4 hours left to enroll
752 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.