Welcome Guest, Not a member yet? Register   Sign In
CI3 with SQL server
#1

(This post was last modified: 08-25-2020, 07:56 AM by jreklund.)

Hello everyone,

I had a conexion to Sql server with the next configuration.

PHP Code:
$db['azure'] = array(
'dsn' => '',
'hostname' => 'bck-pro-sql.database.windows.net',
'username' => 'user',
'password' => 'pass',
'database' => 'CustomerServiceDB',
'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 already installed ODBC drive, sqlrv.dll for php 7.4 and modified php.ini. But I dont know why suddenly I got the next error

Unable to connect to your database server using the provided settings.
Filename: C:/xampp/htdocs/wke/system/database/DB_driver.php
Line Number: 436


It´s weird because sometimes its working normally and all of sudden crash with that error, If a restart xampp it works for some minutes.

Pls. can you help me with some advices

merci
Reply


Messages In This Thread
CI3 with SQL server - by Y6700B - 08-25-2020, 01:44 AM
RE: CI3 with SQL server - by codedecks - 10-19-2021, 04:55 PM
RE: CI3 with SQL server - by Y6700B - 10-20-2021, 01:18 AM



Theme © iAndrew 2016 - Forum software by © MyBB