Here's the (complicated) situation. We have two Linux servers that run PHP/MySQL to handle our website. And we have 4 NT servers, one of which runs an accounting program called Macola that uses a Pervasive scalable SQL server for the backend.
Usually, we export accounting info from the NT server in flat files and then upload it into the MySQL db to display on the web. Ideally, we would be able to connect to the SQL db in real time for up-to-date info.
Since all of these servers are networked, do I need to create some kind of ODBC or socket connection? Or can I simply connect via the hostname of the SQL server? I'm so confused!!!
Any info is helpful!!
Usually, we export accounting info from the NT server in flat files and then upload it into the MySQL db to display on the web. Ideally, we would be able to connect to the SQL db in real time for up-to-date info.
Since all of these servers are networked, do I need to create some kind of ODBC or socket connection? Or can I simply connect via the hostname of the SQL server? I'm so confused!!!
Any info is helpful!!