Bob,
I have the enterprise manager utils here to access the server, but I don't see where I can see the actual logins. Can you define that for me...(Appreciate it).
I also checked my remote view defaults under options and its set as shared connection. What should the default timeouts be?
I found an article on M$ that discusses this exact problem of opening and closing connections to rapidly, Article ID: Q170652. I guess if I can figure out how to view those connections I should be able to get this working. Thanks for all the help.
>>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)