We have a working 32 bit ODBC configuration, pulling data from a NSF on a domino Server via an sql statement using the ODBC Driver.
We are now upgrading the software that runs the SQL statement (to a new 64 bit version) and have been told that it requires the 64 bit ODBC driver [this we have questioned , but waiting confirmation].
We have configured the 64 bit ODBC driver on a test server [installed a domino Server and disabled its services, in place of a Notes Client].
All seems to look good, except the SQL keeps returning a 'unable to find path to server' error.
We even started up the Domino Server on the ODBC test server and can trace to the server where the NSF is.
When we configure the ODBC Connection, we get the list of databases populated.
We have the Path set in the environment variables and in the Registry.
Does anyone have any ideas what we are missing ?
Many thanks for any constructive suggestions.
Ian