error: Exception occurred: 0xC0000005 (Access Violation)

Started by vosey · 2020-02-06 09:58 UTC · 2 replies · SMF topic #2716

I frequently experiencing a problem when using ADOLisp_ConnecttoDB.  I sometimes am unable to connect, and the following message appears at the AutoCAD Command Line : error: Exception occurred: 0xC0000005 (Access Violation), however, if I restart AutoCAD, it will then generally work fine (but not always).
(setq sConn (strcat "Provider=Microsoft.ACE.OLEDB.16.0" ";Data Source=" fn ";;;"))
(setq ccname (ADOLISP_ConnectToDB sconn "" ""))
; error: Exception occurred: 0xC0000005 (Access Violation)
; warning: unwind skipped on unknown exception
Sorry - accidentally hit post before completing my message... 
I am frequently experiencing a problem when using ADOLisp_ConnecttoDB.  I sometimes am unable to connect, and the following message appears at the AutoCAD Command Line : error: Exception occurred: 0xC0000005 (Access Violation), however, if I restart AutoCAD, it will then generally work fine (but not always).  This is what's fed into Autocad..
(setq sConn "Provider=Microsoft.ACE.OLEDB.16.0;Data Source=H:\\CAD\\295_PIPELINE\\VLine_2011\\program\\godata.mdb;;;")
Command: (setq ccname (ADOLISP_ConnectToDB sconn "" ""))
                        ; error: Exception occurred: 0xC0000005 (Access Violation)
                        ; warning: unwind skipped on unknown exception
But After Restarting AutoCAD I get..
(setq sConn "Provider=Microsoft.ACE.OLEDB.16.0;Data Source=H:\\CAD\\295_PIPELINE\\VLine_2011\\program\\godata.mdb;;;")
Command: (setq ccname (ADOLISP_ConnectToDB sconn "" ""))
#

Using ODCL 9.0.3.0
AutoCAD Map 3D 2019
Windows 10

If anyone can suggest a potential problem please let me know..  Others in my Office are experiencing the same issue - Thanks.
I suggest asking about this at {2}, where you're more likely to find other developers using ADO.