February 13, 2006 at 1:59 pm
background: all four servers are SQL 2K, SP4, Standard Edition
local servers: SQLSRV01 and SQLSRV02
remote servers: XSQLSRV01 and XSQLSRV02
obviously there are differences between the OLE-DB and ODBC dll versions (see listing below)...
the symptom:
DBLINKS work fine between SQLSRV01 and SQLSSRV02
DBLINKS fail, or perform sporadically between XSQLSRV01 and XSQLSRV02
two questions:
1) do you think the differences between the driver versions would explain the dblinks performance (work on local servers, fail on remote servers) ?
2) is there a relatively straight forward way to resolve the differences?
SQLSRV01 - 5.00.2195.7069 C:\WINNT\system32\GDI32.dll
SQLSRV02 - 5.00.2195.7073 C:\WINNT\system32\GDI32.dll
XSQLSRV01 - 5.00.2195.7011 C:\WINNT\system32\GDI32.dll
SQLSRV01 - 2000.80.0728.0000 C:\WINNT\system32\SQLUNIRL.dll
SQLSRV02 - 2000.80.2039.0000 C:\WINNT\system32\SQLUNIRL.dll
SQLSRV01 - does not have this DLL
XSQLSRV01 - C:\Program Files\Microsoft SQL Server\MSSQL$BKUPEXEC\Binn\xpsqlbot.dll
SQLSRV01 - 2000.85.1117.0000 C:\Program Files\Common Files\System\OLE DB\sqloledb.dll
XSQLSRV01 - 2000.85.1022.0000 C:\Program Files\Common Files\System\OLE DB\sqloledb.dll
SQLSRV01 - 2.81.1117.0000 C:\WINNT\system32\MSDART.DLL
XSQLSRV01 - 2.80.1022.0000 C:\WINNT\system32\MSDART.DLL
SQLSRV01 - 2.81.1117.0000 C:\Program Files\Common Files\System\OLE DB\MSDATL3.dll
2.81.1117.0000 C:\Program Files\Common Files\System\OLE DB\oledb32.dll
2.81.1117.0000 C:\Program Files\Common Files\System\OLE DB\OLEDB32R.DLL
XSQLSRV01 - 2.80.1022.0000 C:\Program Files\Common Files\System\OLE DB\MSDATL3.dll
2.80.1022.0000 C:\Program Files\Common Files\System\OLE DB\oledb32.dll
2.80.1022.0000 C:\Program Files\Common Files\System\OLE DB\OLEDB32R.DLL
SQLSRV01 - 3.525.1117.0000 C:\WINNT\system32\ODBC32.dll
XSQLSRV01 - 3.525.1022.0000 C:\WINNT\system32\ODBC32.dll
SQLSRV01 - 2000.80.0728.0000 C:\WINNT\system32\SQLUNIRL.dll
XSQLSRV01 - 2000.80.2039.0000 C:\WINNT\system32\SQLUNIRL.dll
SQLSRV01 - 2000.85.1117.0000 C:\Program Files\Common Files\System\OLE DB\SQLOLEDB.RLL
XSQLSRV01 - 2000.85.1022.0000 C:\Program Files\Common Files\System\OLE DB\SQLOLEDB.RLL
Joe Burdette
hanesbrands.com
February 13, 2006 at 2:39 pm
Have you tried using cliconfg.exe to create an alias that uses the fully quailfied domain name in the server name?
It could be a WINS name resultion that is causing the issue.
Tim S
February 13, 2006 at 2:44 pm
If you want to try putting the same drivers just install MDAC 2.8 SP1
http://support.microsoft.com/kb/899456
AS-IS No Warrenty
Tim S
Download link: http://www.microsoft.com/downloads/details.aspx?familyid=78cac895-efc2-4f8e-a9e0-3a1afbd5922e&displaylang=en
February 14, 2006 at 7:45 am
thanks for your initial input... I'll take a look at cliconfig.exe...
more background... the servers where dblinks are functioning properly are our primary production servers...
the NON-functioning servers were built as failover servers... dblinks have never performed properly on these servers!
from what I can see, the environment where the links are working properly, actually have the older minor versions for most DLL's installed...
😐
Joe Burdette
hanesbrands.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply