code_junkie

What would be the most convenient way to connect Visual Studio 2005 (C#) to Oracle8?

Nov 11th, 2011
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.84 KB | None | 0 0
  1. using System.Data;
  2. using System.Data.OracleClient;
  3.  
  4. try
  5. {
  6. StringBuilder str = new StringBuilder();
  7. string ora = Properties.Settings.Default.OracleConnectionString;
  8.  
  9. OracleConnection con = new OracleConnection(ora);
  10. OracleCommand cmd = new OracleCommand();
  11.  
  12. cmd.Connection = con;
  13. cmd.CommandText = "SELECT timestamp FROM jde_out WHERE rownum = 1";
  14. cmd.CommandType = CommandType.Text;
  15.  
  16. con.Open();
  17. OracleDataReader rdr = cmd.ExecuteReader();
  18. rdr.Read();
  19.  
  20. str.AppendLine(cmd.ExecuteScalar().ToString());
  21. this.lblJDEtime.Text = str.ToString();
  22. rdr.Close();
  23. con.Close();
  24. }
  25. catch (OracleException err)
  26. {
  27. MessageBox.Show("Exception caught:nn" + err.ToString());
  28. }
  29.  
  30. <?xml version='1.0' encoding='utf-8'?>
  31. <configuration>
  32. <connectionStrings>
  33. <clear />
  34. <add name="Name"
  35. providerName="System.Data.ProviderName"
  36. connectionString="Valid Connection String;" />
  37. </connectionStrings>
  38. </configuration>
  39.  
  40. <add key="ODP.NET.ConnectionString" value="Password=abcdefg;Persist Security Info=True;User ID=abc123;Data Source=blah;"/>
  41.  
  42. string connectionString = @"
  43. SERVER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP
  44. (HOST=OracleHost)(PORT=OraclePort))
  45. (CONNECT_DATA=(SERVICE_NAME=OracleServiceName)))
  46. ;uid=UserID;pwd=Password;";
  47.  
  48. <?xml version="1.0" encoding="utf-8" ?>
  49. <configuration>
  50. <appSettings>
  51. <add key="My.Database.Connection" value="SERVER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP
  52. (HOST=OracleHost)(PORT=OraclePort))
  53. (CONNECT_DATA=(SERVICE_NAME=OracleServiceName)))
  54. ;uid=UserID;pwd=Password;" />
  55. </appSettings>
  56. </configuration>
  57.  
  58. connectionString = ConfigurationSettings.AppSettings["My.Database.Connection"];
Add Comment
Please, Sign In to add comment