PHP与ODBC到远程数据库，驱动程序需要在哪里，我可以在连接上删除SSL吗？

Question

I need to connect from a web LAMP (PHP) environment to a remote Navision installation which has ODBC drivers on the server.

Does the web server need the ODBC drivers on it locally as well? Or does PHP connect to the Navision server environment with it's own local drivers?

Also, can I drop SSL on this connection for security - if so which component is it dropped onto? The ODBC connection?

Any help appreciated.

Answer 1

This depends on how you connect to Navision. Does Navision provide some kind of API by which you can access it (Webservices or something)? In that case, the LAMP server can use that API.

If you need to access the database behind Navision, then PHP needs access to the database. Either over ODBC or directly if possible (like FreeTDS if the database in question is a MS-SQL Server)