Yii2 Database Connection - PDOException

Question

I tried to change mysql to ms sql server dbms in yii but encounter PDO Exception, "Caused by: PDOException could not find driver". What is the issue there?

This is db.php file.

'class' => 'yii\db\Connection',
'dsn' => 'sqlsrv:Server=localhost;Database=mydb',
'username' => 'myusername',
'password' => 'myps',
'charset' => 'utf8'

This is config.php.

'components' => [
    'db' => [
        'dsn' => 'sqlsrv:Server=localhost;Database=mydb',
    ],

Possible duplicate of PDOException “could not find driver” — miken32
– miken32, Commented Sep 19, 2017 at 21:56

StephenHy · Accepted Answer · 2017-06-05 05:03:24Z

3

You need to install PDO driver for your database type.

Before proceeding, make sure you have installed both the PDO PHP extension and the PDO driver for the database you are using (e.g. pdo_mysql for MySQL). This is a basic requirement if your application uses a relational database.

Please refer these links for detail:

Guide Start Databases - Configuring a DB Connection Section

MSSQL PDO

answered Jun 5, 2017 at 5:03

StephenHy

459 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Yii2 Database Connection - PDOException

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related