sqlsrv and pdo_sqlsrv
Forum
  1. Forums
  2. CloudLinux and Control Panels
  3. CloudLinux and cPanel
  1. while1
  2. Friday, 20 April 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: 257
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: 26.02.2021
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: 504
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

We use cookies to ensure you get the best experience using our website and services. Read more about it in our Privacy Policy. Please agree to the use of cookies to proceed. Alternatively, you may disable cookies in your browser at any time.

You have declined cookies. This decision can be reversed.

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