Errors accessing VFP data.

I have a test system setup in Reading.
SQL Server is on machine EUK01314
IIS 5 also is on machine EUK01314
Reporting services are installed on machine EUK01314
Visual Studo is on machine EUK01314
I can create reports that access SQL server data, or via ODBC, or via OLEDB
to SQL server on EUK01314.
I can use those reports from our Terminal Server, no problem.
I can create reports that access Oracle data, via ODBC, or via OLEDB to
Oracle on a server in Belgim..
I can use those reports from our Terminal Server, no problem.
I draw a total blank accessing Visual FoxPro data.
I can create reports that access VFP data, via ODBC or OLEDB.
Those reports work on EUK01314 in Visual Studio.
Those reports work on EUK01314 in IE via Report Manager.
So why on earth (or any other planet) don't they work on any other machine
?
Connection string: Driver={Microsoft Visual FoxPro
Driver};SourceType=DBC;SourceDB=\\ecengds001\connections\data\connrdp.dbc;Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO
a.. An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
a.. Cannot create a connection to data source 'DataSource1'.
(rsErrorOpeningConnection) Get Online Help
a.. ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Cannot open
file \\ecengds001\connections\data\connrdp.dbc. ERROR [IM006]
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR
[01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the
version of ODBC behavior that the application requested (see SQLSetEnvAttr).
Connection string: Driver={Microsoft Visual FoxPro
Driver};SourceType=DBC;SourceDB=\\ecengds001\connections\data\connrdp.dbc
a.. An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
a.. Query execution failed for data set 'DataSet1'.
(rsErrorExecutingCommand) Get Online Help
a.. ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Cannot open
file \\ecengds001\connections\data\service.dbf.
Connection String: Provider=VFPOLEDB.1;Data
Source=\\eukfs01\mis_deve\andersonanalysis\data\;Collating Sequence=MACHINE
a.. An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
a.. Cannot create a connection to data source 'DataSource1'.
(rsErrorOpeningConnection) Get Online Help
a.. Invalid path or file name.
Change to use credentials when connecting to datasource. (my user ID and
password)
a.. An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
a.. Cannot create a connection to data source 'DataSource1'.
(rsErrorOpeningConnection) Get Online Help
a.. Multiple-step OLE DB operation generated errors. Check each OLE DB
status value, if available. No work was done.
Change to also impersonate user in Windows after connection.
a.. An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
a.. Cannot impersonate user for data source 'DataSource1'.
(rsErrorImpersonatingUser) Get Online Help
a.. Specified method is not supported.
Remember, these work just fine when Report Manager is accessed from
EUK01314.
They do not work if Report Manager is accessed from another machine.
--
PAulHi PAul :-)
I think checking the Deleted box corresponds to SET DELETED ON which
evaluates to DELETED=YES in the connection string so be sure to verify that
you're getting what you want. Sorry I can't help on the ReportingSvcs stuff.
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@.msn.com www.cindywinegarden.com
"PAul Maskens" <pmaskens@.mvps.org> wrote in message
news:efE5woQwEHA.3872@.TK2MSFTNGP11.phx.gbl...
> Connection string: Driver={Microsoft Visual FoxPro
> Driver};SourceType=DBC;SourceDB=\\ecengds001\connections\data\connrdp.dbc;Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO|||You are using SP1, right? This looks similar to an issue that we had with
Access databases (MDBs) on remote shares. Is the FoxPro database on the same
machine as the Report Server? At one point, we were incorrectly adding an
Integrated Security property to the connection string but this should have
been fixed.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"PAul Maskens" <pmaskens@.mvps.org> wrote in message
news:efE5woQwEHA.3872@.TK2MSFTNGP11.phx.gbl...
>I have a test system setup in Reading.
> SQL Server is on machine EUK01314
> IIS 5 also is on machine EUK01314
> Reporting services are installed on machine EUK01314
> Visual Studo is on machine EUK01314
> I can create reports that access SQL server data, or via ODBC, or via
> OLEDB to SQL server on EUK01314.
> I can use those reports from our Terminal Server, no problem.
> I can create reports that access Oracle data, via ODBC, or via OLEDB to
> Oracle on a server in Belgim..
> I can use those reports from our Terminal Server, no problem.
> I draw a total blank accessing Visual FoxPro data.
> I can create reports that access VFP data, via ODBC or OLEDB.
> Those reports work on EUK01314 in Visual Studio.
> Those reports work on EUK01314 in IE via Report Manager.
> So why on earth (or any other planet) don't they work on any other machine
> ?
> Connection string: Driver={Microsoft Visual FoxPro
> Driver};SourceType=DBC;SourceDB=\\ecengds001\connections\data\connrdp.dbc;Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO
> a.. An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> a.. Cannot create a connection to data source 'DataSource1'.
> (rsErrorOpeningConnection) Get Online Help
> a.. ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Cannot open
> file \\ecengds001\connections\data\connrdp.dbc. ERROR [IM006]
> [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR
> [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the
> version of ODBC behavior that the application requested (see
> SQLSetEnvAttr).
> Connection string: Driver={Microsoft Visual FoxPro
> Driver};SourceType=DBC;SourceDB=\\ecengds001\connections\data\connrdp.dbc
> a.. An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> a.. Query execution failed for data set 'DataSet1'.
> (rsErrorExecutingCommand) Get Online Help
> a.. ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Cannot open
> file \\ecengds001\connections\data\service.dbf.
> Connection String: Provider=VFPOLEDB.1;Data
> Source=\\eukfs01\mis_deve\andersonanalysis\data\;Collating
> Sequence=MACHINE
> a.. An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> a.. Cannot create a connection to data source 'DataSource1'.
> (rsErrorOpeningConnection) Get Online Help
> a.. Invalid path or file name.
> Change to use credentials when connecting to datasource. (my user ID and
> password)
> a.. An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> a.. Cannot create a connection to data source 'DataSource1'.
> (rsErrorOpeningConnection) Get Online Help
> a.. Multiple-step OLE DB operation generated errors. Check each OLE
> DB status value, if available. No work was done.
> Change to also impersonate user in Windows after connection.
> a.. An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> a.. Cannot impersonate user for data source 'DataSource1'.
> (rsErrorImpersonatingUser) Get Online Help
> a.. Specified method is not supported.
> Remember, these work just fine when Report Manager is accessed from
> EUK01314.
> They do not work if Report Manager is accessed from another machine.
> --
> PAul
>|||Thanks Brian.
Sorry for the delay, I've been away in Utrecht.
I started out with the evaluation edition, then installed the SP1 download
onto that.
I had no errors reported during the installation of SP1, so I assume it
really completed OK.
How can I find out what the connection string being used is?
I know what I typed into the Report Manager, but you're implying that
something else is actually sent.
If there's a way to debug this, I'd like to get to the bottom of it.|||Hmm. I'm not sure there is a trace for VFP. Is it OLE DB or ODBC? For SP1,
the string should be the same (we don't add the Integrated Security flag for
other providers). You can make sure SP1 was successful by looking at the
version under http://server/reportserver.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"PAul Maskens" <pmaskens@.mvps.org> wrote in message
news:OZUD5Xx0EHA.1296@.TK2MSFTNGP10.phx.gbl...
> Thanks Brian.
> Sorry for the delay, I've been away in Utrecht.
> I started out with the evaluation edition, then installed the SP1 download
> onto that.
> I had no errors reported during the installation of SP1, so I assume it
> really completed OK.
> How can I find out what the connection string being used is?
> I know what I typed into the Report Manager, but you're implying that
> something else is actually sent.
> If there's a way to debug this, I'd like to get to the bottom of it.
>|||Sorry for the delay, I've been dragged onto a BizTalk project for a while.
Microsoft SQL Server Reporting Services Version 8.00.878.00