CodeIgniter Forums

Full Version: Migration from CI3 to CI4 - SQLServer
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
I'm having difficulty configuring CI4 to connect to SQL Server. Undecided

I have the following configuration on CI3 that works perfectly:

PHP Code:
$db['ADMINBD04'] = array(
    
'dsn'    => '',
    
'hostname' => 'ADMINBD\NAME',
    
'username' => 'userci',
    
'password' => '#password123',
    
'database' => 'BASE',
    
'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 to replicate at CI without success.

.evn

Code:
database.default.hostname = ADMINBD\NAME
database.default.database = BASE
database.default.username = userci
database.default.password = #password123
database.default.DBDriver = SQLSRV
database.default.port = 1433

Or in the Configuration file.

PHP Code:
    public $default = [
        
'DSN'      => '',
        
'hostname' => 'ADMINBD\NAME',
        
'username' => 'userci',
        
'password' => '#password123',
        
'database' => 'BASE',
        
'DBDriver' => 'SQLSRV',
        
'DBPrefix' => '',
        
'pConnect' => false,
        
'DBDebug'  => (ENVIRONMENT !== 'production'),
        
'charset'  => 'utf8',
        
'DBCollat' => 'utf8_general_ci',
        
'swapPre'  => '',
        
'encrypt'  => false,
        
'compress' => false,
        
'strictOn' => false,
        
'failover' => [],
        
'port'     => 1433,
    ]; 

I don't know what I'm doing wrong, I thank you for your help. Huh
I discovered the problem, the firewall of the connection of the new server with PHP8 raised by the infra was with the UDP protocol blocked.

After several tests comparing the old server with PHP7, we identified the problem.

But, again, I would like to congratulate you for your efforts to keep CodeIgniter simple and fantastic.
Thank you for sharing your solution!