Message
From
12/12/2006 11:34:31
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
VFP and SQL Reporting Services
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01176890
Message ID:
01176890
Views:
209
We have VFP data that we get are wanting to run reports on from SQL Reporting Services 2000. In SQL RS we setup the following OLEDB connection: < Provider=VFPOLEDB.1;Data Source=\\server\data\foxpro\db.dbc;Collating Sequence=MACHINE > The connection works fine in design builder but when the report is published it the connection does not work. Any ideas?