Greetings,
I am unsure if this is the correct forum to send this question, but I can't seem to find any information regarding this problem. If this is the wrong place, please direct me to the correct spot.
I am attempting to import data from a free tables FoxPro database to SQL 2000 using a DTS Package which has worked correctly every day for the past 2 years. Yesterday, I got an error.
The package has around 10 tables that it deletes, re-creates, and populates with data from the Foxpro. All of the tables except one work correctly.
When I try to do an explicit import using the ODBC connection to populate that one table, I get the following error: Context: Error calling Openrowset on the provider.
I created an access database on my local computer and setup an ODBC connection and link tables to the database to see if it would work, and it did. So I thought there might be something wrong with the ODBC data source on the SQL Server, so I deleted it and created a new one, used it and I receive the same error.
I thank you in advance for any assistance or direction you can provide me for finding an answer.
Let's see if we can narrow this down. If you use another client besides your DTS package on the same machine to access that ODBC DSN, does it work? If not, this problem is likely outside of DTS. If you create a new DTS package to get to that table, does it work? If so, then you should compare the settings of the old and new package.|||After poking around some more last night, I found extremely low disk space on the system partition.
Once I cleared some space, it works fine.
For some reason, the person before me formatted this box with only a 5gb system partition.
Luckily, this server is due for replacement soon.
Thank you for taking the time to try and help Ted.
|||Hi Clipper,
I see you've solved your problem. Did you know there is an OLE DB data provider for FoxPro? It works with all versions of Fox tables and is downloadable from http://msdn2.microsoft.com/en-us/vfoxpro/bb190232.aspx .
No comments:
Post a Comment