none
Browse Button is disabled

    คำถาม

  • I have created a BDC using Application Definition Editor. The connectivity with the Oracle database worked well when setting it up. I was also able to successfully create the BDC Column

    But when I try to add a new record, the Browse Button next to Check Names is disabled. What could be the issue?

     

     

    Below is the ADF XML. Hope it can help locate a clue

     

    <?xml version="1.0" encoding="utf-8" standalone="yes"?>
    <LobSystem xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://schemas.microsoft.com/office/2006/03/BusinessDataCatalog BDCMetadata.xsd" Type="Database" Version="1.0.0.0" Name="TESTLOB" xmlns="http://schemas.microsoft.com/office/2006/03/BusinessDataCatalog">
      <LobSystemInstances>
        <LobSystemInstance Name="TESTLOB_Instance">
          <Properties>
            <Property Name="rdbconnectionData Source" Type="System.String">(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.4)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORCL)))</Property>
            <Property Name="rdbconnectionIntegrated Security" Type="System.String">False</Property>
            <Property Name="rdbconnectionUser ID" Type="System.String">pay</Property>
            <Property Name="rdbconnectionPassword" Type="System.String">j0se</Property>
            <Property Name="rdbconnectionEnlist" Type="System.String">True</Property>
            <Property Name="rdbconnectionPooling" Type="System.String">True</Property>
            <Property Name="rdbconnectionMin Pool Size" Type="System.String">0</Property>
            <Property Name="rdbconnectionMax Pool Size" Type="System.String">100</Property>
            <Property Name="rdbconnectionUnicode" Type="System.String">False</Property>
            <Property Name="rdbconnectionLoad Balance Timeout" Type="System.String">0</Property>
            <Property Name="rdbconnectionOmit Oracle Connection Name" Type="System.String">False</Property>
            <Property Name="DatabaseAccessProvider" Type="Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db.DbAccessProvider">Oracle</Property>
            <Property Name="SsoApplicationId" Type="System.String">ORION10</Property>
            <Property Name="AuthenticationMode" Type="Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db.DbAuthenticationMode">RdbCredentials</Property>
          </Properties>
        </LobSystemInstance>
      </LobSystemInstances>
      <Entities>
        <Entity EstimatedInstanceCount="10000" Name="PAY.PM_EMP_KEY">
          <Identifiers>
            <Identifier TypeName="System.String" Name="EMP_CODE" />
          </Identifiers>
          <Methods>
            <Method Name="Find_PAY.PM_EMP_KEY">
              <Properties>
                <Property Name="RdbCommandType" Type="System.Data.CommandType, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">Text</Property>
                <Property Name="RdbCommandText" Type="System.String">Select "EMP_CODE","EMP_NAME","EMP_REF_FROM","EMP_REF_TXN_CODE" from  PAY.PM_EMP_KEY where EMP_CODE=:EMP_CODE</Property>
              </Properties>
              <Parameters>
                <Parameter Direction="In" Name="EMP_CODE">
                  <TypeDescriptor TypeName="System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" IdentifierName="EMP_CODE" Name="EMP_CODE">
                    <Properties>
                      <Property Name="ShowInPicker" Type="System.Boolean">true</Property>
                    </Properties>
                  </TypeDescriptor>
                </Parameter>
                <Parameter Direction="Return" Name="@PAY.PM_EMP_KEY">
                  <TypeDescriptor TypeName="System.Data.IDataReader, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" IsCollection="true" Name="Reader">
                    <TypeDescriptors>
                      <TypeDescriptor TypeName="System.Data.IDataRecord, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Name="Record">
                        <TypeDescriptors>
                          <TypeDescriptor TypeName="System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" IdentifierName="EMP_CODE" Name="EMP_CODE" />
                          <TypeDescriptor TypeName="System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Name="EMP_NAME" />
                          <TypeDescriptor TypeName="System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Name="EMP_REF_FROM" />
                          <TypeDescriptor TypeName="System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Name="EMP_REF_TXN_CODE" />
                        </TypeDescriptors>
                      </TypeDescriptor>
                    </TypeDescriptors>
                  </TypeDescriptor>
                </Parameter>
              </Parameters>
              <MethodInstances>
                <MethodInstance Type="SpecificFinder" ReturnParameterName="@PAY.PM_EMP_KEY" ReturnTypeDescriptorName="Reader" ReturnTypeDescriptorLevel="0" Name="Find_PAY.PM_EMP_KEY_Instance" />
              </MethodInstances>
            </Method>
            <Method Name="FindAll_PAY.PM_EMP_KEY">
              <Properties>
                <Property Name="RdbCommandType" Type="System.Data.CommandType, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">Text</Property>
                <Property Name="RdbCommandText" Type="System.String">Select "EMP_CODE" from  PAY.PM_EMP_KEY</Property>
              </Properties>
              <Parameters>
                <Parameter Direction="Return" Name="@PAY.PM_EMP_KEY">
                  <TypeDescriptor TypeName="System.Data.IDataReader, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" IsCollection="true" Name="Reader">
                    <TypeDescriptors>
                      <TypeDescriptor TypeName="System.Data.IDataRecord, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Name="Record">
                        <TypeDescriptors>
                          <TypeDescriptor TypeName="System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" IdentifierName="EMP_CODE" Name="EMP_CODE">
                            <Properties>
                              <Property Name="ShowInPicker" Type="System.Boolean">true</Property>
                            </Properties>
                          </TypeDescriptor>
                        </TypeDescriptors>
                      </TypeDescriptor>
                    </TypeDescriptors>
                  </TypeDescriptor>
                </Parameter>
              </Parameters>
              <MethodInstances>
                <MethodInstance Type="IdEnumerator" ReturnParameterName="@PAY.PM_EMP_KEY" ReturnTypeDescriptorName="Reader" ReturnTypeDescriptorLevel="0" Name="FindAll_PAY.PM_EMP_KEY_Instance" />
              </MethodInstances>
            </Method>
          </Methods>
        </Entity>
      </Entities>
    </LobSystem>

    • แก้ไขโดย Mike Walsh FIN 14 กรกฎาคม 2553 10:29 Moderator Note: If nobody has replied to your post (in 2 minutes difficult) and you want to add something to it, EDIT your original post, do not add a "reply".
    14 กรกฎาคม 2553 10:00

ตอบทั้งหมด