Microsoft SQL Server Connection

[eluser]Tamilmani[/eluser]
Hi ,

I am doing one project, in that project i want to use SQL connection . how i configure the sql connection in database.php

I have one more issue . sometime view is not loading . just i am getting blank white page only . Is there any problem in database connection ?

Thanks

Tamilmani Mohan

[eluser]Bart v B[/eluser]
maybe a parse error?

Can you post some code? So that we can look at.

[eluser]Tamilmani[/eluser]
Hi All,

I need to connect the microsoft sql server in codeigniter.

Please see below sample code

$db['default']['hostname'] = "hostname";
$db['default']['username'] = "username";
$db['default']['password'] = "password";
$db['default']['database'] = "dbname";
$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";

If i used above code , i am getting below error

Fatal error: Call to undefined function mssql_connect() in C:\wamp\www\project\database\drivers\mssql\mssql_driver.php on line 58

Please help me

[eluser]Unknown[/eluser]
[quote author="Tamilmani" date="1272368976"]
Fatal error: Call to undefined function mssql_connect() in C:\wamp\www\project\database\drivers\mssql\mssql_driver.php on line 58
[/quote]

You will have to enable PHP's mssql extension in "php.ini" file in your wamp installation.

1. Open "php.ini"

2. Uncomment the line: (by removing leading semicolon ";" )

Code:

;extension=php_mssql.dll