[eluser]Unknown[/eluser]
Hi...
i'm using a codeigniter installation on a centos server (LAMP)
This works really good, but my application need to connect also to another DB (MS SQL SERVER 2008).
The only way i found to connect is to use these parameters with PDO driver:
Code:
$db['mygroupname']['hostname'] = 'dblib:host=myhost';
$db['mygroupname']['username'] = 'myuser';
$db['mygroupname']['password'] = 'mypass';
$db['mygroupname']['database'] = 'mydbname';
$db['mygroupname']['dbdriver'] = 'pdo';
But it's really slowly... anyone know why?
I've tried to use sqlsrv driver or mssql but it not works, i can't connect to that db with these drivers... why?
Why it workis only with PDO dblib? Could this causes that slow performace?
Please help me...
Thank you all.