asked on
How to modify paradox table from asp pages
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.
ASPDatabasesWeb Development
Last Comment
starbase2
ASKER
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)
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
for details check
http://msdn.microsoft.com/en-us/library/ms133428.aspx
http://msdn.microsoft.com/en-us/library/ms133428.aspx
ASKER
Thanks a lot.
Second give the write permission to f:\accesoparadox folder.