>>Hi,
>>
>>My client has recently upgraded from Oracle 7 to Oracle 8. We have now switched from Oracle's odbc driver to MS ODBC driver for Oracle (version 2.573.3711).
>>
>>I'm using a vfp remote view. When I try tableupdate() I get a connectivity error - 'Invalid Transaction State'.
>>
>>Any ideas??? Thanks
>>
>>Paul
>
>Could you run GENDBC against the database, and post the code section for the view that has all the DBSetProp VIEW property values?

Hi Mark,

Thanks very much for having a look. Here is the dbsetprop code for view:


=DBSetProp('RV_PLSINS', 'View', 'UpdateType', 1)
=DBSetProp('RV_PLSINS', 'View', 'WhereType', 1)
=DBSetProp('RV_PLSINS', 'View', 'FetchMemo', .F.)
=DBSetProp('RV_PLSINS', 'View', 'SendUpdates', .T.)
=DBSetProp('RV_PLSINS', 'View', 'UseMemoSize', 255)
=DBSetProp('RV_PLSINS', 'View', 'FetchSize', 100)
=DBSetProp('RV_PLSINS', 'View', 'MaxRecords', -1)
=DBSetProp('RV_PLSINS', 'View', 'Tables', 'PLSINS')
=DBSetProp('RV_PLSINS', 'View', 'FetchSize', 100)
=DBSetProp('RV_PLSINS', 'View', 'ParameterList', "vp_insp_fnm,'C';vp_insp_lnm,'C'")
=DBSetProp('RV_PLSINS', 'View', 'Comment', "")
=DBSetProp('RV_PLSINS', 'View', 'BatchUpdateCount', 1)
=DBSetProp('RV_PLSINS', 'View', 'ShareConnection', .F.)
=DBSetProp('RV_PLSINS', 'View', 'Prepared', .F.)
=DBSetProp('RV_PLSINS', 'View', 'CompareMemo', .T.)
=DBSetProp('RV_PLSINS', 'View', 'FetchAsNeeded', .F.)

I see the parameter list got truncated.

I've added the code for the connection properties. The transactions is set to '0'. I wonder it that means anything.


=DBSetProp('CONNECT_PIPELINE_ORACLE', 'Connection','Asynchronous', .F.)
=DBSetProp('CONNECT_PIPELINE_ORACLE', 'Connection', 'BatchMode', .F.)
=DBSetProp('CONNECT_PIPELINE_ORACLE', 'Connection', 'Comment', '')
=DBSetProp('CONNECT_PIPELINE_ORACLE', 'Connection', 'DispLogin', 0)
=DBSetProp('CONNECT_PIPELINE_ORACLE', 'Connection', 'ConnectTimeOut', 0)
=DBSetProp('CONNECT_PIPELINE_ORACLE', 'Connection', 'DispWarnings', .F.)
=DBSetProp('CONNECT_PIPELINE_ORACLE', 'Connection', 'IdleTimeOut', 0)
=DBSetProp('CONNECT_PIPELINE_ORACLE', 'Connection', 'QueryTimeOut', 0)
=DBSetProp('CONNECT_PIPELINE_ORACLE', 'Connection', 'Transactions', 0)
=DBSetProp('CONNECT_PIPELINE_ORACLE', 'Connection', 'Database', '')


Thanks again.

Paul