Solved

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

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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
DIIOP IP Addresses Changes Automatically 5 71
Stored Procedure error 45 47
Set the max value for a column 7 35
Urgent help needed! Unable to to paste in query designer 29 34
You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

932 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

10 Experts available now in Live!

Get 1:1 Help Now