sqlsrv and pdo_sqlsrv

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • dugi2000
    Junior Member
    • Mar 2021
    • 4

    #1

    sqlsrv and pdo_sqlsrv

    Hi friends,
    I am trying to connect a remote MS SQL server by enable php extension on the phpselector
    but sqlsrv and pdo_sqlsrv on phpselector return error:
    [unixODBC][Driver Manager]Data source name not found, and no default driver specified
    This extension requires the Microsoft ODBC Driver 11 or 13 for SQL Server. Access the following URL to download the ODBC Driver 11 or 13 for SQL Server for x64.

    Why are we required to do more to make it work?
    What is the right way to make it work?
    cloudlinux + cpanel + litespeed

    thanks
  • apb
    Senior Member
    • Feb 2018
    • 386

    #2
    Please, submit a ticket with our tech support at https://cloudlinux.zendesk.com so they can help you with the issue

    Comment

    • apb
      Senior Member
      • Feb 2018
      • 386

      #3
      Please use these commands to install ODBC driver:

      /opt/alt/alt-php-config/install_odbc

      cagefsctl --force-update

      cagefsctl -M

      Comment

      • skhristich
        Senior Member
        • Nov 2019
        • 595

        #4
        Hello,
        Thank you, Alexandre. That should work. If it does not work please create a ticket here https://cloudlinux.zendesk.com/hc/en-us/requests/new and technical experts will help you asap.
        Thank you.

        Comment

        • steven
          Junior Member
          • Apr 2017
          • 11

          #5
          Those commands worked for me to fix my clients site, thanks for this, so easy!!!!

          Comment

          Working...