[eluser]HDuqueC[/eluser]
Hi to all,
I'm doing something wrong but I can't realize what it is!. I have a simple PHP script like this, that runs fine:
<?php
$myServer = "mysrvr";
$myUser = "myuser";
$myPass = "mypass";
$myDB = "mydatabase";
$conn = new COM ("ADODB.Connection") or die("Cannot start ADO");
$connStr = "PROVIDER=SQLOLEDB;SERVER=".$myServer.";UID=".$myUser.";PWD=".$myPass.";DATABASE=".$myDB;
$conn->open($connStr);
...etc...etc...
?>
I'm trying to connect using CI but always fails:
In my database.php :
$db['default']['hostname'] = "mysrvr";
$db['default']['username'] = "myuser";
$db['default']['password'] = "mypass";
$db['default']['database'] = "mydatabase";
$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";
But in my controller the line
$this->load->database();
Raises connection fails.
What am I doing wrong? Any help will be appreciated.
Nando.
