Uploaded image for project: 'CUBRID APIs'
  1. CUBRID APIs
  2. APIS-645

[ODBC][OLEDB][8.4.4]Cannot connect to CUBRID 8.4.4 shard db with ODBC/OLEDB driver

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Cannot Reproduce
    • Affects Version/s: ODBC-8.4.4, OLEDB 8.4.4
    • Fix Version/s: None
    • Component/s: ODBC, OLEDB
    • Labels:
    • Environment:
      • OS: Win64bit
      • CUBRID: 8.4.4.0227
      • Driver: cubrid-odbc 8.4.4.0001 (20130821)
        cubrid-oledb 8.4.4.0001 (20130821)
      • Framework: .NET 4.0

      Description

      • Brief: Cannot connect to CUBRID 8.4.4 shard db with ODBC/OLEDB 8.4.4 driver
      • CUBRID 8.4.4. shard configration: see attachments
      • Test Code
        OLEDB 8.4.4 {code}
        [Test, Description("Test OLEDB Shard Connection")]
        public void OleDbShardTest_Connection()
        { string strConn = @"Provider=CUBRID OLE DB Provider;Data Source=shard1;Location=10.34.64.57;User ID=dba;Port=36059;"; OleDbConnection connCubrid = new OleDbConnection(); connCubrid.ConnectionString = strConn; connCubrid.Open(); Assert.AreEqual("System.Data.OleDb.OleDbConnection", connCubrid.GetType().ToString()); connCubrid.Close(); }
        {code}

      ODBC 8.4.4

      {code}
      [Test, Description("Test for connection between ODBC and Shard DB - APIS 615")]
      public void OdbcShard_Connection1()
      {
      // Open Shard Connectionaaa
      string strConn = @"Driver={CUBRID Driver};db_name=shard1;uid=dba;pwd=;server=10.34.64.57;port=36059;fetch_size=100";
      OdbcConnection connCubrid = new OdbcConnection(strConn);
      connCubrid.Open();
      Console.WriteLine(connCubrid.State);
      Assert.AreEqual(ConnectionState.Open, connCubrid.State);
      connCubrid.Close();
      }{code}
      1. shard_connection.txt
        0.5 kB
        Ray Yin
      2. shard_key.txt
        0.2 kB
        Ray Yin
      3. shard.conf
        2 kB
        Ray Yin

        Activity

        Hide
        cn15800 谢韦华[Bert] added a comment -

        I have test the issue, but driver can connect shard db successful.

        Can you excute the command?

        {code}

        1 cubrid createdb --db-volume-size=20M --log-volume-size=20M shard1
        2 cubrid createdb --db-volume-size=20M --log-volume-size=20M shard2
        3 cubrid server start shard1
        4 cubrid server start shard2
        5 cubrid service start
        6 cubrid shard start
        {code}
        Show
        cn15800 谢韦华[Bert] added a comment - I have test the issue, but driver can connect shard db successful. Can you excute the command? {code} 1 cubrid createdb --db-volume-size=20M --log-volume-size=20M shard1 2 cubrid createdb --db-volume-size=20M --log-volume-size=20M shard2 3 cubrid server start shard1 4 cubrid server start shard2 5 cubrid service start 6 cubrid shard start {code}
        Hide
        cn15800 谢韦华[Bert] added a comment -

        My config file is same with attachments

        Show
        cn15800 谢韦华[Bert] added a comment - My config file is same with attachments
        Hide
        ryin005 Ray Yin added a comment -
        • OS: Win7 32bit, WinXP 64bit
        • CUBRID: 8.4.4.0227
        • Driver: cubrid-odbc 8.4.4.0001 (20130822)
          cubrid-oledb 8.4.4.0001 (20130822)
        • Framework: .NET 4.0

        Test Result: Pass

        The problem can not be reproduced, close the issue

        Show
        ryin005 Ray Yin added a comment - OS: Win7 32bit, WinXP 64bit CUBRID: 8.4.4.0227 Driver: cubrid-odbc 8.4.4.0001 (20130822) cubrid-oledb 8.4.4.0001 (20130822) Framework: .NET 4.0 Test Result: Pass The problem can not be reproduced, close the issue

          People

          • Assignee:
            cn15800 谢韦华[Bert]
            Reporter:
            ryin005 Ray Yin
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: