[eluser]bharata[/eluser]
Just share what I've done,
I've found the problem, while it's caused by sql server need to set ansi_nulls and ansi_warnings ON before run the sql I meant.
soo, the thing just I did is query for set ansi_nulls ON and set ansi_warnings ON,
here is :
Code:
$sql= "SELECT CAST(emp_id AS NUMERIC) AS emp_id, loan_code, loan_nper, mem_thp, "
. "loan_pv, buy_rate, sell_rate, start_date "
. "dbo.fn_pmt(sell_rate, loan_nper , -loan_pv, 0, 0) AS payment "
. "FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0', "
. "'Data Source=\"".DOCUMENT_ROOT."/finance/uploads/".$file."\";User ID=;Password=;Extended properties=Excel 5.0')...Sheet1$"
;
$query = $this->db->query('SET ANSI_NULLS ON');
$query = $this->db->query('SET ANSI_WARNINGS ON');
$query = $this->db->query($sql);
The thing I still confused is why CI still didn't notice the error message nor number? I've to used conventional mssql_query to check the error and found the solution through google.
thks folks,
--
bharata