rajibc
Posts: 3
|
| Posted: 12/12/2009, 11:42 PM |
|
I am using the lastest version of codecharge. while connecting to MS SQL server 2008 bypasssing the DSN ( not creating ) , I am not able to access the database, below the way i have set the connecting string in common.php file.
//Connection Settings @0-91A0449C
$CCConnectionSettings = array (
"database" => array(
"Type" => "SQLSERVER",
"DBLib" => "MSSQL",
"Database" => "internet", //Db is properly created in SQL server 2008 with windows authentication.
"Host" => "localhost",
"Port" => "",
"User" => "",
"Password" => "",
"UseODBCCursor" => "",
"Persistent" => false,
"DateFormat" => array("yyyy", "-", "mm", "-", "dd", " ", "HH", ":", "nn", ":", "ss"),
"BooleanFormat" => array("true", "false", ""),
"Uppercase" => false
)
);
//End Connection Settings
let me know how to resolve it asap.
I would like the database information to be given in the connection string without creating a system DSN as the code would needed to be port to Windows Azure cloud.
Rajib Chakraborty
|
 |
 |
damian
Posts: 838
|
| Posted: 12/13/2009, 2:58 AM |
|
i assume you have actually specified a username and password?
_________________
if you found this post useful take the time to help someone else.... :)
|
|
|
|
rajibc
Posts: 3
|
| Posted: 12/13/2009, 6:21 AM |
|
Windows authentication doesn't require username and password to be given explicitly, anyway , i have tried with user name and password also but still it didn't work .
|
|
|
|
datadoit
|
| Posted: 12/13/2009, 11:30 AM |
|
What are you setting in the connection dialogs? Don't hack at the
Common.php file directly.
|
|
|
|
rajibc
Posts: 3
|
| Posted: 12/14/2009, 4:33 AM |
|
I have insterted values from connection setting
here is the DB setting in common.php file. Do I need to change anything in php.ini file to connect SQL Server 2008 Enterprise ?
//Connection Settings @0-E3992D24
$CCConnectionSettings = array (
"internet" => array(
"Type" => "MSSQLServer",
"DBLib" => "MSSQL",
"Database" => "internet",
"Host" => "localhost",
"Port" => "",
"User" => "administrator",
"Password" => "Password1",
"Persistent" => true,
"DateFormat" => array("yyyy", "-", "mm", "-", "dd", " ", "HH", ":", "nn", ":", "ss"),
"BooleanFormat" => array(1, 0, ""),
"Uppercase" => false
)
);
|
|
|
|
Benjamin Krajmalnik
|
| Posted: 12/16/2009, 4:52 PM |
|
Yes, but the security context is such that your IIS user probably does not
have access to the database, nor would you want to grant it.
"rajibc" <rajibc@forum.codecharge> wrote in message
news:54b24f85d6a6c4@news.codecharge.com...
> Windows authentication doesn't require useranem and password to be given
> explicitly, anyway , i have tried with user name and password also but
> still it
> didn't work .
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
|
