We have a web-based application making connections to a database on a
separate server. We are getting intermittant communication errors
during the connection process. I have attached our error log and logs
from the dsn from both a successful and a failure connection
attempt.

The error seems to be related to the the volume of activity on the
webserver. Task manager shows plenty of memory on the server
available and the cpu is chugging along at about 10% utilization.

Currently we're getting the problem on about 1 out of 200 connection
attempts.

Thanks in advance for your help.

James Clanton

---------------------------------------------------------------------------------------------------------------------------------------
Following is the error message recorded by our application
---------------------------------------------------------------------------------------------------------------------------------------
Comment: Description = Connection error: Unable to initialize
requested communication links
Source = SAOLEDB.11
SQL State = 08001
Error Number = -2147217843
Native Error Number = -832

IEWDOLDB=105003
Module=
Version=<12.00Bj>

MDAC Version = <2.82.3959.0>.



[Connection parameters]
DataSource =
Initial Catalog = <>
Provider =
User =
Password = <,###>
Extended Info =
Access =

[Connection settings]
ConnectionTimeout = <-1>
CommandTimeout = <0>

[Data format]
Query Parameter Checked = <0> = <>
Query Parameter Needing conversion = <0> = <>
DecimalSeparator =
DateFormat = <>

[Cursor settings Match]
LockType = , Location = , Type = , Capacities =
LockType = , Location = , Type = , Capacities =
LockType = , Location = , Type = , Capacities =

---------------------------------------------------------------------------------------------------------------------------------------
Following are two connections from the log tshowing one failure and
one success that occurred in the same second
---------------------------------------------------------------------------------------------------------------------------------------
Tue Aug 31 2010 15:38:03
15:38:03 Attempting to connect using:
UID=dba;PWD=********;DBN=pb_asp;ENG=hosted;CON=SQL _DBC_1cb6388;ASTOP=NO;INT=NO;DBG=YES;LOG=c:
\temp\pb_asp_connection.log;DMRF=NO;LINKS=TCPIP{}; COMP=NO
15:38:03 Attempting to connect to a running server...
15:38:03 Trying to start TCPIP link ...
15:38:03 TCP using Winsock version 2.2
15:38:04 My IP address is 192.168.100.37
15:38:04 My IP address is 127.0.0.1
15:38:04 TCPIP communication link not started
15:38:04 Unable to initialize requested communication links
15:38:04 Cannot connect to server

Tue Aug 31 2010 15:38:21
15:38:21 Attempting to connect using:
UID=dba;PWD=********;DBN=pb_asp;ENG=hosted;CON=SQL _DBC_1cb6480;ASTOP=NO;INT=NO;DBG=YES;LOG=c:
\temp\pb_asp_connection.log;DMRF=NO;LINKS=TCPIP{}; COMP=NO
15:38:21 Attempting to connect to a running server...
15:38:21 Trying to start TCPIP link ...
15:38:21 TCP using Winsock version 2.2
15:38:21 My IP address is 192.168.100.37
15:38:21 My IP address is 127.0.0.1
15:38:21 TCPIP link started successfully
15:38:21 Attempting TCPIP connection (address 192.168.100.46:2638
found in sasrv.ini cache)
15:38:21 Trying to find server at cached address 192.168.100.46:2638
without broadcasting
15:38:21 Found server, verifying server name
15:38:21 Found database server at address 192.168.100.46
15:38:21 Found database server hosted on TCPIP link
15:38:21 Connected using client address 192.168.100.37:1816
15:38:21 Connected to server over TCPIP at address 192.168.100.46:2638
15:38:21 Connected to SQL Anywhere Server version 11.0.1.2405
15:38:21 Application information:
15:38:21
IP=192.168.100.37;HOST=WBASTRO;OSUSER=Administrato r;OS='Windows 2003
Build 3790 Service Pack 2';EXE=C:
\WebDev12\WD120Session.exe;PID=0x890;THREAD=0xadc; VERSION=11.0.1.2044;API=OLEDB;TIMEZONEADJUSTMENT=-240
15:38:21 Connected to the server, attempting to connect to a running
database...
15:38:21 [32286] Connected to database successfully
15:38:27 [32095] Client disconnected