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

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.
Who is Participating?
Steve KnightIT ConsultancyCommented:
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 noteservername.fullyqualified.domain.com

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



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.
Steve KnightIT ConsultancyCommented:
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 :-)

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

True, Steve.   Just adding some additional front end checks..:)
xavieronasisAuthor Commented:
Adding a hostfile entry did the trick.  Thx.
Steve KnightIT ConsultancyCommented:
No problem.  Thanks for the points

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.