OraFAQ Forum: MySQL » Connecting to MSSQL server via php-pdo?

Home » Open Source » MySQL » Connecting to MSSQL server via php-pdo? (10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Connecting to MSSQL server via php-pdo? [message #658464]

Thu, 15 December 2016 02:18

keyto
Messages: 1
Registered: December 2016

Junior Member

I'm unable to connect to MSSQL database on asphostportal I'm using:

Code: [Select all] [Show/ hide]

PHP Tools for Visual Studio

Here is the code:

Code: [Select all] [Show/ hide]

<?php
 try {
     $conn = new PDO("mssql:host=host_name_string;dbname=database_name_string", "username_string", "password_string");

     // set the PDO error mode to exception
     $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
     echo "Connected successfully"; 
 }
 catch(PDOException $e)
 {
     echo "Connection failed: " . $e->getMessage();
 }

?>

and the error caught by the PDOexception class:

Connection failed: could not find driver

I've also tested my code online and again getting the same error

I've searched for the solution and the only thing that could resolve my problem is by uncommenting:

extension=php_pdo_mysql.dll

but the line is already uncommented by default.

EDIT: The following does not ressolve my problem (instead of mssql:host)

sqlsrv:host
dblib:host

--moderator update: post approved, and moved to the MySQL forum. jw.

[Updated on: Thu, 15 December 2016 02:51] by Moderator

Report message to a moderator