ODBC驱动程序/ FreeTDS

Question

I am migrating a PHP website that connects to an external MSSQL database. The new server is a Linux server. I know to get this to work I will need an ODBC driver for Linux, like these:

• FreeTDS
• Microsoft's ODBC driver for Linux.

My question is, do I need both or can I get this to work with just one of them?

Answer 1

You will only need one ODBC driver, which might be one of those you list, or might come from another source such as those from my employer.

The ODBC driver must match bitness with your PHP binary (whether that's the standalone executable, mod_php as used with Apache, or otherwise), and you'll generally be best off if you also have an ODBC driver manager (e.g., iODBC, unixODBC).

If you get pre-built binaries for any of these components, note that they must be compatible with the libc in your environment, which may mean that you need to add a compatibility library (for instance, binaries built for libc 2.5 need a compatibility library to be used in a libc 2.12 environment).