Solved

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

Posted on 2009-05-19
4
3,552 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Sql Permission 6 81
tempdb log keep growing 7 56
What is this datetime? 1 33
Parsing this XML works but the other one doesn't 9 36
Article by: Rob
Notes 8.5 Archiving Steps and Tips This article covers setting up a Notes archive, and helps understand some of the menu choices making setting up and maintaining a Notes archive file easier.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

759 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