Experiencing trouble trying to import data from Lotus Notes into SQL via NotesSQL ODBC driver
Posted on 2006-06-22
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.