Hi all
Had some very strange prod server errors yesterday, basically this connection string would result in around a 5sec delay per connect, this is reminicient of a MDAC bug in dbnetlib.dll (see KB 300420).
The string was:
Provider=SQLOLEDB.1;Persist Security Info=False;Data Source=10.10.xx.xx,2433;Network Library=DBMSSOCN
I have the client network util on the box, so created an alias called "BILLABONG" and altered as such (via TCPIP):
Provider=SQLOLEDB.1;Persist Security Info=False;Data Source=BILLABONG
and everything was fine once again.
I am a little lost as to what is going on here, we run MDAC 2.8RTM (applied as of sqlserver sp3a and is a new server build from win2003 EE). How can this just no work all of a sudden I dont know.
The instance itself is a named instance, Im not 100% if DNS and/or other names resolution is going on for the IP connect over the SQLOLEDB driver; and if this is to blame. Today, well, all is fine, went back to old connect strings and we havent had a problem all day.
Thoughts?
Cheers
Ck
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"