oracle data connection

Comments

• AlexTZ

  July 2009 edited 2:43AM

  Hello,
  
  Which connection do you use to connect to Oracle? Is it the Ole DB connection, or do you use Oracle add-in (from FRNetConnections.zip package)?
• bernie

  July 2009 edited 2:43AM

  Hi Alex,
  
  Great product - looks very robust - am using the oledb connection
• bernie

  July 2009 edited 2:43AM

  i did download the frconnections.zip
  
  build the oracle provider and was successfully able to add the connection/test the connection.
  
  However now the behavior is such that it does not show the table list even though i can successfully connect.
  
  logging into the scott/tiger schema in oracle 9.2
• AlexTZ

  July 2009 edited 2:43AM

  The provider displays tables available to the current user. See this method in the OracleDataConnection.cs:
  

    public class OracleDataConnection : DataConnectionBase
    {
      private void GetDBObjectNames(string name, string columnName, List<string> list)
      {
        DataTable schema = null;
        using (DbConnection connection = GetConnection())
        {
          connection.Open();
          OracleConnectionStringBuilder builder = new OracleConnectionStringBuilder(connection.ConnectionString);
          schema = connection.GetSchema(name, new string[] { builder.UserID, null }); // <<<<<<<<<<<<<<<<< get tables available to UserID
        }