Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Auto Incrementing field in table causing connector error
Message
General information
Forum:
Visual FoxPro
Category:
Crystal Reports
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01011720
Message ID:
01011727
Views:
18
It's not Crystal. The VFP ODBC driver has not been updated since VFP 6.0 and knows nothing about AutoInc fields nor database events. Use the VFP OLE DB provider instead.

>I added an auto incrementing field to a table. When I try to add this table to a Crystal report (Version XI), I get the following error:
>
>Database Connector Error: '42S02: [Microsoft][ODBC Viasual Foxpro Driver]NOt a table. [Database Vendor Code: 123]
>
>If I remove the auto increment field, I can add the table to the report. Does anyone have any ideas how to get around/fix this?
>
>Scott
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform