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.
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.