how do I use Editor
how do I use Editor
edgarP
Posts: 3Questions: 1Answers: 0
Hello all.
I am trying to use Editor for my web but in the config.php file show me the next error.-
The error reported by the server was: SQLSTATE[IMSSP]: The DSN string ended unexpectedly.
so I cannot save or get data of my data base.
Thank in advance
PD.- sorry for my english. XD
This question has an accepted answers - jump to answer
This discussion has been closed.
Answers
What is the DSN that you are using? What database are you using?
Allan
Hi Allan, I am using SQL server 2012
here is my script of conection
$sql_details = array(
"type" => "Sqlserver",
"user" => "user",
"pass" => "pass",
"host" => "ip/instance",
"port" => "",
"db" => "database",
"dsn" => "?"
);
I have put PDO_SQLSRV and empty value but both do not work.
For the dsn parameter it should just be empty for SQL Server from PHP.
Also when I've used PHP to connect to SQL Server in the past (which I always found really difficult to do!) U used the form
"host\\instance"
rather than"host/instance"
.Allan
Dear friend, I have made the changes that you said me and them are working; now I can save and get data of my data base.
Thank you so much for you help