I have a remote using PDO connection to an MS SQL server that works fine when viewing the site via the browser, however, when I set up a task using the same connection details I get:
Error - could not find driver dblib:host=xx.xx.xx.xx:1433;dbname=DATABASE in COREPATH/classes/database/pdo/connection.php on line 78
Does anybody know a way around this?
Yes.
Configure the proper DSN for this PDO connection.
Or if you want to use dblib, make sure it is installed on your webserver. PDO_DBLIB is a PECL package, so you need to install it, it's not a part of a default PHP installation.
Donate
