Welcome Guest, Not a member yet? Register   Sign In
SQL server connection not working
#11

I can confirm it is not a bug. Adding the line:
PHP Code:
'port'        => ''

doesn't make a difference. A connection is made without problems.
Reply
#12

(04-25-2024, 05:03 AM)JustJohnQ Wrote: I can confirm it is not a bug. Adding the line:
PHP Code:
'port'        => ''

doesn't make a difference. A connection is made without problems.

Maybe a difference between 4.4.6 and 4.5.1? Adding the port = '' line certainly breaks things for me.
Reply
#13

@JustJohnQ Thank you for checking!
Reply
#14

Also tested on a fresh install of CI 4.5.1:
PHP Code:
public array $sqlsrv = [
        'DSN'        => '',
        'hostname'  => '127.0.0.1\sqlexpress',
        'username'  => 'uid',
        'password'  => 'pass',
        'database'  => 'db',
        'schema'    => 'dbo',
        'DBDriver'  => 'SQLSRV',
        'DBPrefix'  => '',
        'pConnect'  => false,
        'DBDebug'    => true,
        'charset'    => 'utf8',
        'swapPre'    => '',
        'encrypt'    => false,
        'failover'  => [],
        'port'        => '',
        'dateFormat' => [
            'date'    => 'Y-m-d',
            'datetime' => 'Y-m-d H:i:s',
            'time'    => 'H:i:s',
        ],
    ]; 


works without problems.
Reply
#15

Strange. Thank you for checking and sorry if I caused inconvenience due to my ignorance.

Still very greatful for you help. It works for me now.
Reply
#16

port by default should be INTEGER not STRING
Reply




Theme © iAndrew 2016 - Forum software by © MyBB