We have the Merant 3.6 sql-92 ODBC driver , set up to connect with our progress 9.1D database. I've been developing ,to date, app's which only 'get' data, in mostly vb 6.0 using ADO and recordsets.
I now need to to some data modifications , I've been trying to use the .Update method with my recordset , with various combinations of 'cursor' and 'lock' settings, still keep getting 'Access denied' error message, I'm sure it has to do with my ODBC set-up/ permissions, etc.
We have set our Merant driver up with a different user name than 'sysprogress'. Would I need to use a different 'DSN' than has log-ins that allow changing data?
Thanks.
I now need to to some data modifications , I've been trying to use the .Update method with my recordset , with various combinations of 'cursor' and 'lock' settings, still keep getting 'Access denied' error message, I'm sure it has to do with my ODBC set-up/ permissions, etc.
We have set our Merant driver up with a different user name than 'sysprogress'. Would I need to use a different 'DSN' than has log-ins that allow changing data?
Thanks.