oracle data connection

bernie

when i try to add a data connection in oracle everything adds just fine.

If i try to view data i get ora-00903 invalid table name error - i cannot iterate through any columns.

the tables themselves are listed appropraitely but no the columns.

any thoughts?

anyone successfully connect to an oracle database?

AlexTZ

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

Hi Alex,

Great product - looks very robust - am using the oledb connection

bernie

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

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
      }