Localhost xampp connection with codeigniter using mssql database error as Invalid object name 'ci_sessions'

user7469596

I have completed all steps to connect mssql with xampp localhost. When I run code on localhost error were encountered as follows :

Error Number: 42S02/208

[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Invalid object name 'ci_sessions'.

SELECT "data" FROM "ci_sessions" WHERE "id" = 'ca4680ccaa1d99c9a97e4a4a8d639f7f2b9e374e'

from comment

$active_group = 'default'; 
$query_builder = TRUE; 
$db['default'] = array( 
'dsn'   => '', 
'hostname' => 'MSSQLSERVER', 
'username' => '', 
'password' => '', 
'database' => 'travell', 
'dbdriver' => 'sqlsrv', 
'dbprefix' => '', 
'pconnect' => FALSE, 
'db_debug' => (ENVIRONMENT !== 'production'), 
'cache_on' => FALSE, 
'cachedir' => '', 
'char_set' => 'utf8', 
'dbcollat' => 'utf8_general_ci', 
'swap_pre' => '', 
'encrypt' => FALSE, 
'compress' => FALSE, 
'stricton' => FALSE, 
'failover' => array(), 
'save_queries' => TRUE 
); 

How to resolve this problem?

user7469596

A Database Error Occurred

Error Number: 42S02/208

[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Invalid object name 'ci_sessions'.

for above error of connectivity between MSSQL 2016, Codeigniter and Xampp (PHP 7.0) check the name given to the 'ci_sessions' table created in MSSQL database and give the same name in a config.php file where table_name was mentioned for the same table.

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related