Welcome Guest, Not a member yet? Register   Sign In
How to connect SQLSRV using SQLSRV driver?
#1

With the latest CI4 version I'm able to use SQLSRV driver to DB Connections, but I'm understand how I can configure the driver to be connectec successfully? I've tried:

PHP Code:
    public $mulord = [
        
'DSN'      => '',
        
'hostname' => 'IP_HERE',
        
'username' => 'sa',
        
'password' => 'PASS',
        
'database' => 'DB_NAME',
        
'DBDriver' => 'SQLSRV',
        
'DBPrefix' => '',
        
'pConnect' => false,
        
'DBDebug'  => (ENVIRONMENT !== 'production'),
        
'charset'  => 'utf8',
        
'DBCollat' => 'utf8_general_ci',
        
'swapPre'  => '',
        
'encrypt'  => true,
        
'compress' => false,
        
'strictOn' => false,
        
'failover' => [],
        
'port'     => 1433,
    ]; 

But doesn't work... Then I'm try based on this topic:
https://forum.codeigniter.com/thread-785...ght=SQLSRV

And continue without work (Unable to connect to the database).

I really will be possible to remote connect in SQL Server using SQLSRV driver?
Reply


Messages In This Thread
How to connect SQLSRV using SQLSRV driver? - by ajmeireles - 02-14-2021, 09:46 PM



Theme © iAndrew 2016 - Forum software by © MyBB