sqlsrv and pdo_sqlsrv
Forum
  1. Forums
  2. CloudLinux and Control Panels
  3. CloudLinux and cPanel
  1. while1
  2. 20.04.2018
  3.  Subscribe via email
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
Rate this post:
  1. 23.04.2018 08:04:03
  2. # 1
Posts: 186
Joined: 31.01.2017
0
Votes
Undo
Please, submit a ticket with our tech support at https://cloudlinux.zendesk.com so they can help you with the issue
  1. 12.04.2020 10:04:45
  2. # 2
Alexandre Accepted Answer
Posts: 0
Joined: 04.12.2020
0
Votes
Undo
Please use these commands to install ODBC driver:

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

cagefsctl --force-update

cagefsctl -M
  1. 14.04.2020 11:04:36
  2. # 3
Sergey Khristich Accepted Answer
Posts: 494
Joined: 20.05.2019
0
Votes
Undo
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.
Marketing Manager
  1. 17.06.2020 17:06:04
  2. # 4
Steven Accepted Answer
Posts: 5
Joined: 31.10.2013
0
Votes
Undo
Those commands worked for me to fix my clients' site, thanks for this, so easy!!!!
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!
Alexandre
Submit Your Response
Upload files or images for this discussion by clicking on the upload button below. Supports gif,jpg,png,zip,rar,pdf
• Insert • Remove Upload Files (Maximum File Size: 2 MB)
Captcha
To protect the site from bots and unauthorized scripts, we require that you enter the captcha codes below before posting your question.

EU e-Privacy Directive

This website uses cookies to ensure you get the best experience using our website and services. If you prefer we don’t use cookies, please disable them in your browser.

You have declined cookies. This decision can be reversed.

You have allowed cookies to be placed on your computer. This decision can be reversed.