Link to home
Start Free TrialLog in
Avatar of starbase2
starbase2

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=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.
Avatar of mayankagarwal
mayankagarwal
Flag of India image

The first problem might be "Mode=Read"

Second give the write permission to f:\accesoparadox folder.
Avatar of starbase2
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)
ASKER CERTIFIED SOLUTION
Avatar of mayankagarwal
mayankagarwal
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks a lot.