[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference orarep::nomahs::odbc_rdb_driver

Title:	DEC ODBC Driver
Notice:	DEC ODBC Driver V2.0 Now Available
Moderator:	SQLSRV::MAVRIS

Created:	Tue Dec 29 1992
Last Modified:	Fri Jun 06 1997
Last Successful Update:	Fri Jun 06 1997
Number of topics:	1357
Total number of notes:	4864

1351.0. "Many SQL Services processes being created" by ORAREP::TURRIS::16.172.240.185::sullivan () Fri May 30 1997 02:41

It seems that more SQL Services processes are being
created than they used to be - I had to bump up
the process limit recently, even though I am 
the only client.  I think this happened after 
I upgraded the Oracle ODBC RDB driver to
2.10.1100. (not sure what version I had before
that). 

As an example, if I simply open a table with 
Access, it creates 3 processes. I have included 
the log file that was generated by this below.

I'm running on NT 4.0 Workstation SP3, and 
I am using Access 97.

Greg.
--------------------------------------------------------------------------
Oracle ODBC 32 Bit Driver for Rdb Version         2.10.11.0.0
Oracle ODBC 32 Bit Driver for Rdb File Version    2.10.11.0.0

....DSN=parts_vms;SVR=groote.shl.dec.com;CLS=generic;DATABASE=attach 'file
....name disk_hardware:[general.data.rdb]s_parts.rdb';XPT=2;CSO=1;DBA=W;DS
....O=0;
....0X00161AC0: MSACCESS            0X00000000
....0X00161AC0: %SQLSRV-F-GETACCINF, SQL Services authorization failed
....0X00161AC0: MSACCESS            0X00000000
....0X0015F648: SELECT Config, nValue FROM MSysConf
....0X0015F648: %SQL-F-RELNOTDEF, Table MSYSCONF is not defined in databas
....e or schema
....0X0015F648: SELECT T_PART.C_PART_NUMBER FROM T_PART 
....DSN=parts_vms;UID=sullivan;PWD=************;SVR=groote.shl.dec.com;CLS
....=generic;DATABASE=attach 'filename disk_hardware:[general.data.rdb]s_p
....arts.rdb';XPT=2;CSO=1;DBA=W;DSO=0;
....0X00160478: MSACCESS            0X00000000
....0X00160478: MSACCESS            0X00000000
....0X001620F0: SELECT C_PART_NUMBER,C_DATE,C_DESCRIPTION,C_VENDOR,C_VENDO
....R_PN,C_STATUS,C_PURCHASED,C_VENDOR_PN_ONLY,C_PROJECT,C_REQUESTOR_BADGE
....,C_VMS_DATE  FROM T_PART  WHERE C_PART_NUMBER = ? OR C_PART_NUMBER = ?
.... OR C_PART_NUMBER = ? OR C_PART_NUMBER = ? OR C_PART_NUMBER = ? OR C_P
....ART_NUMBER = ? OR C_PART_NUMBER = ? OR C_PART_NUMBER = ? OR C_PART_NUM
....BER = ? OR C_PART_NUMBER = ?
....0X001620F0: Rows Fetched =      0X0000000A
....0X001620F0: Rows Fetched =      0X0000000A
....0X001620F0: Rows Fetched =      0X0000000A
....0X001620F0: Rows Fetched =      0X0000000A
....0X001620F0: Rows Fetched =      0X0000000A
....0X001620F0: Rows Fetched =      0X0000000

T.R Title User Personal
Name Date Lines

1351.1 the driver is doing what the client requested... M5::JBALOGH Fri May 30 1997 09:10 7

T.R	Title	User	Personal Name	Date	Lines
1351.1	the driver is doing what the client requested...	M5::JBALOGH		`Fri May 30 1997 09:10`	7
	6.1 and older create a new server process every time the client issues a native ODBC SQLDriverConnect or SQLConnect statement. In SQLSRV 7.0, you can have 1 executer preform transactions for many connections (transaction reusable servers) but these have drawbacks... John

    6.1 and older create a new server process every time the client issues
    a native ODBC SQLDriverConnect or SQLConnect statement. 
    
    In SQLSRV 7.0, you can have 1 executer preform transactions for many
    connections (transaction reusable servers) but these have drawbacks...
    
    John