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

This works for me in CI 4.4.6 with MS SQL Server Express 2019:

Code:
public array $sqlsrv = [
'DSN'        => '',
'hostname'  => '127.0.0.1\sqlexpress',
'username'  => 'user',
'password'  => 'pass',
'database'  => 'table',
'schema'    => 'dbo',
'DBDriver'  => 'SQLSRV',
'DBPrefix'  => '',
'pConnect'  => false,
'DBDebug'    => true,
'charset'    => 'utf8',
'swapPre'    => '',
'encrypt'    => false,
'failover'  => [],
'dateFormat' => [
'date'    => 'Y-m-d',
'datetime' => 'Y-m-d H:i:s',
'time'    => 'H:i:s',
],
];


Maybe this helps you... I had to remove the port and add dbo as schema.
Reply


Messages In This Thread
SQL server connection not working - by falagar2k - 04-24-2024, 02:31 AM
RE: SQL server connection not working - by kenjis - 04-24-2024, 05:44 PM
RE: SQL server connection not working - by kenjis - 04-25-2024, 12:54 AM
RE: SQL server connection not working - by JustJohnQ - 04-25-2024, 03:06 AM
RE: SQL server connection not working - by kenjis - 04-25-2024, 04:31 AM
RE: SQL server connection not working - by kenjis - 04-25-2024, 03:59 PM



Theme © iAndrew 2016 - Forum software by © MyBB