This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
niota-docs:niota_system_config_connection [2025/05/29 12:23] admin [configure hosts] |
niota-docs:niota_system_config_connection [2025/07/17 14:11] (current) |
||
|---|---|---|---|
| Line 210: | Line 210: | ||
| * test the connection by loading a grid in niota | * test the connection by loading a grid in niota | ||
| + | * | ||
| - | ^"SQL_Server_ODBC"=> array ( ^"SQL_Server_native"=> array (^ | + | ^"SQL_Server_ODBC"=> array ( ^"SQL_Server_native"=> array ( ^"SQL_Server_native_named_instance"=> array ( ^ |
| - | |''PHPGRID_DB_TYPE => DB_TYPE_ODBC_MSSQL''|''PHPGRID_DB_TYPE => DB_TYPE_MSSQL''| | + | |PHPGRID_DB_TYPE => DB_TYPE_ODBC_MSSQL|PHPGRID_DB_TYPE => DB_TYPE_MSSQL|PHPGRID_DB_TYPE => DB_TYPE_MSSQL| |
| - | |''PHPGRID_DB_HOSTNAME => "odbc_connection_resource_name"''|''PHPGRID_DB_HOSTNAME => “myhostname.com,1433”''| | + | |PHPGRID_DB_HOSTNAME => "odbc_connection_resource_name"|PHPGRID_DB_HOSTNAME => “myhostname.com,1433”|PHPGRID_DB_HOSTNAME => “MYSQL\MYINSTANCE”| |
| - | |''PHPGRID_DB_CHARSET => "iso-8859-2"''|''PHPGRID_DB_CHARSET => "UTF-8"'' or ''PHPGRID_DB_CHARSET => SQLSRV_ENC_CHAR''| | + | |PHPGRID_DB_CHARSET => "iso-8859-2"|PHPGRID_DB_CHARSET => "UTF-8" or PHPGRID_DB_CHARSET => SQLSRV_ENC_CHAR|...| |
| ((Table 1 SQL Server connection definitions (ODBC vs. native).)) Only differences are listed. | ((Table 1 SQL Server connection definitions (ODBC vs. native).)) Only differences are listed. | ||