Share via


SQL Server is terminating because of fatal exception c0000005

Question

Thursday, July 9, 2020 4:29 AM

Hi

Can someone help me understand how to resolve this error. 

NOTE: I'm not a professional. I'm just helping my family setup our small business sales data into sql. I know how to construct sql query but don't have a lot of knowledge in setting up the database and I've mostly used wizards to create the database we have now.

The code causing the error is a series of queries to pull data from DBF and dump into a sql table like this

INSERT INTO  #ALLFILENAMES2

EXEC Master..xp_cmdShell 'dir 'C:\POS001\.DBF /b'

insert into #B select '01211DT' as [filename], *, 
   getdate() as [dateprocessed] from 
   OPENROWSET('Microsoft.ACE.OLEDB.12.0','dBase IV;DATABASE=C:\POS001','select * from 01211DT')

This is the error message from the log

(I've installed SP3 hot fix based on another thread here but it still did not work, i've also deleted a lot of records from the tables because I thought I might be running out of space but it didn't work either). 

 SQL Server is terminating because of fatal exception c0000005. This error may be caused by an unhandled Win32 or C++ exception, or by an access violation encountered during exception handling. Check the SQL error log for any related stack dumps or messages. This exception forces SQL Server to shutdown. To recover from this error, restart the server (unless SQLAgent is configured to auto restart).
2020-07-09 00:03:53.68 Server      Using 'dbghelp.dll' version '4.0.5'
2020-07-09 00:03:53.69 Server      **Dump thread - spid = 0, EC = 0x00000000
2020-07-09 00:03:53.69 Server      ***Stack Dump being sent to c:\Program Files (x86)\Microsoft SQL Server\MSSQL11.PALANA\MSSQL\LOG\SQLDump0014.txt
2020-07-09 00:03:53.69 Server      * *******************************************************************************
2020-07-09 00:03:53.69 Server      *
2020-07-09 00:03:53.69 Server      * BEGIN STACK DUMP:
2020-07-09 00:03:53.69 Server      *   07/09/20 00:03:53 spid 14728
2020-07-09 00:03:53.69 Server      *
2020-07-09 00:03:53.69 Server      * ex_handle_except encountered exception C0000005 - Server terminating
2020-07-09 00:03:53.69 Server      *
2020-07-09 00:03:53.69 Server      *
2020-07-09 00:03:53.69 Server      *  MODULE                          BASE      END       SIZE
2020-07-09 00:03:53.69 Server      * sqlservr                       00EA0000  00EF1FFF  00052000
2020-07-09 00:03:53.69 Server      * ntdll                          770A0000  77239FFF  0019a000
2020-07-09 00:03:53.70 Server      * KERNEL32                       76B80000  76C5FFFF  000e0000
2020-07-09 00:03:53.70 Server      * KERNELBASE                     74BE0000  74DDDFFF  001fe000
2020-07-09 00:03:53.70 Server      * ADVAPI32                       74E30000  74EA8FFF  00079000
2020-07-09 00:03:53.70 Server      * msvcrt                         74A90000  74B4EFFF  000bf000
2020-07-09 00:03:53.70 Server      * sechost                        75060000  750D5FFF  00076000
2020-07-09 00:03:53.70 Server      * RPCRT4                         74F40000  74FFAFFF  000bb000
2020-07-09 00:03:53.70 Server      * SspiCli                        74870000  7488FFFF  00020000
2020-07-09 00:03:53.70 Server      * CRYPTBASE                      74860000  74869FFF  0000a000
2020-07-09 00:03:53.70 Server      * bcryptPrimitives               769B0000  76A0EFFF  0005f000
2020-07-09 00:03:53.70 Server      * MSVCR100                       71FF0000  720AEFFF  000bf000
2020-07-09 00:03:53.70 Server      * MSVCP100                       746D0000  74738FFF  00069000
2020-07-09 00:03:53.70 Server      * sqlos                          6F9F0000  6F9F5FFF  00006000
2020-07-09 00:03:53.70 Server      * NETAPI32                       74280000  74292FFF  00013000
2020-07-09 00:03:53.70 Server      * pdh                            64C20000  64C5EFFF  0003f000
2020-07-09 00:03:53.70 Server      * ucrtbase                       750E0000  751FEFFF  0011f000
2020-07-09 00:03:53.70 Server      * opends60                       6F9E0000  6F9E6FFF  00007000
2020-07-09 00:03:53.70 Server      * sqlTsEs                        57AA0000  5826AFFF  007cb000
2020-07-09 00:03:53.70 Server      * ole32                          768B0000  769A6FFF  000f7000
2020-07-09 00:03:53.70 Server      * combase                        76E10000  77084FFF  00275000
2020-07-09 00:03:53.70 Server      * GDI32                          76DE0000  76E00FFF  00021000
2020-07-09 00:03:53.70 Server      * win32u                         767C0000  767D6FFF  00017000
2020-07-09 00:03:53.70 Server      * gdi32full                      75B00000  75C5AFFF  0015b000
2020-07-09 00:03:53.70 Server      * msvcp_win                      76D60000  76DDBFFF  0007c000
2020-07-09 00:03:53.70 Server      * USER32                         75240000  753D6FFF  00197000
2020-07-09 00:03:53.70 Server      * OLEAUT32                       759F0000  75A81FFF  00092000
2020-07-09 00:03:53.70 Server      * sqllang                        78480000  79E03FFF  01984000
2020-07-09 00:03:53.70 Server      * sqlmin                         79E10000  7B7FEFFF  019ef000
2020-07-09 00:03:53.70 Server      * WINTRUST                       76760000  767A5FFF  00046000
2020-07-09 00:03:53.70 Server      * CRYPT32                        76C60000  76D5AFFF  000fb000
2020-07-09 00:03:53.70 Server      * MSASN1                         74E20000  74E2DFFF  0000e000
2020-07-09 00:03:53.70 Server      * PSAPI                          75050000  75055FFF  00006000
2020-07-09 00:03:53.70 Server      * WS2_32                         76130000  7618DFFF  0005e000
2020-07-09 00:03:53.70 Server      * sqldk                          5ABF0000  5AFCEFFF  003df000
2020-07-09 00:03:53.70 Server      * Secur32                        6F9A0000  6F9A9FFF  0000a000
2020-07-09 00:03:53.70 Server      * USERENV                        6F7C0000  6F7DDFFF  0001e000
2020-07-09 00:03:53.70 Server      * profapi                        76890000  768AAFFF  0001b000
2020-07-09 00:03:53.70 Server      * AUTHZ                          64990000  649C1FFF  00032000
2020-07-09 00:03:53.70 Server      * WINMM                          6F9B0000  6F9D3FFF  00024000
2020-07-09 00:03:53.70 Server      * NETUTILS                       6F950000  6F95AFFF  0000b000
2020-07-09 00:03:53.70 Server      * LOGONCLI                       6E300000  6E330FFF  00031000
2020-07-09 00:03:53.70 Server      * WINMMBASE                      6F960000  6F982FFF  00023000
2020-07-09 00:03:53.70 Server      * cfgmgr32                       74DE0000  74E1AFFF  0003b000
2020-07-09 00:03:53.70 Server      * SAMCLI                         6E2B0000  6E2C4FFF  00015000
2020-07-09 00:03:53.70 Server      * instapi110                     74740000  7474AFFF  0000b000
2020-07-09 00:03:53.70 Server      * wkscli                         6BC00000  6BC0FFFF  00010000
2020-07-09 00:03:53.71 Server      * bcrypt                         75200000  75218FFF  00019000
2020-07-09 00:03:53.71 Server      * cscapi                         6BA70000  6BA7DFFF  0000e000
2020-07-09 00:03:53.71 Server      * sqlevn70                       01C60000  01EDAFFF  0027b000
2020-07-09 00:03:53.71 Server      * CRYPTSP                        75CC0000  75CD2FFF  00013000
2020-07-09 00:03:53.71 Server      * rsaenh                         6F790000  6F7BEFFF  0002f000
2020-07-09 00:03:53.71 Server      * imagehlp                       75220000  7523AFFF  0001b000
2020-07-09 00:03:53.71 Server      * gpapi                          6B360000  6B37DFFF  0001e000
2020-07-09 00:03:53.71 Server      * VERSION                        74510000  74517FFF  00008000
2020-07-09 00:03:53.71 Server      * msv1_0                         67300000  67360FFF  00061000
2020-07-09 00:03:53.71 Server      * NtlmShared                     67010000  67019FFF  0000a000
2020-07-09 00:03:53.71 Server      * cryptdll                       66FF0000  67000FFF  00011000
2020-07-09 00:03:53.71 Server      * Kerberos                       67370000  67437FFF  000c8000
2020-07-09 00:03:53.71 Server      * schannel                       67440000  674B5FFF  00076000
2020-07-09 00:03:53.71 Server      * MSCOREE                        74800000  74851FFF  00052000
2020-07-09 00:03:53.71 Server      * mscoreei                       74770000  747FCFFF  0008d000
2020-07-09 00:03:53.71 Server      * SqlServerSpatial110            64910000  6498EFFF  0007f000
2020-07-09 00:03:53.71 Server      * CLUSAPI                        64840000  64909FFF  000ca000
2020-07-09 00:03:53.71 Server      * DNSAPI                         6CEB0000  6CF42FFF  00093000
2020-07-09 00:03:53.71 Server      * NSI                            76B70000  76B76FFF  00007000
2020-07-09 00:03:53.71 Server      * IPHLPAPI                       74330000  74361FFF  00032000
2020-07-09 00:03:53.71 Server      * RESUTILS                       64790000  64808FFF  00079000
2020-07-09 00:03:53.71 Server      * security                       09580000  09582FFF  00003000
2020-07-09 00:03:53.71 Server      * BatchParser                    68B70000  68B91FFF  00022000
2020-07-09 00:03:53.71 Server      * DPAPI                          74320000  74327FFF  00008000
2020-07-09 00:03:53.71 Server      * kernel.appcore                 759E0000  759EEFFF  0000f000
2020-07-09 00:03:53.71 Server      * clbcatq                        75960000  759DFFFF  00080000
2020-07-09 00:03:53.71 Server      * sqlncli11                      5A530000  5A80DFFF  002de000
2020-07-09 00:03:53.71 Server      * COMDLG32                       767E0000  7688FFFF  000b0000
2020-07-09 00:03:53.71 Server      * shcore                         74B50000  74BD3FFF  00084000
2020-07-09 00:03:53.71 Server      * SHLWAPI                        76B20000  76B63FFF  00044000
2020-07-09 00:03:53.71 Server      * SHELL32                        753E0000  75958FFF  00579000
2020-07-09 00:03:53.71 Server      * windows.storage                76190000  76755FFF  005c6000
2020-07-09 00:03:53.71 Server      * powrprof                       75000000  75042FFF  00043000
2020-07-09 00:03:53.71 Server      * UMPDC                          75A90000  75A9CFFF  0000d000
2020-07-09 00:03:53.71 Server      * COMCTL32                       6D5C0000  6D64CFFF  0008d000
2020-07-09 00:03:53.71 Server      * SQLNCLIR11                     0D5F0000  0D627FFF  00038000
2020-07-09 00:03:53.71 Server      * netbios                        6F990000  6F999FFF  0000a000
2020-07-09 00:03:53.71 Server      * clr                            70800000  70FAFFFF  007b0000
2020-07-09 00:03:53.71 Server      * ucrtbase_clr0400               6FDC0000  6FE6AFFF  000ab000
2020-07-09 00:03:53.71 Server      * VCRUNTIME140_CLR0400           6FE70000  6FE83FFF  00014000
2020-07-09 00:03:53.71 Server      * SRVCLI                         64330000  6434BFFF  0001c000
2020-07-09 00:03:53.71 Server      * mscorlib.ni                    6E340000  6F74DFFF  0140e000
2020-07-09 00:03:53.71 Server      * ftimport                       60000000  6001CFFF  0001d000
2020-07-09 00:03:53.71 Server      * MSFTE                          49910000  49B68FFF  00259000
2020-07-09 00:03:53.71 Server      * dbghelp                        64640000  64780FFF  00141000
2020-07-09 00:03:53.71 Server      * clrjit                         6E210000  6E298FFF  00089000
2020-07-09 00:03:53.71 Server      * ntmarta                        6F7E0000  6F808FFF  00029000
2020-07-09 00:03:53.71 Server      * ncrypt                         68520000  68540FFF  00021000
2020-07-09 00:03:53.72 Server      * NTASN1                         684F0000  68517FFF  00028000
2020-07-09 00:03:53.72 Server      * mskeyprotect                   64060000  6406FFFF  00010000
2020-07-09 00:03:53.72 Server      * ntdsapi                        66FD0000  66FEBFFF  0001c000
2020-07-09 00:03:53.72 Server      * DSPARSE                        66FC0000  66FC9FFF  0000a000
2020-07-09 00:03:53.72 Server      * ncryptsslp                     64BD0000  64BEEFFF  0001f000
2020-07-09 00:03:53.72 Server      * xpstar                         574F0000  5753DFFF  0004e000
2020-07-09 00:03:53.72 Server      * SQLSCM                         680A0000  680AAFFF  0000b000
2020-07-09 00:03:53.72 Server      * ATL100                         741D0000  741F5FFF  00026000
2020-07-09 00:03:53.72 Server      * ODBC32                         74370000  74408FFF  00099000
2020-07-09 00:03:53.72 Server      * xpstar                         16AD0000  16AF4FFF  00025000
2020-07-09 00:03:53.72 Server      * oledb32                        564B0000  5657AFFF  000cb000
2020-07-09 00:03:53.72 Server      * MSDART                         64BF0000  64C11FFF  00022000
2020-07-09 00:03:53.72 Server      * Comctl32                       660E0000  662EEFFF  0020f000
2020-07-09 00:03:53.72 Server      * comsvcs                        55CE0000  55E33FFF  00154000
2020-07-09 00:03:53.72 Server      * ACEOLEDB                       56690000  566EFFFF  00060000
2020-07-09 00:03:53.72 Server      * VCRUNTIME140                   50060000  50072FFF  00013000
2020-07-09 00:03:53.72 Server      * MSVCP140                       55C70000  55CDEFFF  0006f000
2020-07-09 00:03:53.72 Server      * JitV                           55C20000  55C6BFFF  0004c000
2020-07-09 00:03:53.72 Server      * AppvIsvSubsystems32            55A30000  55C19FFF  001ea000
2020-07-09 00:03:53.72 Server      * c2r32                          55820000  55A22FFF  00203000
2020-07-09 00:03:53.72 Server      * mso20win32client               553B0000  55811FFF  00462000
2020-07-09 00:03:53.72 Server      * mso30win32client               778C0000  77FF4FFF  00735000
2020-07-09 00:03:53.72 Server      * wevtapi                        66E40000  66E82FFF  00043000
2020-07-09 00:03:53.72 Server      * mso40uiwin32client             17050000  17AC2FFF  00a73000
2020-07-09 00:03:53.72 Server      * gdiplus                        65BF0000  65D58FFF  00169000
2020-07-09 00:03:53.72 Server      * mso50win32client               55300000  553AAFFF  000ab000
2020-07-09 00:03:53.72 Server      * mso98win32client               17AD0000  1878FFFF  00cc0000
2020-07-09 00:03:53.72 Server      * WTSAPI32                       74500000  7450EFFF  0000f000
2020-07-09 00:03:53.72 Server      * mso                            18790000  19FDBFFF  0184c000
2020-07-09 00:03:53.72 Server      * msi                            6D070000  6D3D0FFF  00361000
2020-07-09 00:03:53.72 Server      * ACECORE                        55140000  552FAFFF  001bb000
2020-07-09 00:03:53.72 Server      * d2d1                           64FD0000  654BBFFF  004ec000
2020-07-09 00:03:53.72 Server      * dxgi                           6CF80000  6D040FFF  000c1000
2020-07-09 00:03:53.72 Server      * dxcore                         6CF50000  6CF68FFF  00019000
2020-07-09 00:03:53.72 Server      * DWrite                         64D50000  64FCFFFF  00280000
2020-07-09 00:03:53.72 Server      * netprofm                       66E90000  66EC0FFF  00031000
2020-07-09 00:03:53.72 Server      * WINSTA                         6BA80000  6BAC3FFF  00044000
2020-07-09 00:03:53.72 Server      * IMM32                          74890000  748B4FFF  00025000
2020-07-09 00:03:53.72 Server      * davclnt                        64820000  64838FFF  00019000
2020-07-09 00:03:53.72 Server      * DAVHLPR                        64100000  64109FFF  0000a000
2020-07-09 00:03:53.72 Server      * d3d11                          65F00000  660DDFFF  001de000
2020-07-09 00:03:53.72 Server      * npmproxy                       66DD0000  66DD8FFF  00009000
2020-07-09 00:03:53.72 Server      * Normaliz                       767B0000  767B6FFF  00007000
2020-07-09 00:03:53.72 Server      * WINHTTP                        74440000  744FCFFF  000bd000
2020-07-09 00:03:53.72 Server      * dhcpcsvc6                      6A830000  6A842FFF  00013000
2020-07-09 00:03:53.72 Server      * dhcpcsvc                       6A810000  6A824FFF  00015000
2020-07-09 00:03:53.72 Server      * urlmon                         682F0000  68499FFF  001aa000
2020-07-09 00:03:53.72 Server      * iertutil                       680C0000  682E8FFF  00229000
2020-07-09 00:03:53.72 Server      * srpapi                         5B460000  5B485FFF  00026000
2020-07-09 00:03:53.73 Server      * ACEWSTR                        54F70000  55044FFF  000d5000
2020-07-09 00:03:53.73 Server      * WININET                        663E0000  6683AFFF  0045b000
2020-07-09 00:03:53.73 Server      * ondemandconnroutehelper        663C0000  663D1FFF  00012000
2020-07-09 00:03:53.73 Server      * mswsock                        70660000  706B1FFF  00052000
2020-07-09 00:03:53.73 Server      * WINNSI                         6A780000  6A787FFF  00008000
2020-07-09 00:03:53.73 Server      * webio                          6A790000  6A806FFF  00077000
2020-07-09 00:03:53.73 Server      * rasadhlp                       6CEA0000  6CEA7FFF  00008000
2020-07-09 00:03:53.73 Server      * fwpuclnt                       6CE40000  6CE90FFF  00051000
2020-07-09 00:03:53.73 Server      * d3d10warp                      530A0000  5363BFFF  0059c000
2020-07-09 00:03:53.73 Server      * dbghelp                        54380000  544C0FFF  00141000
2020-07-09 00:03:53.73 Server      *
2020-07-09 00:03:53.73 Server      *        Edi: 0209D730:  1A3DBFC8  00000000  00000000  00000000  00000000  00000000  
2020-07-09 00:03:53.73 Server      *        Esi: 00000000:  
2020-07-09 00:03:53.73 Server      *        Eax: 0209D668:  000042AC  00000000  00000000  74CF4402  00000000  0209D6B0  
2020-07-09 00:03:53.73 Server      *        Ebx: 0000003F:  
2020-07-09 00:03:53.73 Server      *        Ecx: 00000000:  
2020-07-09 00:03:53.73 Server      *        Edx: 0000003F:  
2020-07-09 00:03:53.73 Server      *        Eip: 74CF4402:  54244C8B  C3E8CC33  8B0001C0  10C25DE5  24648300  DEEB0010  
2020-07-09 00:03:53.73 Server      *        Ebp: 0209D6C4:  0209D70C  793A6B64  000042AC  00000000  00000000  00000000  
2020-07-09 00:03:53.73 Server      *      SegCs: 00000023:  
2020-07-09 00:03:53.73 Server      *     EFlags: 00000246:  
2020-07-09 00:03:53.73 Server      *        Esp: 0209D668:  000042AC  00000000  00000000  74CF4402  00000000  0209D6B0  
2020-07-09 00:03:53.73 Server      *      SegSs: 0000002B:  
2020-07-09 00:03:53.73 Server      * *******************************************************************************
2020-07-09 00:03:53.73 Server      *
2020-07-09 00:03:53.73 Server      * Short Stack Dump
2020-07-09 00:03:53.73 Server      74CF4402 Module(KERNELBASE+00114402)
2020-07-09 00:03:53.74 Server      793A6B64 Module(sqllang+00F26B64)
2020-07-09 00:03:53.74 Server      793AAD91 Module(sqllang+00F2AD91)
2020-07-09 00:03:53.74 Server      793AA75B Module(sqllang+00F2A75B)
2020-07-09 00:03:53.74 Server      5ACA7392 Module(sqldk+000B7392)
2020-07-09 00:03:53.74 Server      74D8BA90 Module(KERNELBASE+001ABA90)
2020-07-09 00:03:53.74 Server      771429B8 Module(ntdll+000A29B8)
2020-07-09 00:03:53.74 Server      77107BF4 Module(ntdll+00067BF4)
2020-07-09 00:03:53.75 Server      Stack Signature for the dump is 0x256441C4
2020-07-09 00:03:54.57 Server      External dump process return code 0x20000001.
External dump process returned no errors.

                              
Memory                               
MemoryLoad = 35%                     
Total Physical = 16193 MB            
Available Physical = 10401 MB        
Total Page File = 19137 MB           
Available Page File = 12880 MB       
Total Virtual = 4095 MB              
Available Virtual = 3232 MB          
**Dump thread - spid = 0, EC = 0x00000000                                                                        
***Stack Dump being sent to c:\Program Files (x86)\Microsoft SQL Server\MSSQL11.XXX\MSSQL\LOG\SQLDump0014.txt 
* *******************************************************************************                                
*                                                                                                                

All replies (9)

Thursday, July 9, 2020 7:33 AM

Hi Leslie,

Please post the results of SELECT @@VERSION.

You could run DBCC CHECKDB (yourdb) WITH ALL_ERRORMSGS, NO_INFOMSGS on the databases your application uses. If they all come back clean, then you could call Product Support who will help diagnose the problem you've run into using the dump file that was generated when you hit the AV.

You could also refer to Karthick P.K's blog about how to analyze and resolve SQL Server exceptions and assertions issue.

If this is SQL Server related, maybe you could also ask professional engineers for help, and they will deal with your problem separately and confidentially:
https://support.microsoft.com/en-us/assistedsupportproducts

Please also refer below link for more details:

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/63e1d6a8-12f9-4b98-a39d-339ea11765ad/issue-in-sql-server-2016?forum=sqldatabaseengine

Best regards,

Melissa

MSDN Community Support

Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com


Thursday, July 9, 2020 7:48 AM

Your exception could most likely be due to the linked server you have created and you are using openrowset to fetch data from the third party database. Am i correct to assume that the other database from which you are pulling data is NOT a Microsoft SQL Server ?

Do you also get this exception apart from using this query ? If you do not them, then this linked server is what causing the issue

Cheers,

Shashank

Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

My TechNet Wiki Articles
MVP


Thursday, July 9, 2020 9:00 PM

Crash dumps like these are difficult to sort out on your own. Often they are due to bugs in SQL Server.

You have two statements. Have you determined exactly which of these statements that causes the crash?

There is one thing in your code that looks odd to me. You  seem to use the ACE provider to read dBase files. I have not worked with the ACE provider, but I was under the impression that it is for accessing Excel files and Access databases. Does it really support dBase as well?

Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se


Thursday, July 9, 2020 9:07 PM

For VFP files we can use https://www.microsoft.com/en-us/download/details.aspx?id=14839 (VFPOleDB), but I'm not sure what is actually used for old DBF files coming from DBase. 

For every expert, there is an equal and opposite expert. - Becker's Law

My blog

My TechNet articles


Wednesday, July 15, 2020 8:32 AM

Hi Leslie,

Could you please provide any update about this error?

This thread has been around for a period of time. Please remember to mark the replies as answers if they helped. Your action would be helpful to other users who encounter the same issue and read this thread. Thank you for understanding! 

Best regards,

Melissa

MSDN Community Support

Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.


Wednesday, July 15, 2020 12:49 PM

Hi Erland, 

The issue ended up getting resolved after I reinstalled the Access Database Engine. It must have gotten corrupted or something. 

To your question about ACE, the only way, AFAIK, to read DBF files into SQL server is through the Access Database Engine because Access has a legacy feature of reading DBF files.

Thank you so much!

Leslie 


Wednesday, July 15, 2020 1:52 PM

Hi Leslie,

I think it depends on what kind of DBF files they are. If they, say, latest Visual Foxpro files, then there are other drivers you can use. For details you may want to ask the question in Visual Foxpro forum here.

If they are somehow old FoxPro files or Clipper files or DBase, then you probably right using Access as a driver.

For every expert, there is an equal and opposite expert. - Becker's Law

My blog

My TechNet articles


Wednesday, July 15, 2020 2:05 PM

Thank you for clarifying. Yes I'm using old Fox Pro files. I tried the other driver and they didn't work on my files.


Wednesday, July 15, 2020 3:28 PM

Hi

First check whetger the  command EXEC xp_cmdshell 'dir *.exe';   is running or not 
If did not run you shoud give permission as per bellow instructions
 
-- To allow advanced options to be changed.  
EXECUTE sp_configure 'show advanced options', 1;  
GO  
-- To update the currently configured value for advanced options.  
RECONFIGURE;  
GO  
-- To enable the feature.  
EXECUTE sp_configure 'xp_cmdshell', 1;  
GO  
-- To update the currently configured value for this feature.  
RECONFIGURE;  
GO  

In Management Studio, using the master database, execute the GRANT exec ON xp_cmdshell TO N'<some_user>';

For get current user name bellow is the query

SELECT CURRENT_USER;  
GO  

For grant command bellow is the query

GRANT exec ON xp_cmdshell TO dbo


After that you can run the command

Because malicious users sometimes attempt to elevate their privileges by using xp_cmdshell, xp_cmdshell is disabled by default. 
Use sp_configure or Policy Based Management to enable it. For more information, see

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/d859372a-7d3c-4dd0-b3ff-4c490489c840/sql-server-is-terminating-because-of-fatal-exception-c0000005?forum=sqldataaccess


https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/xp-cmdshell-server-configuration-option?view=sql-server-ver15

Configuration for 2014

https://www.daktronics.com/support/kb/Pages/DD3360274.aspx

Thanks and Regards