Codeigniter - How can I connect ORACLE, MySQL and SQL Server?

Question

I have found many questions regarding connecting multiple databases like this Link which helps in connecting multiple databases of MYSQL. In my case i need to connect to MySQL, ORACLE and SQL Server in same application.

Is it even possible using codeigniter Active Records?

I have googled a lot, but was unable to find any answer. It was a big surprise for me that no one faced similar problem.

Thanks Begueradj for you Answer, But does PDO gives power to connect to all these DBMS in one Application? — jawadxiv
– jawadxiv, Commented Nov 1, 2014 at 14:57
Of course you can, no problem for that. Please check any tutorial on how PDO works and you will guess you can do that. — user3522371
– user3522371, Commented Nov 1, 2014 at 15:02
Thanks Bedueradj, but i figured out how to do this all without using PDO. — jawadxiv
– jawadxiv, Commented Nov 3, 2014 at 15:44

jawadxiv · Accepted Answer · 2014-11-03 15:54:23Z

I figured out the trick to do this in codeigniter, there are actually three very important things to keep in mind:

You should have the client installed on your Apache e.g. SQL SERVER client
Your "pconnect" should be set to FALSE in config/database.php file
To use your sqlserver(2nd Connection) you have to use below code in your constructor or function in which you want to use:

$this->sqlsrvr = $this->load->database('test', true);

Example Database.php File

You have to add multiple entries in your database.php file config folder, i am sharing my test database.php file below:

$active_group = 'default';
$active_record = TRUE;

$db['default']['hostname'] = 'localhost';
$db['default']['username'] = 'root';
$db['default']['password'] = '';
$db['default']['database'] = 'jawad';
$db['default']['dbdriver'] = 'mysqli';
$db['default']['dbprefix'] = '';
$db['default']['pconnect'] = FALSE; 

$db['test']['hostname'] = "192.168.43.104";
$db['test']['username'] = "sa";
$db['test']['password'] = "password";
$db['test']['database'] = "jawad";
$db['test']['dbdriver'] = "sqlsrv";
$db['test']['dbprefix'] = "";
$db['test']['pconnect'] = FALSE;

Collectives™ on Stack Overflow

Codeigniter - How can I connect ORACLE, MySQL and SQL Server?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related