Home > Backend Development > PHP Tutorial > How to Connect PHP to MSSQL via PDO ODBC: A Step-by-Step Guide to Driver Setup

How to Connect PHP to MSSQL via PDO ODBC: A Step-by-Step Guide to Driver Setup

Patricia Arquette
Release: 2024-11-06 22:49:02
Original
335 people have browsed it

How to Connect PHP to MSSQL via PDO ODBC: A Step-by-Step Guide to Driver Setup

Connect PHP to MSSQL via PDO ODBC: Understanding Driver Setup

When attempting to connect to a MSSQL database via PDO using ODBC, you might encounter issues if the necessary configuration files are not properly set up. Let's explore the key aspects of driver setup to resolve this problem.

Prerequisites:

  • Install unixodbc and freetds packages (e.g., apt-get install unixodbc tdsodbc on Ubuntu).
  • Ensure the correct ODBC driver for your platform is installed (/usr/lib folder may vary based on your architecture)

Configuration Files:

  • odbc.ini: Define the database connection ([mssql] section).
  • odbcinst.ini: Specify the driver location ([freetds] section).
  • freetds.conf: Define the TDS version and host connection details ([mssql] section).

Examples:

  • odbc.ini:

    [mssql]
    Description=MSSQL Server
    Driver=freetds
    Database=XXXXXX
    ServerName=MSSQL
    TDS_Version=7.1
    Copy after login
  • odbcinst.ini:

    [freetds]
    Description=MS SQL database access with Free TDS
    Driver=/usr/lib/i386-linux-gnu/odbc/libtdsodbc.so
    Setup=/usr/lib/i386-linux-gnu/odbc/libtdsS.so
    UsageCount=1
    Copy after login
  • freetds.conf:

    [mssql]
    host=XXXXXX
    port=1433
    tds version=7.1
    Copy after login

PHP Code:

Once configured, connect to the database using PDO:

$pdo = new PDO("dblib:host=mssql;dbname=$dbname", "$dbuser", "$dbpwd");
Copy after login

Note that your username may require a domainusername format. Execute phpinfo() to verify successful connection by searching for "freetds" in the "mssql" section under the "Libraries" section.

The above is the detailed content of How to Connect PHP to MSSQL via PDO ODBC: A Step-by-Step Guide to Driver Setup. For more information, please follow other related articles on the PHP Chinese website!

source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template