Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Windows 7, Crystal 7.0, VFP 9 ODBC error
Message
From
28/07/2014 10:10:57
W. Gerry Lamb
Newkirk Products, Inc
Vermont, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Crystal Reports
Title:
Windows 7, Crystal 7.0, VFP 9 ODBC error
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01604816
Message ID:
01604816
Views:
48
I have successfully created a Visual FoxPro Tables system DSN for a Windows 7 ODBC connection, using the 32-bit connector in the Syswow64 folder.
I can populate my reports using that connection, and print them from Crystal.

Here's my Fox code:
CrysApp = CreateObject("Crystal.CRPE.application")
CrysReport0 = CrysApp.OpenReport("\\Statement-DS\Statemnt\Admin\Xics\ReportC\Reports\1.rpt")
CrysReport0.DiscardSavedData 
CrysReport0.Database.Verify
CrysReport0.SelectPrinter("Adobe PDF Converter","Adobe PDF","Desktop\*.pdf")
CrysReport0.PrintOut(.F.)
Release CrysApp
This gives me this error:
ODBC error:[Microsoft][ODBC Visual FoxPro Driver]SQL: Column 'FIRSTNAME' is not found.

It appears that the report is not able to refresh the data from my Fox tables.

Your help would be greatly appreciated!

Gerry
Next
Reply
Map
View

Click here to load this message in the networking platform