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
#2

Hi, I have the same issue, did you find a solution?
Reply
#3

(10-19-2021, 04:55 PM)codedecks Wrote: Hi,  I have the same issue, did you find a solution?

I just changed sqlrv.dll version 7.4 for 7.3 and it works
Reply




Theme © iAndrew 2016 - Forum software by © MyBB