[eluser]Tamilmani[/eluser]
Hi,
I am working in Codeigniter with Microsoft SQL 2000 database connection. But i will run this project using Microsoft Visual Studio 2008 as Administrator
My Issues are
1. I have one problem in simple query . I don't get any result in my below query, but values are presented in database.
2. some time pages are not loading , just getting blank page .
3. Insertion ID is not returning .
Code:
$query = $this->db->query("select * from countries");
$qry = $query->result();
var_dump($qry);
This is my database configuration
Code:
$active_group = "default";
$active_record = TRUE;
$db['default']['hostname'] = "Driver={SQL Server Native Client 10.0};Server=ipaddress;Database=dbname;";
$db['default']['username'] = "username";
$db['default']['password'] = "password";
$db['default']['database'] = "database";
$db['default']['dbdriver'] = "odbc";
$db['default']['dbprefix'] = "";
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = "";
$db['default']['char_set'] = "utf8";
$db['default']['dbcollat'] = "utf8_general_ci";
Is any problem in my database.php or visual studio ? Solution is there ???????
