Incorrect environment: Windows XP SP2, Delphi7, remote ms SQL Server 2000 Enterprise Edition
Error: Use BDE to connect to the remote ms SQL Server 2000 database. When the connection is opened, the error message "DB-library network communciations layer not loaded." appears.
Solution: Replace the ntwdblib. dll file under Windows Server 2003 Enterprise Edition with the c: \ windows \ system32 directory in Windows XP.
Error Analysis: it is normal to connect to a remote ms SQL Server 2003 database using Windows Server 2000 Enterprise Edition and Delphi7. It should be a data connection driver problem, but it can be ruled out by BDE, according to my personal inference, it should be the problem that the ms SQL Server 2000 client is connected to the driver. After checking, we found the ntwdblib under Windows XP SP2. the DLL file version is: 1998.11.20., and ntwdblib under Windows Server 2003 Enterprise Edition. the DLL file version is 2000.80.194.0. I guess the version is ntwdblib of 1998.11.20. dll should support up to 7.0 ms SQL Server version