We have a Cobalt Qube 3 Server running Linux & Chilisoft asp.
At the moment my asp applications pull data from the installed MySQL
database which is fed data via MS Access (via ODBC) which is used as
our in-house front-end between 3 staff doing data entry.
We are now possibly looking to implement an ERP/MRP solution to run
our head office & manufacturing site. The data would therefore come
from the new software and no longer from MS Access.
I can export the data via ODBC in windows into MySQL, but I cannnot
Import/link the tables back into the software as I do now with MS
Access to ensure that the web apps data is live as of the moment you
enter information. I would therefore have to do updates several times
a day which is a bit messy.
As the asp pages run from our Cobalt server, how is it possible to set
up an ODBC connection on the Linux server when there is no interface
like we have in Windows. I am trying to get the asp pages to connect
to their database wich is somewhere else on our network, not the
Is this possible ?
Appreciate your thoughts....