Experiencing trouble trying to import data from Lotus Notes into SQL via NotesSQL ODBC driver

Posted on 2006-06-22
Last Modified: 2013-12-18
I'm getting the following error message when trying to import data from Lotus Notes into SQL:

"[Lotus][ODBC Lotus Notes]The Notes server is not a known TCP/IP host."

Just wondering if any of you out there have seen this before or might have any suggestions with regards to troubleshooting. The SQL server and Domino server are both located on the same physical machine and both are running fine otherwise (we haven't made any recent networking changes that I know of), so I suspect that something has gone awry with the ODBC driver.

It's an old version of Notes (4.6x) and the NotesSQL driver is version 3.01.  If there was any chance of my company upgrading this - believe me - I would have done so already.
Question by:xavieronasis
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
  • 3
  • 2
LVL 43

Accepted Solution

Steve Knight earned 500 total points
ID: 16964701
I imagine your server name is different to the domino server name and something has changed in your name resolution methods, maybe an old WINS server used to make it work and has been shut down etc.  Anyway try PING notesservername from a command prompt.  If so then add an entry to the HOSTS table on the box with the IP address of the Notes server and the Notes server name.

You can find HOSTS at c:\winnt\system32\drivers\ect\hosts (or c:\windows\system32\...) and can open it with notepad.exe

You will probably just find one entry saying     localhost

Add an entry that says

ipofnotes     noteservername  noteservername/ou/certitifer

replacing the details with yours of course.  e.g.   notes1  notes1/company


LVL 18

Expert Comment

ID: 16965196

Did you create a DSN ON the Server using the ODBC ,  so when you try and connect to the Domino server, you use the DSN you've configured and the open port that you've allowed to be open on the Firewall.. YOu shouldn't need a hosts file if you have active directory, but since these are on the same machine, well, it shouldn't make a different, since it's the ODBC driver and the port that you've designated in SQL and Lotus Notes to use for transfer.

if it was working and is now not working, then first check the odbc ports in use, and make sure that they are open.  Then open MS Access and try to link a table to the DSN you've configured for Notes and then for SQL server.  That's always a good gage of what's going on.  If you can't create a link table, then you will get very specific errors, like not authorized, and so on.

The only time I've had to create a hosts file was on a windows 2000 non-server running Notes Server, SQL Server.  And the only reason I needed it was to identify the Notes server IP address since I didn't have  a dns server.

The only time I have had stuff fail like this is when someone closed the port on the firewall, or changed the access to the server (w2k did this, too, you needed not only windows permission to access the server, but you needed permission on the SQL server side to access SQL server, and permission on the Notes side to access the Notes database.
LVL 43

Expert Comment

by:Steve Knight
ID: 16966320
In any case PING notesservername would be a good idea, no ?  Agree HOSTS file shouldn't be needed but if other name resolution method has changed ins ome way that was easy test.  Users could be using different dns/wins servers to the server now maybe or their own hosts files etc. When you get old systems hanging around I have found in practice no-one notices them until someone shuts down something they rely upon!

Guess I'll shut up now though and let xavieronasis  come back first :-)

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

LVL 18

Expert Comment

ID: 16968243
True, Steve.   Just adding some additional front end checks..:)

Author Comment

ID: 17141347
Adding a hostfile entry did the trick.  Thx.
LVL 43

Expert Comment

by:Steve Knight
ID: 17141721
No problem.  Thanks for the points


Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

627 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