November 3, 2005 at 8:36 am
using sql server 2000 sp2 (at least).
I am having a hard time import a dBase file into a SQL Server table. I have indicated that the incoming file is dBase 3, 4, and 5, and I continually get the same message:
Error Source: Microsoft jet Database Engine.
Error Description: Unexpected error from external database drive (8961)
Context: Error calling OpenRowSet on the provider.
I am done this many times, but I cannot seem to be able to resolve this problem.
any guidance would be greatly appreciated.
Russ...
November 3, 2005 at 9:06 am
I have seen similar errors when one of these is happening:
a. fieldnames have spaces
b. fieldnames are over 8 characters
c. filename is over 8 characters
d. file is over 2 GB
Michelle
November 4, 2005 at 6:47 am
See if this helps:
http://support.microsoft.com/?scid=kb;en-us;321003&spid=2509&sid=50
Also, are you sure the file is dBaseIII/IV/V and not FoxPro? Try using the Visual FoxPro driver and see what happens.
November 4, 2005 at 7:52 am
Problem resolved. In searching the net I saw that the problem was possibly caused by having some Borland software installed on my PC. I figured out that the Borland BDE (Borland Database Engine?) got installed on my PC when I installed some vendor software that my users want to use, and I installed it to test it. I further discovered that the Enterprise Mgr upload would not work when I tried to use Enterprise Mgr. via my PC, but when I worked from the console of the server, it did work.
I removed the vendor software and the Borland product), and the upload of Dbase files via Enterprise mgr from my PC worked fine.
Russ...
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply