Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Invalid transaction state
Message
 
 
To
18/07/2000 17:00:27
Paul De Niverville
Deniverville Econometric Research Ltd.
Victoria, British Columbia, Canada
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00393886
Message ID:
00394059
Views:
12
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', '')
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform