connect to sql server with sqlsrv

Hi, I do not know English. I'm sorry
i set config in env

but get error "Unable to connect to the database"

Do I have to configure it elsewhere with different specifications?

help me

can you elaborate on that IP address your using for hostname; normally thats localhost and yours looks like the IP for a router or something ?

Also did you rename env to .env ?

CMS CI4 

Arch Book  CodeIgniter4 on Apache(pages 92-114) 

Github

can you elaborate on that IP address your using  for hostname; normally thats localhost and yours looks like the IP for a router or something ?

Also did you rename env to .env ?

Yes I Chenge env to .env

Sql server in 192.168.1.4، but my web server in 192.168.1.6 , i cheng Ip 192.168.1.4 to hostname but any difference.

is needed install sql server in 192.168.1.6 ?

this might be relevant ? https://forum.codeigniter.com/thread-758...#pid376318

you might also try using 192.168.1.4 in dsn at :

Code:

public $default = [
        'DSN'      => '',
        'hostname' => 'localhost',
        'username' => '',

which is in Database.php in app/config

i.e shift from using .env to direct in Database.php


i'm no expert on databases; in fact i shifted from main stream database eg MySQl to sqlite3 quite some time ago

could you shift to sqlite3 ? works like a dream , all you have to do is put a sqlite3 database file in writable

CMS CI4 

Arch Book  CodeIgniter4 on Apache(pages 92-114) 

Github

this might be relevant ? https://forum.codeigniter.com/thread-758...#pid376318

you might also try using 192.168.1.4 in dsn at :

Code:

public $default = [
        'DSN'      => '',
        'hostname' => 'localhost',
        'username' => '',

which is in Database.php in app/config

i.e shift from using .env to direct in Database.php


i'm no expert on databases; in fact i shifted from main stream database eg MySQl to sqlite3 quite some time ago

could you shift to sqlite3 ? works like a dream , all you have to do is put a sqlite3 database file in writable

 I can Not Chenge Database. If I do not find a solution, I have to go back to the previous version (3).

Try using 127.0.0.1 as the hostname. If that still fails, check your recent log file in the writable/logs/ folder. Check for the log record with "ERROR -->"

Try using 127.0.0.1 as the hostname. If that still fails, check your recent log file in the writable/logs/ folder. Check for the log record with "ERROR -->"

my error log is:

Code:

ERROR - 2021-02-09 00:38:04 --> Error connecting to the database: Call to undefined function CodeIgniter\Database\SQLSRV\sqlsrv_connect()
CRITICAL - 2021-02-09 00:38:04 --> Unable to connect to the database.
#0 D:\xampp\htdocs\aradco\system\Database\BaseConnection.php(618): CodeIgniter\Database\BaseConnection->initialize()
#1 D:\xampp\htdocs\aradco\system\Database\SQLSRV\Builder.php(648): CodeIgniter\Database\BaseConnection->query('SELECT *\nFROM "...', Array, false)
#2 D:\xampp\htdocs\aradco\app\Models\Admin\Personnel\M_Personnel.php(13): CodeIgniter\Database\SQLSRV\Builder->get()
#3 D:\xampp\htdocs\aradco\app\Controllers\Admin\Personnel\Personnel.php(33): App\Models\Admin\Personnel\M_Personnel->canlogin('11578', '1')
#4 D:\xampp\htdocs\aradco\system\CodeIgniter.php(936): App\Controllers\Admin\Personnel\Personnel->Login()
#5 D:\xampp\htdocs\aradco\system\CodeIgniter.php(432): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Admin\Personnel\Personnel))
#6 D:\xampp\htdocs\aradco\system\CodeIgniter.php(333): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false)
#7 D:\xampp\htdocs\aradco\public\index.php(44): CodeIgniter\CodeIgniter->run()
#8 {main}

I do use multiple platforms with sqlsrv to connect to axapta database servers.
Maybe you need to use single quotes in .env file?

This is my code that does work, if this does not work for you, then most probably you have issue with connection IP address and / or DSN

.env

Code:

#--------------------------------------------------------------------
# DATABASE
#--------------------------------------------------------------------

database.default.hostname = localhost
database.default.database = intranet
database.default.username = intranet
database.default.password = intranet
database.default.DBDriver = MySQLi
database.default.DBDebug = true

# axapta server
database.axapta.hostname = 'xxx.xx.xx.xx'
database.axapta.database = 'database_name'
database.axapta.username = 'user_name'
database.axapta.password = 'long_password'
database.axapta.DBDriver = Sqlsrv
database.axapta.port = 1433

/app/Config/Database.php

PHP Code:

    /**
     * The Axapta database connection.
     *
     * @var array
     */
    public $axapta = [
        'DSN'      => '',
        'hostname' => '',
        'username' => '',
        'password' => '',
        'database' => '',
        'DBDriver' => 'Sqlsrv',
        'DBPrefix' => '',
        'pConnect' => false,
        'DBDebug'  => (ENVIRONMENT !== 'production'),
        'cacheOn'  => false,
        'cacheDir' => '',
        'charset'  => 'utf8',
        'DBCollat' => 'utf8_general_ci',
        'swapPre'  => '',
        'encrypt'  => false,
        'compress' => false,
        'strictOn' => false,
        'failover' => [],
        'port'     => 3306,
    ]; 


Controller

PHP Code:

$this->axapta = Database::connect('axapta');

$builder = $this->axapta->table('DATABASE_TABLE');
$builder->select();
$builder->where('TABLE_COLUMN', 'VALUE');
return $builder->get()->getResultObject(); 


Based on your error logs, it seems sqlsrv_connect() is not defined. This means that gou do not have the sqlsrv php extension installed.

Based on your error logs, it seems sqlsrv_connect() is not defined. This means that gou do not have the sqlsrv php extension installed.

how can install?