+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: SQL Windows Server 2008 R2 and DB connection (/showthread.php?tid=60470)
SQL Windows Server 2008 R2 and DB connection - El Forum - 04-03-2014
[eluser]Unknown[/eluser]
Hi guys, sorry for my english :-P i have a big proble with DB connection, I have been trying for several days but i can't connect it :-(
I have two configuration: local with Xammp and remote on colud with Vesta control panel and in both cases the web page is clean, if i try to see the sorce code of webpage it is clean :-(
i see this post: http://ellislab.com/forums/viewthread/208171/#968268 for the sames problem but i'dont' understand where I'm doing wrong.
This is the profile for xammp:
$active_group = 'default';
$active_record = TRUE;
$db['default']['hostname'] = "192.168.1.251";
$db['default']['port'] = 1433;
$db['default']['username'] = 'my_username';
$db['default']['password'] = 'my_password';
$db['default']['database'] = 'my_db_name';
$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';
$db['default']['swap_pre'] = '';
$db['default']['autoinit'] = TRUE;
$db['default']['stricton'] = FALSE;
This is the profile for Remote cloud with Vesta control panel:
$active_group = 'default';
$active_record = TRUE;
$db['default']['hostname'] = "public_ip_of_the_server_with_SQL_Windows_Server_2008_R2";
$db['default']['port'] = 1433;
$db['default']['username'] = 'my_username';
$db['default']['password'] = 'my_password';
$db['default']['database'] = 'my_db_name';
$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';
$db['default']['swap_pre'] = '';
$db['default']['autoinit'] = TRUE;
$db['default']['stricton'] = FALSE;
where is the problem ?
SQL Windows Server 2008 R2 and DB connection - El Forum - 05-07-2014
[eluser]EyeAmN8[/eluser]
Try using 'sqlsvr' as the db driver. You may need to install some other stuff, but it works well. I had the same issue a few months ago
SQL Windows Server 2008 R2 and DB connection - El Forum - 09-07-2014
[eluser]Unknown[/eluser]
Most of the guide online are geared for the Mac OS users. I believe if a very detailed on comes out for windows users (Vista all the way to Windows 8.1) it will gain a 20% of CMS installs but unfortunately nothing is out there.
This is my best Activation windows 8.1: <a href='https://www.youtube.com/watch?v=_s3mjcA-8eE'> تفعيل Windows 8.1</a>