10-04-2018, 01:18 PM
Hi,
I'm getting that standard error that happens when there's something wrong with the sqlsrv driver specifications.
It's php 7.1:
Unable to connect to your database server using the provided settings.
Filename: C:/.../system/database/DB_driver.php
Line Number: 436
My database.php array is
$db['default'] = array(
'dsn' => 'sqlsrv
erver=myserver;Database=mydatabase',
'hostname' => 'myserver',
'username' => '',
'password' => '',
'database' => 'mydatabase',
'dbdriver' => 'sqlsrv',
'dbprefix' => '',
'pconnect' => FALSE,
'db_debug' => (ENVIRONMENT !== 'production'),
'cache_on' => FALSE,
'cachedir' => '',
'char_set' => 'utf8',
'dbcollat' => 'utf8_general_ci',
'swap_pre' => '',
'encrypt' => FALSE,
'compress' => FALSE,
'stricton' => FALSE,
'failover' => array(),
'save_queries' => TRUE
);
I tried with and without the dsn specifiied.
My server is configured for Windows Authentication. And And I'm able to connect outside of this Codeigniter project.
My thread-safe dll in extensions and php.ini is php_sqlsrv.dll
What else should I look for, in order to track this down?
I'm getting that standard error that happens when there's something wrong with the sqlsrv driver specifications.
It's php 7.1:
Unable to connect to your database server using the provided settings.
Filename: C:/.../system/database/DB_driver.php
Line Number: 436
My database.php array is
$db['default'] = array(
'dsn' => 'sqlsrv

'hostname' => 'myserver',
'username' => '',
'password' => '',
'database' => 'mydatabase',
'dbdriver' => 'sqlsrv',
'dbprefix' => '',
'pconnect' => FALSE,
'db_debug' => (ENVIRONMENT !== 'production'),
'cache_on' => FALSE,
'cachedir' => '',
'char_set' => 'utf8',
'dbcollat' => 'utf8_general_ci',
'swap_pre' => '',
'encrypt' => FALSE,
'compress' => FALSE,
'stricton' => FALSE,
'failover' => array(),
'save_queries' => TRUE
);
I tried with and without the dsn specifiied.
My server is configured for Windows Authentication. And And I'm able to connect outside of this Codeigniter project.
My thread-safe dll in extensions and php.ini is php_sqlsrv.dll
What else should I look for, in order to track this down?