ODBC Drivers error '80004005'

[Mei]

We got Microsoft OLE DB Provider for ODBC Drivers error
‘80004005’ once a while. The message is [Sybase][ODBC
Driver][Adaptive Server Anywhere] Unable to connect to
database server: Database server not
found/scripts/datanew.asp, line 12.
We checked the SQL Server service and it is still alive and
running.
The database and SQL Server are on the same server machine
that has Windows 2003 Server SP1 installed with 2.8GHZ and
1.0GB of RAM. The ASA version is 8.0.2.4372. The database
connection is through DSN which has following settings:
TCP/IP={host=localhost,dobroadcast=NO}
Shared memory is ON
Liveness timeout is 120 seconds
Idle timeout is 240 seconds
Buffer size is 1460 bytes
No encryption of network packages
Allow multiple record fetching is ON
How can I figure out the problem and fix it?

[Ian McHardy]

It's not clear why you would get that error.

Please enable "Display debugging information in a log file" and provide a
filename on the DSN (the Advanced tab of the Configuration dialog from the
ODBC Administrator). This will add the LogFile parameter to the connection,
and log diagnostic information about the attempted connection to the file.
Please post the portion of this file for the connection attempt which
failed.

--

Ian McHardy (iAnywhere Solutions)

Please reply only to the newsgroup.

Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer
<Mei> wrote in message news:43f26488.4b2...@sybase.com...

[Mei]

Thanks for the tip. I will post another message when I got
more detailed information from the log file.

[Mei]

I reported your suggestion to my manager and she is
concerned if this log file will slow down SQL Server's speed
of processing requests. Could you give me more information
about this? Thanks.

[Greg Fenton]

Mei wrote:
> I reported your suggestion to my manager and she is
> concerned if this log file will slow down SQL Server's speed
> of processing requests. Could you give me more information
> about this? Thanks.
>

This will only log *connection* information. Performance of operations
once the connection has been established will not be affected.

This is *not* the same thing as ODBC tracing, which is probably what
your manager is concerned about.

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

[Mei]

Great! Thanks.