how do I use Editor

how do I use Editor

edgarPedgarP Posts: 3Questions: 1Answers: 0
edited August 2016 in Free community support

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

Answers

  • allanallan Posts: 61,446Questions: 1Answers: 10,054 Site admin

    What is the DSN that you are using? What database are you using?

    Allan

  • edgarPedgarP Posts: 3Questions: 1Answers: 0

    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.

  • allanallan Posts: 61,446Questions: 1Answers: 10,054 Site admin
    Answer ✓

    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

  • edgarPedgarP Posts: 3Questions: 1Answers: 0

    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

This discussion has been closed.