Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.

Dismiss

Pervasive Import/Export

0 views

Skip to first unread message

David Lozzi

unread,

Jun 4, 2007, 4:26:58 PM6/4/07

Howdy,

I have a Pervasive 8.7 database that I need to periodically export data from
and into my SQL 2000 database for reporting. I'm trying to use a DTS
Package. I have the source setup and the destination, but when I go to
Transformation tab of the Transform Data Task, I get the following error:

[Pervasive][ODBC Client Interface][LNA][Pervasive][OBDC Engine
Interface][Data Record Manager]The file is locked (Btrieve Error 85)
[Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine
Interface]Unable to open table: Customers.

And then the tab is blank. However I can open the database fine through the
Pervasive Control Center without any lock issues.

Does anyone have or know of a utility that would simplify the
importing/exporting of Pervasive data to SQL?

Thanks!!

David Lozzi

0 new messages