개정판 8e1eaa19
dev issue #000 : fix
Change-Id: I5feaf5ab9baf5a04813e2c4a2cd38caddbe2385b
DTI_PID/SPPIDConverter/DB/SPPID_DB.cs | ||
---|---|---|
302 | 302 |
List<string> attributes = new List<string>(); |
303 | 303 |
SPPID_DBInfo dbInfo = SPPID_DBInfo.GetInstance(); |
304 | 304 |
DataTable dt = null; |
305 |
string connString = string.Empty; |
|
305 | 306 |
try |
306 | 307 |
{ |
307 | 308 |
if (dbInfo.DBType == "ORACLE") |
308 | 309 |
{ |
309 |
string connString = string.Format(oracleConnString, dbInfo.ServerIP, dbInfo.Port, dbInfo.Service);
|
|
310 |
connString = string.Format(oracleConnString, dbInfo.ServerIP, dbInfo.Port, dbInfo.Service); |
|
310 | 311 |
connString = "Data Source=" + connString + ";User Id=" + dbInfo.DBUser + ";Password=" + dbInfo.DBPassword; |
311 | 312 |
|
312 | 313 |
using (OracleConnection conn = new OracleConnection(connString)) |
... | ... | |
336 | 337 |
} |
337 | 338 |
else if (dbInfo.DBType == "SQLSERVER") |
338 | 339 |
{ |
339 |
string connString = string.Format("server = {0}; uid = {1}; pwd = {2}; database = {3};", dbInfo.Service, dbInfo.DBUser, dbInfo.DBPassword, dbInfo.PlantPIDDic_DataBase);
|
|
340 |
connString = string.Format("server = {0}; uid = {1}; pwd = {2}; database = {3};", dbInfo.Service, dbInfo.DBUser, dbInfo.DBPassword, dbInfo.PlantPIDDic_DataBase); |
|
340 | 341 |
using (SqlConnection conn = new SqlConnection(connString)) |
341 | 342 |
{ |
342 | 343 |
conn.Open(); |
... | ... | |
366 | 367 |
} |
367 | 368 |
catch (Exception ex) |
368 | 369 |
{ |
369 |
System.Windows.Forms.MessageBox.Show(ex.Message + "\r\n" + ex.StackTrace); |
|
370 |
System.Windows.Forms.MessageBox.Show("Connection String : " + connString + "\r\n" + ex.Message + "\r\n" + ex.StackTrace);
|
|
370 | 371 |
} |
371 | 372 |
|
372 | 373 |
return dt; |
내보내기 Unified diff