Thanks Mark,
I changed the transactions property to 1 and the error message disappeared. I'll use the settings you sent, and test again.
Paul
>Here are my view and connection properties that differ from yours. My Transactions property is set to 1. You might also want to change the ShareConnection property to TRUE. I am also connecting to Oracle with no problems with the settings below.
>
>** View Properties
>
>DBSetProp('V_ADDRESS_HISTORY', 'View', 'FetchSize', -1)
>DBSetProp('V_ADDRESS_HISTORY', 'View', 'MaxRecords', -1)
>DBSetProp('V_ADDRESS_HISTORY', 'View', 'ShareConnection', .T.)
>
>** Connection Properties
>
>DBSetProp('NPDES', 'Connection', 'BatchMode', .T.) && irrelevent?
>DBSetProp('NPDES', 'Connection', 'ConnectTimeOut', 15) && irrelevent?
>DBSetProp('NPDES', 'Connection', 'Transactions', 1)
>
>>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', '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', '')
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only