Solved

<SQL Server>Db-Library network communications layer not loaded

Posted on 2009-05-19
4
3,515 Views
Last Modified: 2013-12-27
We want to use Lotus 123 for DOS, a legacy spreadsheet software, to connect to SQL Server 2005 database. It should be possible, based on the documentation. When I try to connect, I get a Backend DataBase Error. I press F1 and it gives me a message: <SQL Server>Db-Library network communications layer not loaded.

I am not sure what is causing the error.

Lotus provides a DataLens driver which uses the Db-Library supported by older versions of SQL Server instead of ODBC or OLE DB. SQL Server 2005 still supports connections using Db-Library according to their website. I have the Db-Library file (ntwdblib.dll) int the C:\Windows\System32 folder on both computers.

Here is a copy of the text in the C:\Lotus40\Lotus.BCF configuration file:
DN="SQL_Clients" DL="DLSM" DD="DataLens driver for SQL database" AC=UI,PW
DC="$CF SQLSDL $SV LVASQLS $OP PHARES3400";

All the files mentioned in the configuration file are in the C:\Lotus40 folder. PHARES3400 is the name of the computer on which SQL Server is installed; this computer is running WinXP Pro SP2. The Lotus computer is also running WinXP Pro SP2. I don't think we have any connection issues because I can open a connection easily in Excel on the Lotus computer. I have TCP/IP enabled on the database. I have been able to connect to an old FoxPro database, so I know Lotus can do databases.

btw. It is not feasible to upgrade our spreadsheet software. Won't happen!

I am curious to know if there are any experts that still remember how to make Lotus do it's tricks. I need to know what is causing the error and how to fix it.

Thanks in advance




0
Comment
Question by:TadSter
  • 2
  • 2
4 Comments
 
LVL 25

Assisted Solution

by:reb73
reb73 earned 200 total points
ID: 24433215
It could be a problem with the ntwdblib.dll.. I'd suggest that you do a dependency check on this library using the dependency walker application which may indicate any missing dependencies for this library..

http://www.dependencywalker.com/
0
 
LVL 2

Author Comment

by:TadSter
ID: 24434550
Thanks for your reply.

Which computer needs the ntwdblib.dll file? (I installed it on both computers)
I ran DependencyWalker on ntwdblib.dll and got this msg:
Warning: At least one delay-load dependency module was not found.
It said that DWMAPI.DLL was missing.
I found a copy of this file and copied it into the C:\windows\system32 folder. Do I need any kind of install? RegSvr32 needed? (RegSvr32 gave an error) Reboot? (I did reboot)

I ran DependencyWalker again on ntwdblib.dll; now I get only:
Warning: At least one module has an unresolved import due to a missing export function in a delay-load dependent module.

Thanks a bunch for your help. Does this tell you anything. Do you have more advice?
0
 
LVL 25

Assisted Solution

by:reb73
reb73 earned 200 total points
ID: 24443065
DWMAPI.DLL is a Windows Vista (or Windows 2008) specific library which will show up as missing in Dependency Walker if IE7 is installed in the machine.. The missing export function reported by Dependency Walker can never be invoked in previous Windows versions..

I'd expect the ntwdblib.dll file will be required in the client machine to establish connections to SQL Server 2005, though the database has to be set to SQL Server 2000 or older compatibility mode (sp_dbcmptlevel '<DBName>', 80)
to make the queries work correctly..

I can't seem to find any online reference to troubleshoot indicated issue.. The closest one was the link below -

http://blog.pauked.com/?p=83
0
 
LVL 2

Accepted Solution

by:
TadSter earned 0 total points
ID: 24451756
Thanks for the comment. I set SQL Server to an older compatibility mode as you suggested, but it did not make any difference. I still cannot connect. and I still get the same error.

I am not clear what is meant by network communications layer. If you have any help for this, it might point me in the right direction.

I also tried running it on the server machine, but that didn't help.

My idea resource layer has been depleted, please help!


0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

IBM Notes offer Encryption feature using which the user can secure its NSF emails or entire database easily. In this section we will discuss about the process to Encrypt Incoming and Outgoing Mails in depth.
This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question