views:

232

answers:

0

Hello Friends, I am trying to connect to read Excel file data using BDC in SharePoint 2007. I have used the Microsoft ApplicationDefinitionDesigner.exe and created the following Application Definition file. I can test the Method instances and can import this file as well. But when I use this in Business Data List webpart, I am getting an exception saying "unable to connect to .....".

<LobSystemInstances>
    <LobSystemInstance Name="C:\TrustedExcelFiles\BSUKTestcaseReport-Category&amp;Product-Ver1Instance">
      <Properties>
        <Property Name="DatabaseAccessProvider" Type="Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db.DbAccessProvider">Odbc</Property>
        <Property Name="AuthenticationMode" Type="Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db.DbAuthenticationMode">RevertToSelf</Property>
        <Property Name="RdbConnection Dsn" Type="System.String">ODBCForExcel</Property>
        <Property Name="RdbConnection dbq" Type="System.String">C:\TrustedExcelFiles\TestFile.xls</Property>
        <Property Name="RdbConnection defaultdir" Type="System.String">C:\TrustedExcelFiles</Property>
        <Property Name="RdbConnection driverid" Type="System.String">790</Property>
        <Property Name="RdbConnection fil" Type="System.String">excel 8.0</Property>
        <Property Name="RdbConnection maxbuffersize" Type="System.String">2048</Property>
        <Property Name="RdbConnection pagetimeout" Type="System.String">5</Property>
        <Property Name="rdbconnection Trusted_Connection" Type="System.String">yes</Property>
      </Properties>
    </LobSystemInstance>
  </LobSystemInstances>

Can anyone, please suggest me as of how can I go ahead with the following: 1. what type of data should I have in my Excel file 2. What is the connection string to be used for connecting in LobSystemInstance. Otherwise if you have a sample excel file, please share the same with me. This is very urgent for me. Please help me.