Sorry, been tied up with other things. Thank you both for the response here's what I can tell you:
We have had ODBC enabled since the start, system DSNs were setup for all the companies, also UPS WorldShip and FedEx Ship use them to connect to Evo for shipping, and all sales and finance use the system DSNs for their Crystal reports, so I am fairly sure that's all working, but I could be a dope and be wrong....
What I do get when I use the test in the live production companies is a successful connection, for both companies.
When I use SM-T in the test companies, I get a connection failure, and in the resulting log is a btrieve error 12. What I don't know is what file it is unable to find. The test companies are copies of the production companies. Here's the log file:
Test Settings Attempt -- Wed Mar 29 17:22:34 EDT 2017
----------------------------------------------------------
company = B09
serial = 0
db host = LINUX-OESEVO
db port = 1583
db name = EVOB09
----------------------------------------------------------
[05:22:35 pm] java.util.concurrent.ExecutionException: java.sql.SQLException: [LNA][Pervasive][ODBC Engine Interface][Data Record Manager]The MicroKernel cannot find the specified file(Btrieve Error 12) -- java.sql.SQLException: [LNA][Pervasive][ODBC Engine Interface][Data Record Manager]The MicroKernel cannot find the specified file(Btrieve Error 12)
java.util.concurrent.ExecutionException: java.sql.SQLException: [LNA][Pervasive][ODBC Engine Interface][Data Record Manager]The MicroKernel cannot find the specified file(Btrieve Error 12)
at java.util.concurrent.FutureTask.report(Unknown Source)
at java.util.concurrent.FutureTask.get(Unknown Source)
at javax.swing.SwingWorker.get(Unknown Source)
at ui.ProgressFrame$1.done(ProgressFrame.java:103)
at javax.swing.SwingWorker$5.run(Unknown Source)
at javax.swing.SwingWorker$DoSubmitAccumulativeRunnable.run(Unknown Source)
at sun.swing.AccumulativeRunnable.run(Unknown Source)
at javax.swing.SwingWorker$DoSubmitAccumulativeRunnable.actionPerformed(Unknown Source)
at javax.swing.Timer.fireActionPerformed(Unknown Source)
at javax.swing.Timer$DoPostEvent.run(Unknown Source)
at java.awt.event.InvocationEvent.dispatch(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$500(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Un
known Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: java.sql.SQLException: [LNA][Pervasive][ODBC Engine Interface][Data Record Manager]The MicroKernel cannot find the specified file(Btrieve Error 12)
at com.pervasive.jdbc.lna.LNAObject.getErrors(LNAObject.java:213)
at com.pervasive.jdbc.lna.LNAStatement.getErrors(LNAStatement.java:937)
at com.pervasive.jdbc.lna.LNAObject.checkError(LNAObject.java:256)
at com.pervasive.jdbc.lna.LNAStatement.prepare(LNAStatement.java:273)
at com.pervasive.jdbc.v2.PreparedStatement.<init>(PreparedStatement.java:54)
at com.pervasive.jdbc.v2.CallableStatement.<init>(CallableStatement.java:40)
at com.pervasive.jdbc.v2.Connection.prepareCall(Connection.java:544)
at com.pervasive.jdbc.v2.Connection.prepareCall(Connection.java:381)
at ui.ProgressFrame$1.doInBackground(ProgressFrame.java:82)
at javax.swing.SwingWorker$1.call(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at javax.swing.SwingWorker.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
[05:22:35 pm] java.sql.SQLException: [LNA][Pervasive][ODBC Engine Interface][Data Record Manager]The MicroKernel cannot find the specified file(Btrieve Error 12) -- [LNA][Pervasive][ODBC Engine Interface][Data Record Manager]The MicroKernel cannot find the specified file(Btrieve Error 12)
java.sql.SQLException: [LNA][Pervasive][ODBC Engine Interface][Data Record Manager]The MicroKernel cannot find the specified file(Btrieve Error 12)
at com.pervasive.jdbc.lna.LNAObject.getErrors(LNAObject.java:213)
at com.pervasive.jdbc.lna.LNAStatement.getErrors(LNAStatement.java:937)
at com.pervasive.jdbc.lna.LNAObject.checkError(LNAObject.java:256)
at com.pervasive.jdbc.lna.LNAStatement.prepare(LNAStatement.java:273)
at com.pervasive.jdbc.v2.PreparedStatement.<init>(PreparedStatement.java:54)
at com.pervasive.jdbc.v2.CallableStatement.<init>(CallableStatement.java:40)
at com.pervasive.jdbc.v2.Connection.prepareCall(Connection.java:544)
at com.pervasive.jdbc.v2.Connection.prepareCall(Connection.java:381)
at ui.ProgressFrame$1.doInBackground(ProgressFrame.java:82)
at javax.swing.SwingWorker$1.call(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at javax.swing.SwingWorker.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
So, maybe something didn't get transferred/copied over correctly when the test companies were last created? I know I didn't have any errors or issues with the creation, but I could have missed something.
Let me know what else I can check on.
Thank you!
Val