Ошибка odbc sqlstate 01s00

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and
privacy statement. We’ll occasionally send you account related emails.

Already on GitHub?
Sign in
to your account

I had never used PDO for to connect with Informix database before, this error poped up while I was running a basic query:

SQLSTATE=01S00, SQLDriverConnect: -11005 [Informix][Informix ODBC Driver]Invalid connection string attribute. 

And this is my code:

<?php

class prueba{
private static $cn = null;

 public static function conectar(){
    if(self::$cn !== null ) {
      return self::$cn;
    }
    try{
       self::$cn= new PDO("informix:host=localhost; service=30000;
    database=mrroot; server=mrserver; protocol=onsoctcp;
    EnableScrollableCursors=1", "mrtony", "");
       return self::$cn;

    } catch (PDOException $ex){
       die($ex->getMessage());
    }
  }


 public static function consulta(){

    $query = "SELECT * FROM fr_envio";

    $cn = prueba::conectar();

    $resultado = $cn->prepare($query);

    $resultado->execute();

        echo '<table>';
        while ($row = $resultado->fetch(PDO::FETCH_ASSOC))
            {
                echo '<tr>';
                echo '<td>'.$row['enviopre'].'</td>';
                echo '<td>'.$row['enviofra'].'</td>';
                echo '<td>'.$row ['enviopec'].'</td>';
                echo '<td>'.$row ['envioval'].'</td>';
                echo '</tr>';
            }

        echo '</table>';

}

}


$prueba = new prueba();

$prueba->consulta();
?>  

I’ve tested the same code on Mysql, just change the connection string, and everything works perfect, it seems like the connection string is missing something, and I dont know what it could be.

I followed what is says in this tutorial:

https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.virtapp.doc/TD_item2.htm

asked Dec 11, 2017 at 13:54

root@irk:/usr3/products/php53# cat test.php
<?php

$db = new PDO("informix:host=irk;service=3046;database=stores7;
server=irk1210;protocol=onsoctcp;EnableScrollableCursors=1;", "informix", "ximrofni");

print "Connection Established!\n\n";

$stmt = $db->query("select * from systables");
$res = $stmt->fetch( PDO::FETCH_BOTH );
$rows = $res[0];
echo "Table contents: $rows.\n";


?>
root@irk:/usr3/products/php53# php test.php
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE=01S00, SQLDriverConnect: -11005 [Informix][Informix ODBC Driver]Invalid connection string attribute.' in /usr3/products/php5/test.php:4
Stack trace:
#0 /usr3/products/php5/test.php(4): PDO->__construct('informix:host=i...', 'informix', 'ximrofni')
#1 {main}
  thrown in /usr3/products/php5/test.php on line 4
root@irk:/usr3/products/php53# 

root@irk:/usr3/products/php53# cat test.php
<?php

$db = new PDO("informix:host=irk;service=3046;database=stores7; server=irk1210;protocol=onsoctcp;EnableScrollableCursors=1;", "informix", "ximrofni");

print "Connection Established!\n\n";

$stmt = $db->query("select * from systables");
$res = $stmt->fetch( PDO::FETCH_BOTH );
$rows = $res[0];
echo "Table contents: $rows.\n";


?>
root@irk:/usr3/products/php53# php test.php
Connection Established!

Table contents: systables.
root@irk:/usr3/products/php53# 

2

Answers

• Try set up login administrator to SQL Server account. Then , take a look into ERROR.LOG to see to what port sql server listens to. Make sure that SQL Server browser is running up. 

  SERVERNAME\EXPERESS,5555 —-specify port number

  ---

  Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

  • Marked as answer by

    Monday, June 18, 2012 9:52 AM

• Based on

  «The SQL Server (SQLEXPRESS) service failed to start due to the following error:
  
  The service did not start due to a logon failure.»

  It sounds like your password has changed. Use SQL Server Configuration Manager to update the password, or change the SQL Server Express Database Engine to start under another account.

  ---

  Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty

  • Marked as answer by
    Maggie Luo
    Monday, June 18, 2012 9:51 AM

Twitter: @SQLife
Email: sqlsalt(at)outlook(dot)com