Solved

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

Posted on 2006-06-22
7
291 Views
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.
0
Comment
Question by:xavieronasis
  • 3
  • 2
7 Comments
 
LVL 43

Accepted Solution

by:
Steve Knight earned 500 total points
Comment Utility
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


127.0.0.1     localhost

Add an entry that says

ipofnotes     noteservername  noteservername/ou/certitifer noteservername.fullyqualified.domain.com

replacing the details with yours of course.  e.g.

172.29.1.2   notes1  notes1/company notes1.company.com

hth

Steve
0
 
LVL 18

Expert Comment

by:marilyng
Comment Utility


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.
0
 
LVL 43

Expert Comment

by:Steve Knight
Comment Utility
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 :-)

Steve
0
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 
LVL 18

Expert Comment

by:marilyng
Comment Utility
True, Steve.   Just adding some additional front end checks..:)
0
 
LVL 1

Author Comment

by:xavieronasis
Comment Utility
Adding a hostfile entry did the trick.  Thx.
0
 
LVL 43

Expert Comment

by:Steve Knight
Comment Utility
No problem.  Thanks for the points

Steve
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

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.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

762 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

16 Experts available now in Live!

Get 1:1 Help Now