Welcome Guest, Not a member yet? Register   Sign In
Problems with ms sql server connection from codeigniter
#1

[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.


Messages In This Thread
Problems with ms sql server connection from codeigniter - by El Forum - 02-24-2014, 04:35 AM
Problems with ms sql server connection from codeigniter - by El Forum - 02-25-2014, 01:42 AM



Theme © iAndrew 2016 - Forum software by © MyBB