data connection to fox pro file

Hi,
I have to connect to a foxpro file. What I've attempted thus far is set up a
System DSN. It's pathed to the .dbf file, and I selected the Free Table
Directory option under Database Type. In RS, I choose ODBC driver for my
Provider and for Connection, I choose the DSN I set up. When I try to choose
the Initial catalog, I get an error. The first says The Parameter is
Incorrect and the second says Login failed. Catalog Info cannot be retrieved.
Any suggestions?
Thanks!Try specifying NT user credentials in report data source (or in Report
Manager/Report properties/Datasources if report is already published)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"clutch" <clutch@.discussions.microsoft.com> wrote in message
news:3BDA72CF-9772-4459-9B2C-BDB7F7A850D7@.microsoft.com...
> Hi,
> I have to connect to a foxpro file. What I've attempted thus far is set up
a
> System DSN. It's pathed to the .dbf file, and I selected the Free Table
> Directory option under Database Type. In RS, I choose ODBC driver for my
> Provider and for Connection, I choose the DSN I set up. When I try to
choose
> the Initial catalog, I get an error. The first says The Parameter is
> Incorrect and the second says Login failed. Catalog Info cannot be
retrieved.
> Any suggestions?
> Thanks!|||Hi Clutch,
Try with leaving the Catalog, UserName and Password blank.
Have you considered using the FoxPro and Visual FoxPro OLE DB data provider?
It's downloadable from msdn.microsoft.com/downloads/updates .
--
Cindy Winegarden MCSD, Microsoft Visual Foxpro MVP
cindy_winegarden@.msn.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden
"clutch" <clutch@.discussions.microsoft.com> wrote in message
news:3BDA72CF-9772-4459-9B2C-BDB7F7A850D7@.microsoft.com...
> Hi,
> I have to connect to a foxpro file. What I've attempted thus far is set up
> a
> System DSN. It's pathed to the .dbf file, and I selected the Free Table
> Directory option under Database Type. In RS, I choose ODBC driver for my
> Provider and for Connection, I choose the DSN I set up. When I try to
> choose
> the Initial catalog, I get an error. The first says The Parameter is
> Incorrect and the second says Login failed. Catalog Info cannot be
> retrieved.
> Any suggestions?
> Thanks!

Customizing Report Parameter control; handling "available values"

I have a report that I show a bill of material based on a selected
parent. I have about 17,000 parents to select from. When I use
"available values from query" the current behavior on the report is a
drop down box where I can choose between all 17,000 where at least for
large collections I'd prefer being able to start typing in and have the
control filter the query based on what's typed into the parameter. Is
there a way to do this?Hi Benjamin.
I believe what you're looking for can be accomplished with a custom
parameter page. There is no way I know of with reporting services to
provide narrowing filter functionality out of the box.
"Benjamin Chan" <benjamin.no.spam.chan@.controlproductsinc.com> wrote in
message news:u1CkX$$gGHA.5096@.TK2MSFTNGP02.phx.gbl...
>I have a report that I show a bill of material based on a selected parent.
>I have about 17,000 parents to select from. When I use "available values
>from query" the current behavior on the report is a drop down box where I
>can choose between all 17,000 where at least for large collections I'd
>prefer being able to start typing in and have the control filter the query
>based on what's typed into the parameter. Is there a way to do this?