Conference amcucs::ms-sqlsvr

374.0. "General SQL, max DBPROCESS already allocated" by VAXSPO::INFO_RIBERTO () Tue May 13 1997 07:35

    Hello,
    
    I have a project that use the follow architecture :
    
    - A PC running Windows 95( pentiun 133 16Mb RAM) with Delphi2.0 C/S version 
    - accessing a Data Base SQLServer 6.5 running under Windows NT 4.0 on
      a Alpha Plataform
    - the protocol used is TCP/IP
    
    My problem is :
    
    When the application starts and the initial section open the tables
    ( using tb_xxx.open command ) on create event of the form, the 
    sequence of open is executed ( I used the debug mode to trace the
    opens ) normally, sudenly the application fails over on a open table.
    The total number of table to be opened is about 20 tables and the error is
    not returned in a specificly table, but in a certain of number of
    opened tables ( I changed the order of tables and the error occurred in a 
    different table ).
    
    The error message returned is :
    " General SQL error. Maximum number of DBPROCESS already allocated "
  
    Any points will be very appreciated, cause I'm in deploy phase of my
    project and I don't know if the problem is a bad configuration of
    SQLserver or bad configuration of BDE link or something about Delphi
    configuration.
    
    	Please,	Waiting for anybody save me.
    
    	Thanks.    Riberto.
    
    

    
    With sp_configure, how many user connections do you have allocated? 
    

    I have allocated 250 connections and I have opened about 20 tables.
    
    By the way, I'm using ttable object in my project. Is there any problem
    when use this kind of object more than 20 ? Could be a limitation of
    SQLserver or a problem of Delphi 2.0 ?
    
    Thanks for while.
    
    				Riberto