FORUM PLAN UPDATE: Date revision: This forum will remain open to new posts and responses until December 1, 2018. (After that date, you will still be able to view and search the forum.) Also, we're taking a second look at the best place to host future conversation. For now, keep using this forum, and stay tuned for more news.
ODBC conection issue running 64bit Domino 8.5.2 on 64bit Win2008. The scheduled agent uses "*LSXODBC" to connect to a ODBC SYSTEM DSN. The DSN was created with the 32bit version of the ODBC-Admin (C:\WINDOWS\SysWOW64\odbcad32.exe), because the text driver only exists in 32bit.
The agent runs without any problems on a 32bit machine. I cannot connect to the SYSTEM DSN on a 64bit installation. The error message: "ODBC could not complete the requested operation" when performing the con.ConnectTo("myConnection") call.
There was a response in the above persons issue mentioning migrating to JDBC. I am unable to find any documentation about using JDBC with delimited text files as a data source. Domino is the only software loaded on the server. There will never be SQL, DB2, MSFT Office and doubt that JDBC will be approved by the powers that be. Besides the txt driver has been working great in 32bit Domino for many years.
Feedback number WEBB8P4RDA created by Rick Ashe on 11/30/2011