I have a package that is supposed to export data to a foxpro.dbf file. There
is one step that creates the export file by using the dBase 3 odbc connector
and uses the sql "Create table" statment to create the file. I cannot get
this to work. The error I get is "Unexpected error from external database
driver(9492)".
Googling this error has not turned up any answers. I tried removing that
step and instead having a data pump export directly to this file, but that
fails as well.
Any ideas on what I am doing wrong?

ps. I set access levels on the dest folder to full control to everyone.

Thanks in advance!!

Hi Carl,

You're working with a dBase 3 driver and a FoxPro table? Are you wanting the
resulting table to be a dBase 3 DBF or a FoxPro DBF? Have you considered
using the FoxPro and Visual FoxPro ODBC drivers, downloadable from
msdn.microsoft.com/vfoxpro/downloads/updates/odbc or the FoxPro and Visual
FoxPro OLE DB data provider, downloadable from
msdn.microsoft.com/vfoxpro/downloads/updates ?

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


"Carl Henthorn" <CarlHenthorn (AT) discussions (DOT) microsoft.com> wrote

It does seem odd, but the dbase 3 drive will create a .dbf file that foxpro
can use. I seem to have gotten around my problem by moving to dBase 4 driver.
I inherited the package, so I cant speak for the state of mind of the
original developer. I do know is that using the dbase driver gets around
having to use DSN values that foxpro needs.

"Cindy Winegarden" wrote: