PHP with ODBC to remote db, where does driver need to be and can I drop SSL on the connection?

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开发者_如何学Python is it dropped onto? The ODBC connection?

Any help appreciated.

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)