>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
Have you verified in the remote view designer that share connections is set to true? By default this will be false. Also, if you are using SQL Server, you can use Enterprise manager to check server activity and if you look at the details of the multiple connections you have, you can see the actual SQL statement that was last used by the connection. I open up some 20 - 30 views in my application and always only have 2 connections (one for SQL pass-through to use and one that the views open)
Previous
Next
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