Hello,
I understand that you encountered intermittent errors regarding "Data
source name not found and no default driver specified'" on heavy load. If
I'm off-base, please let me know.
Based on my research, there is some known issue in odbc driver in MDAC
before 2.7. I'd like to know if you have installed latest MDAC 2.8 sp2 to
test.
How to obtain the latest MDAC 2.8 service pack
http://support.microsoft.com/kb/884103/ You may want to boost the MaxUserPort and decrease TCPTimedWaitDelay
328476 Description of TCP/IP settings that you may have to adjust when SQL
Server connection pooling is disabled
http://support.microsoft.com/default.aspx?scid=kb;EN-US;328476 Because you use odbc dsn to connect to SQL server, you may also consider
use sql oledb provider directly without using DSN to isolate the issue. As
I know, ODBC driver for SQL Sesrver has not been updated for a while.
Since the issue occurs randomly and only appears under heavy load, we may
not be able to reproudce on our side. To find out the root cause of this
issue we may need to analyze memory dumps or live debug, this work has to
be done by contacting Microsoft Product Support Services. Therefore, we
probably will not be able to resolve the issue through the newsgroups. If
above steps don't help, I recommend that you open a Support incident with
Microsoft Product Support Services so that a dedicated Support Professional
can assist with this case. If you need any help in this regard, please let
me know.
For a complete list of Microsoft Product Support Services phone numbers,
please go to the following address on the World Wide Web:
http://support.microsoft.com/directory/overview.asp If you have any questions or concerns on this, please feel free to let's
know. Thank you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif ications
<
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>. Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<
http://msdn.microsoft.com/subscriptions/support/default.aspx>. ==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
