Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Windows 7, Crystal 7.0, VFP 9 ODBC error
Message
De
28/07/2014 10:10:57
W. Gerry Lamb
Newkirk Products, Inc
Vermont, États-Unis
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Crystal Reports
Titre:
Windows 7, Crystal 7.0, VFP 9 ODBC error
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01604816
Message ID:
01604816
Vues:
49
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform