Viewing 7 posts - 1 through 7 (of 7 total)
Instead of trying to import directly from DBF, could you install the ACE OLEDB 12 drivers and try this
http://www.sqlservercentral.com/Forums/Topic1286522-2799-1.aspx
January 29, 2013 at 10:08 am
I'm getting this error on one of our SQL 2008 RTM servers right now.
I've had it 2 days in a row at exactly 1am in the morning.
Rebooting gets the worker...
January 18, 2013 at 5:35 am
This is a thank you to simonspring for finding this
"This additionally can cause issues:
"
I remember running into an issue similar to this years ago with Advantage drivers.
January 3, 2013 at 9:21 am
Nevermind.
I just found that VS 2010 SP1 doesn't work properly with SQL 2012 CLR.
You have to install this overtop of your VS 2010 SP1 installation:
http://msdn.microsoft.com/en-us/data/hh297027
What's weird...
July 13, 2012 at 9:37 am
I actually loop, about every few seconds, requesting the agent job status. Once the status says it's complete, you are good to continue.
April 20, 2012 at 9:29 am
It might be easier to create an Agent Job that calls the powershell script.
Then from the Stored Procedure, call the job to run.
April 20, 2012 at 7:46 am
I've gotten this to work in our new SQL 2012 RTM 64-bit servers:
This retrives data from DBase, Advantage DB, Sybase .dbf files directly using the Microsoft ACE OLEDB 12.0 64-bit...
April 19, 2012 at 9:40 am
Viewing 7 posts - 1 through 7 (of 7 total)