Code Igniter - How to call a precedent that is in another database?

Asked

Viewed 275 times

0

I have an SQL Server where we have several Databases and their schemas. So far so good, but I need access to a stored database.

I tried it : $this->db->query("cadunico.dbo.Cadunico_educacao_query"); but when I want to debug, nothing is returned.

sql sql-server

  • Didn’t miss the EXECUTE statement? Stored procedures are usually triggered in the form: EXECUTE procedure name parameter(s)

  • Does the connection user have the right to view objects from another database? Is it just another database or another database? When there is another bank involved another connection is required, which needs to be created manually, and generates another object in $this, thus $query = $this->meu_db_especial->query('EXECUTE CadUnico_Educacao_Consultar');.

No answers

Browser other questions tagged sql sql-server

You are not signed in. Login or sign up in order to post.