Hi,
I have a foxpro database--not sure what version, but it is a .dbf file and
I know it is foxpro. I need to get the data out of the database and into sql
server, so i run my DTS, and I am asked for a data source. I then select
Microsoft FoxPro VFP Driver(*.dbf).

Then, I go to create a DSN for the driver, and I select New, File Data
Source, and I select Mcrosfoft FoxPro VFP Driver (*.sql). Then, I am
prompted for a file location to go to. I go to the same folder as my .dbf
file, and I try to create a new file, but I keep getting errors.

I click Next and Finish, and I get the error:"A connection could not be made
usng the file data source parameters entered. Save non-verified file DSN" I
click Yes and then click Next, and I get an error about not finding the data
source. Can anyone help me?
This is very frustrating as I have spent the past 3 hours on this, which I
don't think should be so difficult.
Thank you.

Hi Phil,

Have you tried using the FoxPro and Visual FoxPro OLE DB data provider? It's
downloadable from http://msdn.microsoft.com/vfoxpro/downloads/updates/.

Whether you use ODBC or OLE DB you will need to determine whether your DBFs
are part of a "database container" or not. If a DBC file is present in the
directory where the DBFs are, then you need to choose the "Database" option
in the setup and navigate to the DBC file, otherwise use the "Free Table
Directory" and simply navigate to the directory where the DBFs are.

I'm not sure what you mean by "I go to the same folder as my .dbf file, and
I try to create a new file, but I keep getting errors." In the ODBC and OLE
DB setups you don't create any DBF or DBC files, just point to the ones that
are there. Also, if you're getting errors, it _really_ helps to post the
exact text of the error message! However, you mention creating a "file DSN."
Why not use a System or User DSN?


--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden (AT) msn (DOT) com www.cindywinegarden.com


"Phil" <Phil (AT) discussions (DOT) microsoft.com> wrote