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:29] admin [set up MS SQL Server db connection] |
niota-docs:niota_system_config_connection [2025/07/17 14:11] (current) |
||
|---|---|---|---|
| Line 211: | Line 211: | ||
| * test the connection by loading a grid in niota | * test the connection by loading a grid in niota | ||
| * | * | ||
| - | ^MS SQL Server^^^ | + | |
| - | ||| | + | ^"SQL_Server_ODBC"=> array ( ^"SQL_Server_native"=> array ( ^"SQL_Server_native_named_instance"=> 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_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 => “MYSQL\MYINSTANCE”| | |PHPGRID_DB_HOSTNAME => "odbc_connection_resource_name"|PHPGRID_DB_HOSTNAME => “myhostname.com,1433”|PHPGRID_DB_HOSTNAME => “MYSQL\MYINSTANCE”| | ||