개정판 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
