CUBRID ODBC DB Connection DataSet 오류
안녕하십니까?
DB Connection DataSet 오류 관련해서 문의 드립니다.
DB 접속 정보
StringBuilder sb = new StringBuilder();
sb.Append("driver={Cubrid Driver};");
sb.Append(string.Format("SERVER={0};PORT={1};"
, m_reg.GetConfigValue(C_Reg.RegMode.MI, "Host")
, m_reg.GetConfigValue(C_Reg.RegMode.MI, "Port")));
sb.Append(string.Format("uid={0};pwd={1};FETCH_SIZE=100;"
, m_reg.GetConfigValue(C_Reg.RegMode.MI, "ID")
, m_reg.GetConfigValue(C_Reg.RegMode.MI, "PW")));
sb.Append(string.Format("DB_NAME={0};charset=utf-8"
, m_reg.GetConfigValue(C_Reg.RegMode.MI, "Name")));
DataSet 오류부분
DataSet ds = new DataSet();
OdbcConnection conn = new OdbcConnection(GetConnstring());
try{
conn.Open();
StringBuilder strQure = new StringBuilder();
strQure.Append("SELECT ");
strQure.Append("TEAMCODE, TEAM, SORTORDER, TOPTEAMCODE, FULLDEPTCODE ");
strQure.Append("FROM ");
strQure.Append("IM_TBL_DIRECT_GROUP");
strQure.Append("WHERE ");
strQure.Append("FULLDEPTCODE Like '00082;00696%' OR FULLDEPTCODE Like '00082;P0001%' OR FULLDEPTCODE Like '00082;L0001%' OR FULLDEPTCODE Like '00082;NT00001%' OR FULLDEPTCODE Like '00082;00567%'");
OdbcCommand comm = new OdbcCommand(strQure.ToString(), conn);
comm.CommandType = CommandType.Text;
OdbcDataAdapter adapter = new OdbcDataAdapter(comm);
adapter.Fill(ds); <<<<<<<<<<<<<<<<< 이 부분에서 오류
}
catch (Exception err)
{
ds = null;
}
finally
{
conn.Close();
}
DataSet 오류 내용 : ERROR [HY000] [CUBRID][ODBC CUBRID Driver][-1006]Server handle not found
ERROR [01000] [CUBRID][ODBC CUBRID Driver][0]Fetch error