Seems to be the database is still in use.
Are you really sure that your database is closed?
Maybe you don't want to, but try "CLOSE DATABASES ALL"
Then find out why the database is still open:
Possible:
1) database was not current database when executing "CLOSE DATABASE"
it's a good practice to "SET DATABASE TO" the database you want to close:
SET DATABASE TO <your database to close>
CLOSE DATABASES
2) are there other datasessions in your app that keeps the database in use?
HTH,
Leo
>I have a DTS that converts a SQL Server table to VFP. The DTS runs fine when I run it from SQL Server Enterprise Manager. However, when running the DTS from my Prg, it logs that it cannot open my DBC.
>
>I checked the DBC name and location the DTS logged, and both are correct.
>
>Also, the DTS always fails if I have Cdx indexes.
>
>Any thoughts or experience with these issues?
>=============================================
>Here's the code snippet:
>
>...some pre-processing stuff, after which I close the tables and database
>CLOSE DATABASE
>
>loDTSPackage=CREATEOBJECT('dts.package')
>loDTSPackageName=loDTSPackage.LoadFromStorageFile(curdir()+"ConsultWare - AS400 Facility Address Parsing.dts","")
>loDTSPackage.Execute
>...some post-processing stuff