Welcome Guest, Not a member yet? Register   Sign In
Problem Multiples Connection Database
#1

[eluser]Mellkior[/eluser]
Hi,

I have 3 databases in my work.

2 Mssql and 1 mysql

Not ask why the 3.... hehehe.

database.php
Code:
$active_group = "default";
$active_record = TRUE;

// MSSQL
$db['default']['hostname'] = "*******";
$db['default']['username'] = "********";
$db['default']['password'] = "********";
$db['default']['database'] = "********";
$db['default']['dbdriver'] = "mssql";
$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";

// MYSQL
$db['mysql']['hostname'] = "*******";
$db['mysql']['username'] = "*******";
$db['mysql']['password'] = "*******";
$db['mysql']['database'] = "*******";
$db['mysql']['dbdriver'] = "mysql";
$db['mysql']['dbprefix'] = "";
$db['mysql']['pconnect'] = TRUE;
$db['mysql']['db_debug'] = TRUE;
$db['mysql']['cache_on'] = FALSE;
$db['mysql']['cachedir'] = "";
$db['mysql']['char_set'] = "utf8";
$db['mysql']['dbcollat'] = "utf8_general_ci";

// MSSQL 2
$db['othermssql']['hostname'] = "*******";
$db['othermssql']['username'] = "*******";
$db['othermssql']['password'] = "*******";
$db['othermssql']['database'] = "*******";
$db['othermssql']['dbdriver'] = "mssql";
$db['othermssql']['dbprefix'] = "";
$db['othermssql']['pconnect'] = TRUE;
$db['othermssql']['db_debug'] = TRUE;
$db['othermssql']['cache_on'] = FALSE;
$db['othermssql']['cachedir'] = "";
$db['othermssql']['char_set'] = "utf8";
$db['othermssql']['dbcollat'] = "utf8_general_ci";

On system/codeigniter/Codeigniter.php

Code:
$CI->db->close();

close only my default database.

Others 2 connections stay opened.

How can i close all my connections in database?

Thanks!


Messages In This Thread
Problem Multiples Connection Database - by El Forum - 03-18-2010, 08:42 AM
Problem Multiples Connection Database - by El Forum - 03-18-2010, 09:35 AM
Problem Multiples Connection Database - by El Forum - 03-18-2010, 10:33 AM
Problem Multiples Connection Database - by El Forum - 03-18-2010, 12:05 PM
Problem Multiples Connection Database - by El Forum - 03-18-2010, 02:45 PM



Theme © iAndrew 2016 - Forum software by © MyBB