Thanks Danny. As for 1), I'm a little uncertain as to what I should be checking.
Since I am using dBase tables, I have set the single thread to "true"
to these databases (per Sambar recommendations in the docs).
I'll give the SQL tracing a whirl to see what I can glean for that; good idea.
Michael
Danny Mallory wrote:
> 1)
> Check your odbc definition.. See if your dataset has some thread handling of its own
>that maybe limiting.
>
> 2)
> Turn on SQL tracing in ODBC and see if it points you anywhere. (but dont forget to
>turn it off when you done :) )
>
> As for the maximum number of concurrent TCP connections to winnt and above(2k,xp),
>this defaults to 64000 so I doubt you are running up against that.
>
> my 1 cent.
>
> On 06/Dec/2002 20:53:23, Michael J. Cook wrote:
> > Worth a try. Thanks James.
> >
> > James Wright wrote:
> >
> > > I have two cents here :-) Admittedly I don't deal with dbms much but as for
> > > the connection problem; perhaps run it under the same account as you run
> > > Sambar?
> > >
> > > If it is creating a new connection each time it is accessed, then I can see
> > > the connection limit being exceeded - but working around that so that you're
> > > shifting the weight to be seen as an ongoing connection might make all the
> > > difference.
> > >
> > > Might work, might not. An idea to think about.
> > >
> > > ----- Original Message -----
> > > From: "Michael J. Cook" <[EMAIL PROTECTED]>
> > > To: "sambar List Member" <[EMAIL PROTECTED]>
> > > Sent: Friday, December 06, 2002 5:42 PM
> > > Subject: [sambar] System Resource Exceeded {01}
> > >
> > > > >The other thing is that I'm running Samabar as a Service, and I read
> > > > >in the Microsoft docs that need I may need licensing above 10
> > > > >connections that uses Windows Server Services. Would Sambar as a
> > > > >service not be regarded as a Windows Server Service?
> > > >
> > > > >Sambar should be seen as an app and not a Server Service in Windows.
> > > >
> > > > >The 10 connections only apply to Windows file & print services user
> > > > >connections.
> > > >
> > > > >Alex
> > > > >PS: Pls correct me if I'm wrong
> > > >
> > > > Alex,
> > > >
> > > > Why should Sambar be set up as an app and not a service? I thought there
> > > were
> > > > performance, functionality (fail then restart), and security advantages to
> > > > running as a service.
> > > >
> > > > I gather from the list archives that the 10 connection limit applied to
> > > Windows
> > > > file and print sharing. However, the "System Resource Exceeded" error
> > > message
> > > > only occurred with Sambar's dbms functionality. As soon as that resource
> > > was
> > > > exceeded (through ODBC), Sambar dbms died, but other http requests
> > > continued.
> > > > when I checked my logs, I noticed that the "System Resource Exceeded"
> > > error
> > > > message refers to a 10 connection limit. So, I have a theory.
> > > >
> > > > First my set-up...
> > > >
> > > > Win2K Professional
> > > > Sambar 5.1
> > > > ODBC MDAC 2.7
> > > > Typical Sambar dbms configuration:
> > > > -Max Connections 100
> > > > -Min Connections 1
> > > > -Idle Timeout 1 min
> > > >
> > > > Now the theory...
> > > >
> > > > Windows ODBC is built to work with the Win2k OS (obviously). The OS sees
> > > the 10
> > > > connection limit that the ODBC is trying to exceed, refuses additional
> > > > connections, and somehow kills ODBC and/or Sambar dbms stops responding.
> > > >
> > > > If I'm way out in left field, start calling me back in right now ;-))
> > > > -------------------------------------------------------
> > > > To unsubscribe please go to <A TARGET="_blank"
>HREF="http://www.sambar.ch/list/";>http://www.sambar.ch/list/</A>
> > > >
> > > >
> > > >
> > > -------------------------------------------------------
> > > To unsubscribe please go to <A TARGET="_blank"
>HREF="http://www.sambar.ch/list/";>http://www.sambar.ch/list/</A>
> > -------------------------------------------------------
> > To unsubscribe please go to <A TARGET="_blank"
>HREF="http://www.sambar.ch/list/";>http://www.sambar.ch/list/</A>
> >
> >
> >
> -------------------------------------------------------
> To unsubscribe please go to http://www.sambar.ch/list/
--
Michael J. Cook
Home Page - http://members.rogers.com/michaeljcook/
-------------------------------------------------------
To unsubscribe please go to http://www.sambar.ch/list/
