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

Using ODBC driver FOXPRO DBF

Posted on Nov 19, 2008 at 09:47 AM 81 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,...)

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

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

    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 a 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.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.