>Hi guys,
>
> I am having a table with a primary key as AUTO INCREMENT.
>
>When i try to open this table in Crystal Reports using ODBC i get the error
>

<b> ODBC error: [Microsoft][ODBC Visual Foxpro Driver] Not a table </b>

>
>Going back to the table in foxpro, if i change the Integer (Auto Inc) to INTEGER, i am able to access this table in CR using ODBC. So it seems that INTEGER AUTO INC is causing problem with ODBC drivers.
>
>
>Then i setup a "VFPOLEDB for Visual Foxpro" connection and i am able to access the table in Crystal Reports without any problem.
>
>

<h2><b>MY PROBLEM</b></h2>

>
>From my VFP program i was creating ODBC connection programatically but how can i create a VFPOLEDB connection progamatically from VFP so that Crystal Reports can access the table.
>
>I have approx 50 reports created in CR 8.5 and all the reports were using ODBC connection so how can all these reports be changed to start using VFPOLEDB connection?
>
>Any help/suggestions/ will be highly appreciated.

I believe the VFP ODBC driver only supports DBCs up to VFP6. None of the more recent features.

For OLEDB connection: http://connectionstrings.com/visual-foxpro