c# FTP的使用 -- 取得FTP Server的檔案列表(ls)

// Get file list
public string[] FtpDir()
{
string Result = "";
if (this.InputValidation())
{
try
{
Uri UriFtpDir = new Uri("ftp://" + serverhost + ":" + serverport + dirpath + filter);
FtpWebRequest request = (FtpWebRequest)WebRequest.Create(UriFtpDir);
request.Method = WebRequestMethods.Ftp.ListDirectory;


request.Credentials = new NetworkCredential(username, password);

FtpWebResponse response = (FtpWebResponse)request.GetResponse();

StreamReader MyStreamReader = new StreamReader(response.GetResponseStream(), System.Text.Encoding.Default);
returnmsg = response.BannerMessage;
returncode = response.StatusCode.ToString();

Result = MyStreamReader.ReadToEnd();
}
catch (Exception ex)
{
returnmsg = ex.ToString();
returncode = "0";
throw new ArgumentException(returnmsg);
}

}
else
{
throw new ArgumentException(returnmsg);
}
return Strings.StringToLines(Result);
}

c# FTP的使用 -- 取得FTP Server的檔案(get)

// Get ftp file content
//public StreamReader FtpGet()
public bool FtpGet()
{
FileStream fileStream = null;
Stream responseStream = null;

if (this.InputValidation())
{
try
{
Uri UriFtpGet = new Uri("ftp://" + serverhost + ":" + serverport + dirpath + remotefile);
FtpWebRequest request = (FtpWebRequest)WebRequest.Create(UriFtpGet);
request.Method = WebRequestMethods.Ftp.DownloadFile;
request.Credentials = new NetworkCredential(username, password);


FtpWebResponse response = (FtpWebResponse)request.GetResponse();

responseStream = response.GetResponseStream();

returnmsg = response.BannerMessage;
returncode = response.StatusCode.ToString();

// Write into file
if (localfile == null)
localfile = Path.GetFileName(request.RequestUri.AbsolutePath);

fileStream = File.Create(localPath + @"\" + localfile);
byte[] buffer = new byte[1024];

int bytesRead;

while (true)
{

bytesRead = responseStream.Read(buffer, 0, buffer.Length);

if (bytesRead == 0)
break;

fileStream.Write(buffer, 0, bytesRead);

}
responseStream.Close();
fileStream.Close();

return true;

}
catch (Exception ex)
{
returnmsg = ex.ToString();
returncode = "0";
return false;
}
}
else
{
throw new ArgumentException(returnmsg);

}

}

ora-12154 tns could not resolve the connect identifier specified

今天裝了二次Oracle Client，第一次失敗，第二次成功
接著我設定組態，也成功連結到資料庫

但在使用SQL/Plus以及 PL/SQL的時候出現：
ora-12154 tns could not resolve the connect identifier specified

上網搜尋後，也有很多人遇到相同的問題，我依方法進行確認
發現我環境變數path是：
d:\oracle11g\client_1\bin;d:\oracle11g\client_2\bin;...
修改成
d:\oracle11g\client_1;d:\oracle11g\client_1\bin;...

就可以使用SQL/Plus 和 PL/SQL 了