>Hi,
>
>we have a VFP 6.0 application in development that uses about 11 remote views (for tables located on an Oracle server.) This is working fine, except that the DBA called us last week saying each user testing the program was taking up 11 connections to the server, so their Oracle server even ran out of available connections. DOH!
>
>We tried setting "Share connection" in Tools/Options/Remote Data but according to my supervisor (who did the change), this didn't change anything.
>
>We are using the Microsoft ODBC driver for Oracle. The problem occurs with both Oracle 7 and Oracle 8.
>
>Suggestions anyone?
>
>thanks,
>Michel

Just checking that option won't change existing views. You can use DBGetProp and DBSetProp to determine/set this property for each view:

? dbgetprop('MyView','view','shareconnection')
? dbsetprop('MyView','view','shareconnection', .t.)

The syntax for creating a view with shared connection:

create sql view my view remote connection myconnection shared as ...