>In my application I have one (1) remote connection defined. I have "Share Connection" turned on. Up until today I had no problems connecting. After adding a couple of more views I get the error:
>
>"The maximum number '15' configured user connections are already connected. System administrator can configure to a higher value..."
>
>That would be fine except it takes a lot of memory per user, and I don't understand why I have 15 open connections (I'm the only one accessing the server). Maybe its because I havent closed a view I'm using after =REQUERY but then again, I guess I don't know how to close a view connection yet maintain the data on the local system. I thought views were automatically closed after the REQUERY command. Am I wrong? Thanks for your help.
>
>Gary

How do you close the remote connection? I code mine using SQLConnect() to establish the connection. Then SQLDisconnect to close the connection. AFAIK, ReQuery does not open another connection, it just used the one already established. Just FMI (not FYI), is this an Oracle connection?