Using ODBC driver FOXPRO DBF

[I051914]

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,...)

[Former Member · Accepted solution]

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!

[I051914 · Accepted solution]

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.