Cetin is correct. The issue is caused by an old ODBC driver, which Microsoft has not updated since VFP 6.0. The OLE DB Provider will work, but will require some adjustments to the reports.


>I am a Civil Servant [State Employee] for the State of Nevada and an Application Developer for the Dept. of Information Technology.
>
>I have been developing FoxPro applications for about 12 years but do not consider myself an "expert". I'm probably far from it.
>
>I recently upgraded one of my clients [a State Agency] from VFP 6.0 to 9.0. About the same time, they installed Crystal Reports 10.0.
>
>One of the tables in the database has a primary key that is definded as "AutoIncr". The rest of the tables that are related to this "main" table have a "regular key" defined as Integar. Everything works great in the FoxPro environment.
>
>Our problem is that CR 10.0 cannot open the table that has the "AutoIncr" primary key. I am assuming that this is not a problem with VFP or CR. It is probably something we are doing wrong with the "set-up" of the ODBC connection or something like that. We are able to access all the other tables in the database without a problem.
>
>I have searched all the FAQ's, and KnowledgeBase Articles that I can but I cannot find the solution. Are any of you aware of this "problem"? What might we be doing wrong? How can we resolve it or work around it? I suspect that we might not have the correct drivers to set up the ODBC connection but we don't know how to find the correct one.
>
>I am not very experienced with ODBC connections but I'm trying to learn. If you have any answers and/or suggestions, I would appreciate a reply here on the UT and *also* to my work email because I am in training in Reno, NV for the rest of the week and don't know if I have access to the UT from my classroom [I *do* have access to my work email account].
>
>Thank you all in advance for any answers you can give me. This problem *must* be resolved before Friday July 1st, the start of our new Fiscal Year, and my customer will be out of funds.
>
>Best Regards,
>Jack in Carson City, Nevada