Skip to Content
author's profile photo Bertrand PATIGNY
Bertrand PATIGNY

Using ODBC driver FOXPRO DBF

Posted on Nov 19, 2008 at 09:47 AM 58 Views

Hello, i am defining a connection using ODBC with foxpro, i am able to see the table but not the column

Are there parameters to adapt somewhere (SBO,...)

SAP BusinessObjects - Semantic Layer
Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2008 at 06:44 PM

    Hi Bertrand

    Please let me know the following information:

    - Exact version of Crystal Reports Designer. (For this information open Crystal Reports. Go to Help > About Crystal Reports).

    - Exact version of the Business Objects Enterprise.

    - Exact version of the Database.

    - Type and the version of the driver used to connect.

    - Are you able to view all the columns when you create Crystal Report directly using ODBC connection?

    - What happens if you create the Data Connection using OLEDB or Native connection?

    Hope this helps.

    Thanks!

    Add comment
    10|10000 characters needed characters exceeded

    • Bertrand PATIGNY
      Nov 24, 2008 at 09:04 AM

      Hello,

      it is not under Crystal reports but universe designer and webi 3.1

      the issue is about the fact that the last version of visual foxpro with generic ODBC doesn't support special field such as varchar(n)... So for the moment the workaround is to copy the database and use fields definition compatible with generic odbc.

      the problem is partly solved.