Welcome Guest, Not a member yet? Register   Sign In
Heterogeneous queries

Guys, i have question,
i used mssql for database, and i use link server for my table in sql server 2005

select * from [server-31].inventaris.dbo.users
create view v_useregis as select * from [server-31].inventaris.dbo.users
select * from v_useregis

i use that code in sql server 2005, i can see the data, but when i put into controller

public function data_user(){
    $query = $this->db->get('v_useregis');
    if($query->num_rows() > 0)
     $row = $query->result();

and then i show errorr like this

Quote:A Database Error Occurred

Error Number:

Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics. Enable these options and then reissue your query.

SELECT * FROM v_useregis

Filename: C:\xampp\htdocs\workflow\system\database\DB_driver.php

Line Number: 330

there's something wrong in my code? please help me if somebody else know how to fix it. thank you

Messages In This Thread
Heterogeneous queries - by El Forum - 05-29-2013, 01:04 AM
Heterogeneous queries - by El Forum - 05-29-2013, 04:15 AM
Heterogeneous queries - by El Forum - 05-29-2013, 04:57 AM

Theme © iAndrew 2016 - Forum software by © MyBB