>but in a test I already tried that. Sometimes success, sometimes it just does not work: The view won't reconnect.
>

Hi Walter,

This may happen with shared connection. If ODBC connection is shared between multiple SPT connections, SQLIDLEDISCONNECT() must be called for all of them, ODBChdbc property should return 0 in order to automatically reestablish "broken" connection.

Thanks,
Aleksey.