Solved

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

Posted on 2009-05-19
4
3,429 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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

707 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now